PREVIEW / etf_30min / 2011-06-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-21.parquet
  size:    284 KB
  rows:    9,390

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-06-21 04:00:00	SPY	ETF	128.43	128.43	128.36	128.36	1000.0
2011-06-21 04:30:00	SPY	ETF	128.43	128.43	128.43	128.43	100.0
2011-06-21 05:00:00	SPY	ETF	128.32	128.32	128.32	128.32	100.0
2011-06-21 06:00:00	SPY	ETF	128.27	128.41	128.24	128.41	2500.0
2011-06-21 06:30:00	SPY	ETF	128.38	128.54	128.38	128.41	25934.0
2011-06-21 07:00:00	SPY	ETF	128.46	128.48	128.27	128.43	121575.0
2011-06-21 07:30:00	SPY	ETF	128.4	128.63	128.37	128.53	481810.0
2011-06-21 08:00:00	SPY	ETF	128.51	128.57	128.44	128.53	616514.0
2011-06-21 08:30:00	SPY	ETF	128.52	128.56	128.34	128.4	748204.0
2011-06-21 09:00:00	SPY	ETF	128.4	128.44	128.3	128.37	1175642.0
2011-06-21 09:30:00	SPY	ETF	128.36	128.62	128.19	128.5499	19575815.0
2011-06-21 10:00:00	SPY	ETF	128.54	128.99	128.52	128.9285	16557812.0
2011-06-21 10:30:00	SPY	ETF	128.92	129.17	128.81	129.1	12957841.0
2011-06-21 11:00:00	SPY	ETF	129.11	129.4	129.02	129.36	11910653.0
2011-06-21 11:30:00	SPY	ETF	129.36	129.55	129.34	129.4	14848401.0
2011-06-21 12:00:00	SPY	ETF	129.4	129.48	129.3	129.345	8013064.0
2011-06-21 12:30:00	SPY	ETF	129.345	129.4	129.25	129.36	7089935.0
2011-06-21 13:00:00	SPY	ETF	129.35	129.37	129.12	129.14	13140957.0
2011-06-21 13:30:00	SPY	ETF	129.14	129.24	129.08	129.2	8334444.0
2011-06-21 14:00:00	SPY	ETF	129.2	129.44	129.19	129.42	8366335.0
2011-06-21 14:30:00	SPY	ETF	129.41	129.7	129.38	129.61	15896074.0
2011-06-21 15:00:00	SPY	ETF	129.615	129.65	129.4	129.4	12879269.0
2011-06-21 15:30:00	SPY	ETF	129.4	129.6	129.27	129.45	26064374.0
2011-06-21 16:00:00	SPY	ETF	129.44	129.5	127.7548	129.25	6826029.0
2011-06-21 16:30:00	SPY	ETF	129.25	129.32	127.7548	129.31	1714012.0
2011-06-21 17:00:00	SPY	ETF	129.31	129.36	129.05	129.26	500544.0
2011-06-21 17:30:00	SPY	ETF	129.29	129.92	129.25	129.55	1078568.0
2011-06-21 18:00:00	SPY	ETF	129.5	129.53	129.04	129.25	1178448.0
2011-06-21 18:30:00	SPY	ETF	129.29	129.3	129.2	129.24	89067.0
2011-06-21 19:00:00	SPY	ETF	129.27	129.29	129.13	129.29	57740.0
2011-06-21 19:30:00	SPY	ETF	129.3	129.39	129.28	129.31	169977.0
2011-06-21 05:00:00	QQQ	ETF	54.3	54.3	54.17	54.17	1600.0
2011-06-21 07:00:00	QQQ	ETF	54.27	54.28	54.25	54.28	5638.0
2011-06-21 07:30:00	QQQ	ETF	54.27	54.37	54.27	54.37	3400.0
2011-06-21 08:00:00	QQQ	ETF	54.35	54.36	54.3	54.33	81600.0
2011-06-21 08:30:00	QQQ	ETF	54.33	54.34	54.25	54.29	122571.0
2011-06-21 09:00:00	QQQ	ETF	54.28	54.3	54.24	54.28	210606.0
2011-06-21 09:30:00	QQQ	ETF	54.27	54.49	54.03	54.46	6491202.0
2011-06-21 10:00:00	QQQ	ETF	54.47	54.8	54.45	54.775	4866921.0
2011-06-21 10:30:00	QQQ	ETF	54.7738	54.96	54.73	54.925	4194813.0
2011-06-21 11:00:00	QQQ	ETF	54.925	55.04	54.88	55.02	3966729.0
2011-06-21 11:30:00	QQQ	ETF	55.01	55.13	55.0	55.07	3186272.0
2011-06-21 12:00:00	QQQ	ETF	55.07	55.11	55.01	55.0325	2604435.0
2011-06-21 12:30:00	QQQ	ETF	55.031	55.12	55.0	55.0948	2199581.0
2011-06-21 13:00:00	QQQ	ETF	55.091	55.1006	55.0116	55.04	1645858.0
2011-06-21 13:30:00	QQQ	ETF	55.0399	55.07	55.005	55.031	1411624.0
2011-06-21 14:00:00	QQQ	ETF	55.04	55.14	55.03	55.13	2344818.0
2011-06-21 14:30:00	QQQ	ETF	55.12	55.27	55.11	55.2397	2836686.0
2011-06-21 15:00:00	QQQ	ETF	55.24	55.29	55.16	55.18	4368615.0
2011-06-21 15:30:00	QQQ	ETF	55.175	55.28	55.1	55.225	6549613.0

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

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