PREVIEW / etf_30min / 2012-04-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-11.parquet
  size:    280 KB
  rows:    9,684

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
2012-04-11 04:00:00	SPY	ETF	136.48	136.89	136.47	136.88	6215.0
2012-04-11 04:30:00	SPY	ETF	136.92	136.97	136.78	136.78	31860.0
2012-04-11 05:00:00	SPY	ETF	136.87	137.01	136.84	137.01	21400.0
2012-04-11 05:30:00	SPY	ETF	137.01	137.32	136.9	137.32	18170.0
2012-04-11 06:00:00	SPY	ETF	137.29	137.35	137.19	137.21	66121.0
2012-04-11 06:30:00	SPY	ETF	137.21	137.32	137.2	137.32	57262.0
2012-04-11 07:00:00	SPY	ETF	137.3	137.43	137.22	137.37	783166.0
2012-04-11 07:30:00	SPY	ETF	137.37	137.37	137.11	137.15	604510.0
2012-04-11 08:00:00	SPY	ETF	137.14	137.36	137.06	137.17	866251.0
2012-04-11 08:30:00	SPY	ETF	137.16	137.33	137.07	137.21	1593079.0
2012-04-11 09:00:00	SPY	ETF	137.22	137.38	137.14	137.29	940038.0
2012-04-11 09:30:00	SPY	ETF	137.29	137.43	137.03	137.12	21570132.0
2012-04-11 10:00:00	SPY	ETF	137.13	137.48	137.11	137.38	13879740.0
2012-04-11 10:30:00	SPY	ETF	137.38	137.54	137.2	137.305	10353126.0
2012-04-11 11:00:00	SPY	ETF	137.32	137.34	137.08	137.13	7940539.0
2012-04-11 11:30:00	SPY	ETF	137.125	137.25	136.92	136.9395	7973057.0
2012-04-11 12:00:00	SPY	ETF	136.93	137.17	136.89	137.1381	7948674.0
2012-04-11 12:30:00	SPY	ETF	137.14	137.31	137.09	137.31	4277488.0
2012-04-11 13:00:00	SPY	ETF	137.31	137.33	137.1	137.16	6244167.0
2012-04-11 13:30:00	SPY	ETF	137.16	137.405	137.06	137.32	5528584.0
2012-04-11 14:00:00	SPY	ETF	137.32	137.35	137.08	137.174	6311149.0
2012-04-11 14:30:00	SPY	ETF	137.175	137.19	136.93	137.09	9316483.0
2012-04-11 15:00:00	SPY	ETF	137.09	137.15	136.78	136.89	9851819.0
2012-04-11 15:30:00	SPY	ETF	136.89	137.0	136.75	136.94	21843050.0
2012-04-11 16:00:00	SPY	ETF	136.92	137.1523	136.85	136.91	9805430.0
2012-04-11 16:30:00	SPY	ETF	136.92	137.03	136.91	137.03	3247105.0
2012-04-11 17:00:00	SPY	ETF	137.02	137.04	136.99	137.01	645039.0
2012-04-11 17:30:00	SPY	ETF	137.02	137.04	136.99	137.0	10470.0
2012-04-11 18:00:00	SPY	ETF	137.01	137.1	137.0	137.09	49662.0
2012-04-11 18:30:00	SPY	ETF	137.08	137.22	137.06	137.18	109069.0
2012-04-11 19:00:00	SPY	ETF	137.19	137.26	137.17	137.24	40975.0
2012-04-11 19:30:00	SPY	ETF	137.23	137.24	137.01	137.03	635762.0
2012-04-11 05:00:00	QQQ	ETF	66.46	66.46	66.46	66.46	200.0
2012-04-11 05:30:00	QQQ	ETF	66.55	66.66	66.55	66.66	2200.0
2012-04-11 06:00:00	QQQ	ETF	66.67	66.67	66.67	66.67	100.0
2012-04-11 06:30:00	QQQ	ETF	66.65	66.69	66.65	66.68	14325.0
2012-04-11 07:00:00	QQQ	ETF	66.7	66.77	66.68	66.74	98822.0
2012-04-11 07:30:00	QQQ	ETF	66.75	66.75	66.64	66.64	174309.0
2012-04-11 08:00:00	QQQ	ETF	66.65	66.68	66.61	66.67	157475.0
2012-04-11 08:30:00	QQQ	ETF	66.68	66.71	66.61	66.65	435599.0
2012-04-11 09:00:00	QQQ	ETF	66.67	66.72	66.63	66.71	763990.0
2012-04-11 09:30:00	QQQ	ETF	66.71	66.74	66.46	66.63	7987321.0
2012-04-11 10:00:00	QQQ	ETF	66.63	66.7754	66.62	66.74	5058594.0
2012-04-11 10:30:00	QQQ	ETF	66.73	66.89	66.73	66.8	7817759.0
2012-04-11 11:00:00	QQQ	ETF	66.81	66.83	66.67	66.68	2577288.0
2012-04-11 11:30:00	QQQ	ETF	66.68	66.76	66.55	66.57	3463688.0
2012-04-11 12:00:00	QQQ	ETF	66.57	66.65	66.45	66.6184	3490380.0
2012-04-11 12:30:00	QQQ	ETF	66.62	66.62	66.51	66.61	2422650.0
2012-04-11 13:00:00	QQQ	ETF	66.61	66.68	66.54	66.585	4525715.0
2012-04-11 13:30:00	QQQ	ETF	66.59	66.63	66.5	66.6	2775683.0

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

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