PREVIEW / etf_30min / 2011-02-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-07.parquet
  size:    277 KB
  rows:    9,311

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-02-07 04:00:00	SPY	ETF	131.64	131.68	131.6	131.6	475.0
2011-02-07 04:30:00	SPY	ETF	131.7	131.76	131.7	131.76	700.0
2011-02-07 05:00:00	SPY	ETF	131.71	131.71	131.71	131.71	4000.0
2011-02-07 06:00:00	SPY	ETF	131.61	131.61	131.51	131.51	1300.0
2011-02-07 06:30:00	SPY	ETF	131.53	131.55	131.52	131.55	10099.0
2011-02-07 07:00:00	SPY	ETF	131.53	131.57	131.42	131.45	892924.0
2011-02-07 07:30:00	SPY	ETF	131.44	131.51	131.42	131.46	925560.0
2011-02-07 08:00:00	SPY	ETF	131.47	131.64	131.43	131.56	2294380.0
2011-02-07 08:30:00	SPY	ETF	131.54	131.79	131.43	131.48	606006.0
2011-02-07 09:00:00	SPY	ETF	131.48	131.51	131.19	131.44	515934.0
2011-02-07 09:30:00	SPY	ETF	131.44	131.86	131.43	131.725	14668833.0
2011-02-07 10:00:00	SPY	ETF	131.73	132.19	131.72	132.07	11030463.0
2011-02-07 10:30:00	SPY	ETF	132.07	132.31	132.07	132.235	7358112.0
2011-02-07 11:00:00	SPY	ETF	132.23	132.36	132.15	132.24	8156560.0
2011-02-07 11:30:00	SPY	ETF	132.24	132.4	132.21	132.23	5815349.0
2011-02-07 12:00:00	SPY	ETF	132.235	132.25	132.1	132.12	4576199.0
2011-02-07 12:30:00	SPY	ETF	132.1299	132.28	132.1	132.16	4474236.0
2011-02-07 13:00:00	SPY	ETF	132.15	132.28	132.15	132.248	3621460.0
2011-02-07 13:30:00	SPY	ETF	132.25	132.27	132.14	132.24	2944852.0
2011-02-07 14:00:00	SPY	ETF	132.24	132.26	132.05	132.07	3894230.0
2011-02-07 14:30:00	SPY	ETF	132.07	132.12	131.86	131.97	6546762.0
2011-02-07 15:00:00	SPY	ETF	131.97	132.03	131.75	131.89	8476177.0
2011-02-07 15:30:00	SPY	ETF	131.88	132.11	131.86	131.98	14785286.0
2011-02-07 16:00:00	SPY	ETF	131.98	132.33	131.1857	131.95	8674970.0
2011-02-07 16:30:00	SPY	ETF	131.94	131.95	131.7769	131.86	1910734.0
2011-02-07 17:00:00	SPY	ETF	131.86	131.92	131.85	131.9	36819.0
2011-02-07 17:30:00	SPY	ETF	131.89	131.96	131.84	131.91	63210.0
2011-02-07 18:00:00	SPY	ETF	131.91	132.0	131.9	131.94	25355.0
2011-02-07 18:30:00	SPY	ETF	131.96	131.99	131.94	131.98	19297.0
2011-02-07 19:00:00	SPY	ETF	131.99	132.0	131.9	131.92	34887.0
2011-02-07 19:30:00	SPY	ETF	131.93	131.97	131.88	131.95	33678.0
2011-02-07 04:00:00	QQQ	ETF	57.51	57.51	57.51	57.51	200.0
2011-02-07 04:30:00	QQQ	ETF	57.62	57.62	57.62	57.62	600.0
2011-02-07 05:00:00	QQQ	ETF	57.6	57.6	57.6	57.6	100.0
2011-02-07 05:30:00	QQQ	ETF	57.6	57.6	57.6	57.6	500.0
2011-02-07 07:00:00	QQQ	ETF	57.56	57.56	57.51	57.51	5000.0
2011-02-07 07:30:00	QQQ	ETF	57.51	57.51	57.48	57.48	22470.0
2011-02-07 08:00:00	QQQ	ETF	57.51	57.52	57.44	57.51	3016806.0
2011-02-07 08:30:00	QQQ	ETF	57.51	57.55	57.47	57.48	250119.0
2011-02-07 09:00:00	QQQ	ETF	57.48	57.51	57.47	57.48	344599.0
2011-02-07 09:30:00	QQQ	ETF	57.49	57.62	57.4	57.54	7156746.0
2011-02-07 10:00:00	QQQ	ETF	57.55	57.755	57.55	57.712	3914613.0
2011-02-07 10:30:00	QQQ	ETF	57.711	57.79	57.69	57.77	1747402.0
2011-02-07 11:00:00	QQQ	ETF	57.77	57.91	57.7699	57.86	3104835.0
2011-02-07 11:30:00	QQQ	ETF	57.86	57.94	57.83	57.85	1747934.0
2011-02-07 12:00:00	QQQ	ETF	57.85	57.89	57.8211	57.84	1383603.0
2011-02-07 12:30:00	QQQ	ETF	57.842	57.97	57.84	57.88	1163960.0
2011-02-07 13:00:00	QQQ	ETF	57.89	57.95	57.89	57.9	798718.0
2011-02-07 13:30:00	QQQ	ETF	57.9	57.91	57.82	57.86	1346347.0
2011-02-07 14:00:00	QQQ	ETF	57.87	57.88	57.81	57.81	923783.0

> showing 50 of 9,311 rows — these rows as CSV

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