PREVIEW / etf_30min / 2014-03-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-04.parquet
  size:    351 KB
  rows:    11,842

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
2014-03-04 04:00:00	SPY	ETF	185.98	186.12	185.97	186.08	49585.0
2014-03-04 04:30:00	SPY	ETF	186.12	186.12	186.04	186.05	4003.0
2014-03-04 05:00:00	SPY	ETF	186.11	186.2	186.07	186.07	24220.0
2014-03-04 05:30:00	SPY	ETF	186.1	186.87	186.05	186.74	51207.0
2014-03-04 06:00:00	SPY	ETF	186.74	186.9	186.62	186.81	100262.0
2014-03-04 06:30:00	SPY	ETF	186.83	186.99	186.66	186.69	250878.0
2014-03-04 07:00:00	SPY	ETF	186.71	187.07	186.69	186.86	436490.0
2014-03-04 07:30:00	SPY	ETF	186.86	186.92	186.76	186.77	484726.0
2014-03-04 08:00:00	SPY	ETF	186.77	187.07	185.1	186.64	1308662.0
2014-03-04 08:30:00	SPY	ETF	186.64	186.74	186.57	186.66	780908.0
2014-03-04 09:00:00	SPY	ETF	186.68	186.83	186.56	186.75	1048890.0
2014-03-04 09:30:00	SPY	ETF	186.75	187.3	186.75	187.21	24060393.0
2014-03-04 10:00:00	SPY	ETF	187.22	187.37	186.98	187.29	15268489.0
2014-03-04 10:30:00	SPY	ETF	187.29	187.52	187.22	187.41	11562878.0
2014-03-04 11:00:00	SPY	ETF	187.4	187.51	187.35	187.45	7118279.0
2014-03-04 11:30:00	SPY	ETF	187.46	187.46	187.22	187.38	8090317.0
2014-03-04 12:00:00	SPY	ETF	187.38	187.7	187.34	187.64	6908447.0
2014-03-04 12:30:00	SPY	ETF	187.64	187.67	187.45	187.55	6239612.0
2014-03-04 13:00:00	SPY	ETF	187.55	187.66	187.47	187.63	7574731.0
2014-03-04 13:30:00	SPY	ETF	187.622	187.72	187.21	187.38	12065433.0
2014-03-04 14:00:00	SPY	ETF	187.375	187.51	187.15	187.46	7550715.0
2014-03-04 14:30:00	SPY	ETF	187.46	187.74	187.27	187.64	7795229.0
2014-03-04 15:00:00	SPY	ETF	187.65	187.97	187.615	187.84	13215297.0
2014-03-04 15:30:00	SPY	ETF	187.84	187.98	187.655	187.69	23010279.0
2014-03-04 16:00:00	SPY	ETF	187.68	187.728	187.49	187.66	4692700.0
2014-03-04 16:30:00	SPY	ETF	187.67	187.79	184.9097	187.62	1202336.0
2014-03-04 17:00:00	SPY	ETF	187.62	187.78	187.61	187.72	147685.0
2014-03-04 17:30:00	SPY	ETF	187.72	187.72	187.63	187.63	58110.0
2014-03-04 18:00:00	SPY	ETF	187.61	187.62	187.47	187.55	165298.0
2014-03-04 18:30:00	SPY	ETF	187.53	187.54	187.46	187.47	68259.0
2014-03-04 19:00:00	SPY	ETF	187.5	187.51	187.36	187.4	56621.0
2014-03-04 19:30:00	SPY	ETF	187.41	187.5	187.41	187.5	59096.0
2014-03-04 04:00:00	QQQ	ETF	90.0	90.24	90.0	90.24	2980.0
2014-03-04 04:30:00	QQQ	ETF	90.27	90.27	90.27	90.27	817.0
2014-03-04 05:00:00	QQQ	ETF	90.27	90.3	90.27	90.29	2200.0
2014-03-04 05:30:00	QQQ	ETF	90.28	90.67	90.28	90.65	12660.0
2014-03-04 06:00:00	QQQ	ETF	90.65	90.75	90.58	90.7	11309.0
2014-03-04 06:30:00	QQQ	ETF	90.7	90.77	90.6	90.6	18200.0
2014-03-04 07:00:00	QQQ	ETF	90.61	90.73	90.61	90.65	61290.0
2014-03-04 07:30:00	QQQ	ETF	90.65	90.71	90.63	90.63	37300.0
2014-03-04 08:00:00	QQQ	ETF	90.62	90.7	90.5	90.58	244604.0
2014-03-04 08:30:00	QQQ	ETF	90.58	90.61	90.54	90.57	116744.0
2014-03-04 09:00:00	QQQ	ETF	90.58	90.67	90.54	90.63	215121.0
2014-03-04 09:30:00	QQQ	ETF	90.63	90.83	90.56	90.79	4094180.0
2014-03-04 10:00:00	QQQ	ETF	90.8	90.87	90.68	90.8	3556662.0
2014-03-04 10:30:00	QQQ	ETF	90.81	90.91	90.79	90.89	2296548.0
2014-03-04 11:00:00	QQQ	ETF	90.88	90.91	90.84	90.88	1183997.0
2014-03-04 11:30:00	QQQ	ETF	90.88	90.88	90.75	90.84	1296127.0
2014-03-04 12:00:00	QQQ	ETF	90.83	90.98	90.82	90.94	1079629.0
2014-03-04 12:30:00	QQQ	ETF	90.93	90.95	90.84	90.87	812091.0

> showing 50 of 11,842 rows — these rows as CSV

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