PREVIEW / etf_1hour / 2011-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-13.parquet
  size:    177 KB
  rows:    5,451

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-04-13 04:00:00	SPY	ETF	131.65	131.9	131.65	131.87	5850.0
2011-04-13 05:00:00	SPY	ETF	131.77	131.98	131.77	131.98	14075.0
2011-04-13 06:00:00	SPY	ETF	131.98	132.08	131.95	132.06	111350.0
2011-04-13 07:00:00	SPY	ETF	132.06	132.29	131.88	132.16	1483082.0
2011-04-13 08:00:00	SPY	ETF	132.15	132.29	132.0	132.21	1835308.0
2011-04-13 09:00:00	SPY	ETF	132.21	132.21	131.74	131.78	19797661.0
2011-04-13 10:00:00	SPY	ETF	131.77	132.06	131.53	131.97	25310550.0
2011-04-13 11:00:00	SPY	ETF	131.98	131.98	131.25	131.27	16862717.0
2011-04-13 12:00:00	SPY	ETF	131.28	131.5	130.96	131.18	16824419.0
2011-04-13 13:00:00	SPY	ETF	131.17	131.38	131.05	131.14	12151399.0
2011-04-13 14:00:00	SPY	ETF	131.14	131.65	131.05	131.58	17680015.0
2011-04-13 15:00:00	SPY	ETF	131.58	131.81	131.44	131.46	30117967.0
2011-04-13 16:00:00	SPY	ETF	131.46	131.5015	131.28	131.29	18964347.0
2011-04-13 17:00:00	SPY	ETF	131.29	131.33	131.21	131.27	160438.0
2011-04-13 18:00:00	SPY	ETF	131.26	131.49	131.07	131.12	147550.0
2011-04-13 19:00:00	SPY	ETF	131.12	131.21	131.04	131.19	95474.0
2011-04-13 04:00:00	QQQ	ETF	56.52	56.58	56.52	56.58	842.0
2011-04-13 05:00:00	QQQ	ETF	56.58	56.63	56.57	56.63	300.0
2011-04-13 06:00:00	QQQ	ETF	56.65	56.72	56.65	56.72	15864.0
2011-04-13 07:00:00	QQQ	ETF	56.68	56.87	56.67	56.8	251169.0
2011-04-13 08:00:00	QQQ	ETF	56.79	56.84	56.76	56.79	331623.0
2011-04-13 09:00:00	QQQ	ETF	56.78	56.83	56.67	56.7	5516466.0
2011-04-13 10:00:00	QQQ	ETF	56.69	57.0	56.58	56.97	8326676.0
2011-04-13 11:00:00	QQQ	ETF	56.97	56.9799	56.58	56.59	4675019.0
2011-04-13 12:00:00	QQQ	ETF	56.59	56.7287	56.4	56.54	4779684.0
2011-04-13 13:00:00	QQQ	ETF	56.5338	56.64	56.46	56.51	3983019.0
2011-04-13 14:00:00	QQQ	ETF	56.5129	56.84	56.51	56.8	5810927.0
2011-04-13 15:00:00	QQQ	ETF	56.8	56.92	56.77	56.84	7091306.0
2011-04-13 16:00:00	QQQ	ETF	56.84	56.86	56.72	56.72	1165365.0
2011-04-13 17:00:00	QQQ	ETF	56.75	56.75	56.71	56.74	10743.0
2011-04-13 18:00:00	QQQ	ETF	56.71	56.85	56.68	56.7	63319.0
2011-04-13 19:00:00	QQQ	ETF	56.69	56.71	56.64	56.69	17200.0
2011-04-13 04:00:00	IWM	ETF	82.46	82.46	82.46	82.46	24000.0
2011-04-13 05:00:00	IWM	ETF	82.45	82.5	82.43	82.5	11760.0
2011-04-13 06:00:00	IWM	ETF	82.49	82.61	82.49	82.61	34042.0
2011-04-13 07:00:00	IWM	ETF	82.55	82.72	82.5	82.68	174549.0
2011-04-13 08:00:00	IWM	ETF	82.68	82.75	82.62	82.64	260194.0
2011-04-13 09:00:00	IWM	ETF	82.64	82.81	82.39	82.41	5668835.0
2011-04-13 10:00:00	IWM	ETF	82.4	82.79	82.24	82.62	7619697.0
2011-04-13 11:00:00	IWM	ETF	82.62	82.65	82.0	82.03	8905814.0
2011-04-13 12:00:00	IWM	ETF	82.03	82.38	81.73	81.815	7975661.0
2011-04-13 13:00:00	IWM	ETF	81.82	81.91	81.67	81.73	8927985.0
2011-04-13 14:00:00	IWM	ETF	81.74	82.36	81.7	82.3	11596284.0
2011-04-13 15:00:00	IWM	ETF	82.3	82.46	82.19	82.24	9628211.0
2011-04-13 16:00:00	IWM	ETF	82.24	82.31	81.8	82.19	6792766.0
2011-04-13 17:00:00	IWM	ETF	82.18	82.18	82.14	82.14	4000.0
2011-04-13 18:00:00	IWM	ETF	82.18	82.19	82.14	82.14	5500.0
2011-04-13 19:00:00	IWM	ETF	82.13	82.14	82.08	82.14	2000.0
2011-04-13 04:00:00	DIA	ETF	122.72	122.72	122.72	122.72	100.0
2011-04-13 06:00:00	DIA	ETF	122.95	122.96	122.94	122.94	20000.0

> showing 50 of 5,451 rows — these rows as CSV

> unlock the full archive -- $79 one-time