PREVIEW / etf_30min / 2011-07-15

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-15.parquet
  size:    271 KB
  rows:    9,100

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-07-15 04:00:00	SPY	ETF	131.01	131.01	130.92	130.92	300.0
2011-07-15 04:30:00	SPY	ETF	130.95	131.22	130.93	131.21	1400.0
2011-07-15 05:00:00	SPY	ETF	131.08	131.29	131.08	131.29	700.0
2011-07-15 05:30:00	SPY	ETF	131.27	131.39	131.27	131.36	2100.0
2011-07-15 06:00:00	SPY	ETF	131.19	131.22	131.19	131.22	1000.0
2011-07-15 06:30:00	SPY	ETF	131.26	131.36	131.17	131.24	32500.0
2011-07-15 07:00:00	SPY	ETF	131.25	131.33	131.17	131.31	83005.0
2011-07-15 07:30:00	SPY	ETF	131.31	131.56	131.29	131.48	227200.0
2011-07-15 08:00:00	SPY	ETF	131.44	131.69	131.28	131.41	1713608.0
2011-07-15 08:30:00	SPY	ETF	131.4	131.64	131.24	131.57	1864019.0
2011-07-15 09:00:00	SPY	ETF	131.57	131.84	131.52	131.66	2189251.0
2011-07-15 09:30:00	SPY	ETF	131.66	131.87	131.1	131.29	29372395.0
2011-07-15 10:00:00	SPY	ETF	131.29	131.74	130.77	130.94	28127019.0
2011-07-15 10:30:00	SPY	ETF	130.93	131.26	130.78	131.04	18498603.0
2011-07-15 11:00:00	SPY	ETF	131.04	131.45	130.92	131.38	15155298.0
2011-07-15 11:30:00	SPY	ETF	131.38	131.42	131.2	131.24	9180194.0
2011-07-15 12:00:00	SPY	ETF	131.24	131.71	131.22	131.45	14623432.0
2011-07-15 12:30:00	SPY	ETF	131.45	131.52	131.1	131.235	8768833.0
2011-07-15 13:00:00	SPY	ETF	131.24	131.38	131.14	131.31	5368060.0
2011-07-15 13:30:00	SPY	ETF	131.31	131.35	130.97	130.98	6473067.0
2011-07-15 14:00:00	SPY	ETF	130.98	131.16	130.87	130.9068	8030717.0
2011-07-15 14:30:00	SPY	ETF	130.9	131.209	130.84	131.03	9917753.0
2011-07-15 15:00:00	SPY	ETF	131.02	131.54	130.94	131.49	11136124.0
2011-07-15 15:30:00	SPY	ETF	131.485	131.7101	131.43	131.71	22566878.0
2011-07-15 16:00:00	SPY	ETF	131.71	132.04	130.9404	132.0	15361797.0
2011-07-15 16:30:00	SPY	ETF	131.99	132.05	130.9404	132.02	4223239.0
2011-07-15 17:00:00	SPY	ETF	132.02	132.04	132.01	132.02	1148522.0
2011-07-15 17:30:00	SPY	ETF	132.02	132.04	132.01	132.02	216195.0
2011-07-15 18:00:00	SPY	ETF	132.02	132.04	131.67	132.02	1727677.0
2011-07-15 18:30:00	SPY	ETF	132.02	132.02	132.0	132.0	26912.0
2011-07-15 19:00:00	SPY	ETF	132.01	132.04	131.99	132.03	16480.0
2011-07-15 19:30:00	SPY	ETF	132.01	132.04	131.99	132.01	31519.0
2011-07-15 06:00:00	QQQ	ETF	57.5	57.5	57.5	57.5	300.0
2011-07-15 06:30:00	QQQ	ETF	57.49	57.49	57.49	57.49	500.0
2011-07-15 07:00:00	QQQ	ETF	57.47	57.53	57.46	57.53	22600.0
2011-07-15 07:30:00	QQQ	ETF	57.53	57.59	57.53	57.57	77220.0
2011-07-15 08:00:00	QQQ	ETF	57.59	57.64	57.53	57.53	1745228.0
2011-07-15 08:30:00	QQQ	ETF	57.59	57.69	57.52	57.69	964491.0
2011-07-15 09:00:00	QQQ	ETF	57.68	57.83	57.67	57.73	964608.0
2011-07-15 09:30:00	QQQ	ETF	57.72	57.79	57.41	57.48	12976761.0
2011-07-15 10:00:00	QQQ	ETF	57.49	57.7	57.31	57.39	9971327.0
2011-07-15 10:30:00	QQQ	ETF	57.39	57.585	57.35	57.455	4406400.0
2011-07-15 11:00:00	QQQ	ETF	57.45	57.64	57.41	57.59	2155725.0
2011-07-15 11:30:00	QQQ	ETF	57.59	57.63	57.5016	57.51	1402694.0
2011-07-15 12:00:00	QQQ	ETF	57.51	57.71	57.5	57.65	2917660.0
2011-07-15 12:30:00	QQQ	ETF	57.65	57.68	57.5262	57.63	2219376.0
2011-07-15 13:00:00	QQQ	ETF	57.63	57.7	57.58	57.673	999831.0
2011-07-15 13:30:00	QQQ	ETF	57.68	57.695	57.49	57.5	3494943.0
2011-07-15 14:00:00	QQQ	ETF	57.5	57.58	57.43	57.44	3903534.0
2011-07-15 14:30:00	QQQ	ETF	57.43	57.55	57.41	57.48	3165539.0

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

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