PREVIEW / etf_30min / 2012-02-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-24.parquet
  size:    275 KB
  rows:    9,373

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-02-24 04:00:00	SPY	ETF	137.0	137.29	137.0	137.1	26466.0
2012-02-24 04:30:00	SPY	ETF	137.1	137.25	137.1	137.21	5600.0
2012-02-24 05:00:00	SPY	ETF	137.21	137.29	137.2	137.2	49000.0
2012-02-24 05:30:00	SPY	ETF	137.14	137.16	137.09	137.09	19600.0
2012-02-24 06:00:00	SPY	ETF	137.1	137.21	137.1	137.21	32850.0
2012-02-24 06:30:00	SPY	ETF	137.18	137.2	137.13	137.17	17100.0
2012-02-24 07:00:00	SPY	ETF	137.17	137.23	137.12	137.16	109850.0
2012-02-24 07:30:00	SPY	ETF	137.17	137.18	137.0	137.02	93047.0
2012-02-24 08:00:00	SPY	ETF	137.03	137.2	136.89	136.92	332746.0
2012-02-24 08:30:00	SPY	ETF	136.92	137.02	136.92	137.0	425026.0
2012-02-24 09:00:00	SPY	ETF	137.0	137.0	136.89	136.93	642119.0
2012-02-24 09:30:00	SPY	ETF	136.93	137.02	136.73	136.98	15061532.0
2012-02-24 10:00:00	SPY	ETF	136.97	137.09	136.78	136.84	10507494.0
2012-02-24 10:30:00	SPY	ETF	136.85	136.95	136.77	136.82	6362575.0
2012-02-24 11:00:00	SPY	ETF	136.83	137.07	136.81	137.05	8469899.0
2012-02-24 11:30:00	SPY	ETF	137.06	137.16	137.01	137.15	6189859.0
2012-02-24 12:00:00	SPY	ETF	137.1562	137.17	137.09	137.14	3084659.0
2012-02-24 12:30:00	SPY	ETF	137.13	137.17	137.09	137.12	4258893.0
2012-02-24 13:00:00	SPY	ETF	137.115	137.2	137.03	137.031	5946529.0
2012-02-24 13:30:00	SPY	ETF	137.035	137.07	136.865	136.98	5990256.0
2012-02-24 14:00:00	SPY	ETF	136.98	137.04	136.81	136.82	4387064.0
2012-02-24 14:30:00	SPY	ETF	136.81	136.83	136.63	136.76	7858276.0
2012-02-24 15:00:00	SPY	ETF	136.7725	136.85	136.74	136.785	4952101.0
2012-02-24 15:30:00	SPY	ETF	136.7838	136.9	136.69	136.87	15800394.0
2012-02-24 16:00:00	SPY	ETF	136.88	136.93	136.78	136.83	3888257.0
2012-02-24 16:30:00	SPY	ETF	136.84	136.84	136.77	136.8	390210.0
2012-02-24 17:00:00	SPY	ETF	136.8	136.86	136.78	136.8	52463.0
2012-02-24 17:30:00	SPY	ETF	136.8	136.93	136.79	136.88	58473.0
2012-02-24 18:00:00	SPY	ETF	136.88	136.91	136.84	136.9	18600.0
2012-02-24 18:30:00	SPY	ETF	136.87	136.91	136.87	136.88	6175.0
2012-02-24 19:00:00	SPY	ETF	136.89	136.89	136.85	136.85	4575.0
2012-02-24 19:30:00	SPY	ETF	136.86	136.94	136.85	136.94	35200.0
2012-02-24 05:30:00	QQQ	ETF	63.96	63.96	63.96	63.96	200.0
2012-02-24 06:00:00	QQQ	ETF	64.01	64.02	64.01	64.01	3150.0
2012-02-24 07:00:00	QQQ	ETF	63.98	64.03	63.97	64.01	8000.0
2012-02-24 07:30:00	QQQ	ETF	64.0	64.0	63.9	63.91	42200.0
2012-02-24 08:00:00	QQQ	ETF	63.91	63.94	63.89	63.9	94914.0
2012-02-24 08:30:00	QQQ	ETF	63.91	63.93	63.9	63.92	63086.0
2012-02-24 09:00:00	QQQ	ETF	63.91	63.94	63.86	63.91	160172.0
2012-02-24 09:30:00	QQQ	ETF	63.92	63.96	63.81	63.92	5060006.0
2012-02-24 10:00:00	QQQ	ETF	63.92	63.98	63.8	63.848	3561201.0
2012-02-24 10:30:00	QQQ	ETF	63.84	63.88	63.81	63.82	2444623.0
2012-02-24 11:00:00	QQQ	ETF	63.82	63.99	63.81	63.98	2923625.0
2012-02-24 11:30:00	QQQ	ETF	63.98	64.01	63.94	64.0	1835820.0
2012-02-24 12:00:00	QQQ	ETF	64.0007	64.03	63.98	64.01	1109638.0
2012-02-24 12:30:00	QQQ	ETF	64.01	64.07	63.98	64.04	1470635.0
2012-02-24 13:00:00	QQQ	ETF	64.04	64.07	63.99	63.99	2094567.0
2012-02-24 13:30:00	QQQ	ETF	64.0	64.02	63.96	63.99	2002376.0
2012-02-24 14:00:00	QQQ	ETF	63.99	64.05	63.91	63.91	1304575.0
2012-02-24 14:30:00	QQQ	ETF	63.915	63.93	63.83	63.9	2484847.0

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

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