PREVIEW / etf_30min / 2011-12-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-19.parquet
  size:    284 KB
  rows:    9,584

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-12-19 04:00:00	SPY	ETF	121.28	121.97	121.28	121.9	2400.0
2011-12-19 04:30:00	SPY	ETF	122.0	122.2	122.0	122.2	51269.0
2011-12-19 05:00:00	SPY	ETF	122.15	122.36	122.15	122.3	26630.0
2011-12-19 05:30:00	SPY	ETF	122.31	122.31	122.16	122.23	9800.0
2011-12-19 06:00:00	SPY	ETF	122.19	122.3	122.04	122.06	27052.0
2011-12-19 06:30:00	SPY	ETF	122.05	122.38	122.05	122.38	72120.0
2011-12-19 07:00:00	SPY	ETF	122.37	122.45	122.24	122.3	482110.0
2011-12-19 07:30:00	SPY	ETF	122.3	122.32	121.98	122.02	481550.0
2011-12-19 08:00:00	SPY	ETF	122.01	122.35	121.97	122.34	1699228.0
2011-12-19 08:30:00	SPY	ETF	122.34	122.38	122.2	122.24	379935.0
2011-12-19 09:00:00	SPY	ETF	122.24	122.25	122.0	122.07	1279388.0
2011-12-19 09:30:00	SPY	ETF	122.06	122.32	121.88	122.039	18507663.0
2011-12-19 10:00:00	SPY	ETF	122.04	122.07	121.8	121.9	13573475.0
2011-12-19 10:30:00	SPY	ETF	121.89	122.2	121.39	121.47	13425754.0
2011-12-19 11:00:00	SPY	ETF	121.46	121.51	121.01	121.26	12909438.0
2011-12-19 11:30:00	SPY	ETF	121.27	121.29	120.71	120.85	12295937.0
2011-12-19 12:00:00	SPY	ETF	120.85	121.11	120.81	121.08	7493417.0
2011-12-19 12:30:00	SPY	ETF	121.09	121.15	120.88	121.15	4937987.0
2011-12-19 13:00:00	SPY	ETF	121.15	121.18	120.94	121.0	8383229.0
2011-12-19 13:30:00	SPY	ETF	121.01	121.35	120.86	121.25	8366752.0
2011-12-19 14:00:00	SPY	ETF	121.25	121.29	120.91	121.019	6898865.0
2011-12-19 14:30:00	SPY	ETF	121.01	121.12	120.87	121.08	5435290.0
2011-12-19 15:00:00	SPY	ETF	121.08	121.08	120.16	120.215	20480418.0
2011-12-19 15:30:00	SPY	ETF	120.21	121.7792	120.03	120.33	30902475.0
2011-12-19 16:00:00	SPY	ETF	120.33	121.7792	120.27	120.34	10671746.0
2011-12-19 16:30:00	SPY	ETF	120.38	120.48	120.37	120.44	273750.0
2011-12-19 17:00:00	SPY	ETF	120.44	120.45	120.32	120.44	182762.0
2011-12-19 17:30:00	SPY	ETF	120.44	120.45	120.4	120.45	113392.0
2011-12-19 18:00:00	SPY	ETF	120.45	120.73	120.32	120.72	534691.0
2011-12-19 18:30:00	SPY	ETF	120.71	120.78	120.58	120.78	83492.0
2011-12-19 19:00:00	SPY	ETF	120.78	120.92	120.76	120.89	108970.0
2011-12-19 19:30:00	SPY	ETF	120.86	121.0	120.86	120.98	228233.0
2011-12-19 04:00:00	QQQ	ETF	55.0	55.02	55.0	55.02	800.0
2011-12-19 04:30:00	QQQ	ETF	55.01	55.19	55.01	55.18	2000.0
2011-12-19 05:00:00	QQQ	ETF	55.18	55.29	55.18	55.21	7714.0
2011-12-19 05:30:00	QQQ	ETF	55.21	55.22	55.21	55.22	1900.0
2011-12-19 06:00:00	QQQ	ETF	55.24	55.24	55.17	55.17	10793.0
2011-12-19 06:30:00	QQQ	ETF	55.17	55.24	55.17	55.24	3400.0
2011-12-19 07:00:00	QQQ	ETF	55.25	55.3	55.21	55.25	34100.0
2011-12-19 07:30:00	QQQ	ETF	55.22	55.23	55.09	55.09	36100.0
2011-12-19 08:00:00	QQQ	ETF	55.1	55.22	54.58	55.22	236342.0
2011-12-19 08:30:00	QQQ	ETF	55.22	55.23	55.17	55.17	127391.0
2011-12-19 09:00:00	QQQ	ETF	55.17	55.17	55.05	55.07	90764.0
2011-12-19 09:30:00	QQQ	ETF	55.06	55.2	54.94	55.08	3207851.0
2011-12-19 10:00:00	QQQ	ETF	55.09	55.11	54.96	55.02	3097007.0
2011-12-19 10:30:00	QQQ	ETF	55.03	55.18	54.76	54.81	3613417.0
2011-12-19 11:00:00	QQQ	ETF	54.8	54.85	54.62	54.74	2765655.0
2011-12-19 11:30:00	QQQ	ETF	54.74	54.76	54.51	54.63	2362738.0
2011-12-19 12:00:00	QQQ	ETF	54.63	54.7893	54.61	54.78	1431157.0
2011-12-19 12:30:00	QQQ	ETF	54.78	54.78	54.67	54.73	986472.0

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

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