PREVIEW / etf_30min / 2016-01-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-13.parquet
  size:    413 KB
  rows:    13,835

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
2016-01-13 04:00:00	SPY	ETF	194.82	195.07	194.69	195.0	158137.0
2016-01-13 04:30:00	SPY	ETF	194.99	194.99	194.5	194.51	17152.0
2016-01-13 05:00:00	SPY	ETF	194.53	194.65	194.36	194.46	23685.0
2016-01-13 05:30:00	SPY	ETF	194.48	194.71	194.39	194.52	9230.0
2016-01-13 06:00:00	SPY	ETF	194.46	194.46	194.2	194.34	28740.0
2016-01-13 06:30:00	SPY	ETF	194.24	194.24	193.97	194.11	152043.0
2016-01-13 07:00:00	SPY	ETF	194.13	194.41	194.04	194.29	242539.0
2016-01-13 07:30:00	SPY	ETF	194.31	194.33	193.96	194.05	368456.0
2016-01-13 08:00:00	SPY	ETF	195.44	195.44	193.8	194.53	881153.0
2016-01-13 08:30:00	SPY	ETF	194.52	194.89	194.52	194.55	954664.0
2016-01-13 09:00:00	SPY	ETF	194.56	194.67	193.6383	194.47	2901448.0
2016-01-13 09:30:00	SPY	ETF	194.45	194.86	193.84	194.09	14624480.0
2016-01-13 10:00:00	SPY	ETF	194.1	194.4025	193.46	193.81	12065547.0
2016-01-13 10:30:00	SPY	ETF	193.8	193.8	192.84	193.66	13678286.0
2016-01-13 11:00:00	SPY	ETF	193.67	193.9	192.92	193.38	8473113.0
2016-01-13 11:30:00	SPY	ETF	193.36	193.72	192.35	192.5	8600703.0
2016-01-13 12:00:00	SPY	ETF	192.49	192.75	192.26	192.62	6508977.0
2016-01-13 12:30:00	SPY	ETF	192.61	192.623	191.615	191.74	8118692.0
2016-01-13 13:00:00	SPY	ETF	191.73	192.02	191.26	191.29	7329799.0
2016-01-13 13:30:00	SPY	ETF	191.29	191.49	190.25	190.35	14659989.0
2016-01-13 14:00:00	SPY	ETF	190.34	190.7	189.72	190.16	18214570.0
2016-01-13 14:30:00	SPY	ETF	190.16	190.16	188.38	189.34	24004691.0
2016-01-13 15:00:00	SPY	ETF	189.34	190.18	188.91	189.6669	26289513.0
2016-01-13 15:30:00	SPY	ETF	189.66	189.93	188.54	188.84	36708133.0
2016-01-13 16:00:00	SPY	ETF	188.85	189.6153	188.66	188.74	11910106.0
2016-01-13 16:30:00	SPY	ETF	188.75	189.23	188.65	188.86	1482277.0
2016-01-13 17:00:00	SPY	ETF	188.88	188.94	188.78	188.83	343203.0
2016-01-13 17:30:00	SPY	ETF	188.83	188.94	188.77	188.93	93077.0
2016-01-13 18:00:00	SPY	ETF	188.99	189.18	188.87	189.04	123053.0
2016-01-13 18:30:00	SPY	ETF	189.09	189.18	188.82	188.85	159263.0
2016-01-13 19:00:00	SPY	ETF	188.84	189.0	188.76	188.92	66050.0
2016-01-13 19:30:00	SPY	ETF	188.94	189.15	188.79	188.86	119603.0
2016-01-13 04:00:00	QQQ	ETF	106.3	106.45	106.16	106.42	21134.0
2016-01-13 04:30:00	QQQ	ETF	106.27	106.27	106.13	106.13	1700.0
2016-01-13 05:00:00	QQQ	ETF	106.11	106.22	106.09	106.09	19900.0
2016-01-13 05:30:00	QQQ	ETF	106.19	106.22	106.19	106.22	1800.0
2016-01-13 06:00:00	QQQ	ETF	106.08	106.11	105.94	106.03	3754.0
2016-01-13 06:30:00	QQQ	ETF	105.92	105.98	105.92	105.95	10800.0
2016-01-13 07:00:00	QQQ	ETF	105.94	106.1	105.94	106.04	4285.0
2016-01-13 07:30:00	QQQ	ETF	106.05	106.05	105.87	105.89	26092.0
2016-01-13 08:00:00	QQQ	ETF	105.92	106.12	105.77	106.09	90619.0
2016-01-13 08:30:00	QQQ	ETF	106.1	106.25	106.05	106.07	93038.0
2016-01-13 09:00:00	QQQ	ETF	106.05	106.1	105.9	106.0	290771.0
2016-01-13 09:30:00	QQQ	ETF	106.0	106.23	105.54	105.65	5463052.0
2016-01-13 10:00:00	QQQ	ETF	105.65	105.81	105.24	105.46	3730222.0
2016-01-13 10:30:00	QQQ	ETF	105.45	105.455	105.05	105.34	4234078.0
2016-01-13 11:00:00	QQQ	ETF	105.34	105.59	104.85	105.21	3347977.0
2016-01-13 11:30:00	QQQ	ETF	105.2	105.47	104.53	104.61	2569811.0
2016-01-13 12:00:00	QQQ	ETF	104.6101	104.75	104.43	104.62	2266113.0
2016-01-13 12:30:00	QQQ	ETF	104.62	104.6251	104.08	104.15	2268784.0

> showing 50 of 13,835 rows — these rows as CSV

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