PREVIEW / etf_30min / 2012-01-31

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-31.parquet
  size:    291 KB
  rows:    9,716

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-01-31 04:00:00	SPY	ETF	131.82	132.0	131.82	131.95	10750.0
2012-01-31 04:30:00	SPY	ETF	131.93	131.93	131.93	131.93	100.0
2012-01-31 05:00:00	SPY	ETF	132.0	132.02	131.94	132.01	4130.0
2012-01-31 05:30:00	SPY	ETF	132.04	132.14	132.02	132.14	7600.0
2012-01-31 06:00:00	SPY	ETF	132.11	132.17	132.09	132.09	57150.0
2012-01-31 06:30:00	SPY	ETF	132.11	132.11	131.91	131.92	26580.0
2012-01-31 07:00:00	SPY	ETF	131.91	131.98	131.83	131.9	224533.0
2012-01-31 07:30:00	SPY	ETF	131.94	132.03	131.9	131.9	72079.0
2012-01-31 08:00:00	SPY	ETF	131.93	132.0	131.8	131.95	2127831.0
2012-01-31 08:30:00	SPY	ETF	131.94	131.98	131.83	131.91	478748.0
2012-01-31 09:00:00	SPY	ETF	131.89	132.07	131.83	132.01	991201.0
2012-01-31 09:30:00	SPY	ETF	132.02	132.18	131.6	131.83	20953059.0
2012-01-31 10:00:00	SPY	ETF	131.75	131.93	131.17	131.49	17870644.0
2012-01-31 10:30:00	SPY	ETF	131.49	132.02	130.88	131.01	12305402.0
2012-01-31 11:00:00	SPY	ETF	131.01	131.0899	130.71	130.85	10067111.0
2012-01-31 11:30:00	SPY	ETF	130.86	130.96	130.68	130.88	7827918.0
2012-01-31 12:00:00	SPY	ETF	130.87	131.06	130.82	131.0	7196419.0
2012-01-31 12:30:00	SPY	ETF	131.0	131.13	130.97	131.011	3991254.0
2012-01-31 13:00:00	SPY	ETF	131.01	131.26	131.0	131.24	5109405.0
2012-01-31 13:30:00	SPY	ETF	131.25	131.25	130.88	130.97	6234165.0
2012-01-31 14:00:00	SPY	ETF	130.97	131.35	130.88	131.29	10338486.0
2012-01-31 14:30:00	SPY	ETF	131.28	131.32	131.1	131.29	4719398.0
2012-01-31 15:00:00	SPY	ETF	131.29	131.43	131.12	131.38	11739839.0
2012-01-31 15:30:00	SPY	ETF	131.38	131.42	131.16	131.24	19674019.0
2012-01-31 16:00:00	SPY	ETF	131.24	131.3333	131.13	131.21	9024395.0
2012-01-31 16:30:00	SPY	ETF	131.21	131.22	131.05	131.08	4755150.0
2012-01-31 17:00:00	SPY	ETF	131.07	131.2731	131.06	131.15	283211.0
2012-01-31 17:30:00	SPY	ETF	131.16	131.17	131.14	131.14	19235.0
2012-01-31 18:00:00	SPY	ETF	131.17	131.22	131.11	131.12	38553.0
2012-01-31 18:30:00	SPY	ETF	131.12	131.15	131.08	131.08	40732.0
2012-01-31 19:00:00	SPY	ETF	131.07	131.15	131.07	131.15	17355.0
2012-01-31 19:30:00	SPY	ETF	131.11	131.22	131.11	131.22	46010.0
2012-01-31 04:30:00	QQQ	ETF	60.74	60.76	60.74	60.76	800.0
2012-01-31 05:00:00	QQQ	ETF	60.81	60.81	60.8	60.8	3200.0
2012-01-31 05:30:00	QQQ	ETF	60.8	60.81	60.79	60.81	4800.0
2012-01-31 06:00:00	QQQ	ETF	60.85	60.85	60.78	60.78	2300.0
2012-01-31 06:30:00	QQQ	ETF	60.81	60.82	60.77	60.77	4100.0
2012-01-31 07:00:00	QQQ	ETF	60.73	60.73	60.6	60.6	806354.0
2012-01-31 07:30:00	QQQ	ETF	60.63	60.7	60.63	60.66	50245.0
2012-01-31 08:00:00	QQQ	ETF	60.65	60.72	60.625	60.67	1605387.0
2012-01-31 08:30:00	QQQ	ETF	60.68	60.73	60.66	60.71	489221.0
2012-01-31 09:00:00	QQQ	ETF	60.68	60.78	60.66	60.74	161364.0
2012-01-31 09:30:00	QQQ	ETF	60.73	60.86	60.56	60.72	6394531.0
2012-01-31 10:00:00	QQQ	ETF	60.72	60.74	60.43	60.618	6477175.0
2012-01-31 10:30:00	QQQ	ETF	60.6199	60.63	60.26	60.3	2261791.0
2012-01-31 11:00:00	QQQ	ETF	60.3	60.37	60.18	60.28	3640597.0
2012-01-31 11:30:00	QQQ	ETF	60.285	60.34	60.14	60.25	3050785.0
2012-01-31 12:00:00	QQQ	ETF	60.25	60.33	60.21	60.2986	2399709.0
2012-01-31 12:30:00	QQQ	ETF	60.3	60.4	60.295	60.344	2648857.0
2012-01-31 13:00:00	QQQ	ETF	60.35	60.49	60.34	60.47	1477007.0

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

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