PREVIEW / etf_30min / 2017-06-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-07.parquet
  size:    432 KB
  rows:    14,702

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
2017-06-07 04:00:00	SPY	ETF	243.5	243.5	243.33	243.33	2496.0
2017-06-07 05:00:00	SPY	ETF	243.41	243.41	243.41	243.41	800.0
2017-06-07 05:30:00	SPY	ETF	243.42	243.42	243.41	243.41	400.0
2017-06-07 06:00:00	SPY	ETF	243.54	243.61	243.53	243.6	6310.0
2017-06-07 06:30:00	SPY	ETF	243.59	243.66	243.48	243.48	13340.0
2017-06-07 07:00:00	SPY	ETF	243.54	243.57	243.52	243.54	33240.0
2017-06-07 07:30:00	SPY	ETF	243.53	243.67	243.46	243.67	74540.0
2017-06-07 08:00:00	SPY	ETF	243.5	243.71	243.5	243.61	50337.0
2017-06-07 08:30:00	SPY	ETF	243.61	243.62	243.54	243.62	37982.0
2017-06-07 09:00:00	SPY	ETF	243.61	243.71	243.58	243.58	415793.0
2017-06-07 09:30:00	SPY	ETF	243.6	243.79	243.48	243.735	4180491.0
2017-06-07 10:00:00	SPY	ETF	243.735	243.8555	243.58	243.6	2577046.0
2017-06-07 10:30:00	SPY	ETF	243.595	243.6	243.1782	243.47	4047065.0
2017-06-07 11:00:00	SPY	ETF	243.47	243.62	243.28	243.29	1794208.0
2017-06-07 11:30:00	SPY	ETF	243.3	243.52	243.28	243.44	2307815.0
2017-06-07 12:00:00	SPY	ETF	243.44	243.44	243.29	243.365	1441522.0
2017-06-07 12:30:00	SPY	ETF	243.365	243.38	242.83	243.12	3197931.0
2017-06-07 13:00:00	SPY	ETF	243.12	243.36	243.06	243.29	2265387.0
2017-06-07 13:30:00	SPY	ETF	243.28	243.56	243.19	243.485	2186283.0
2017-06-07 14:00:00	SPY	ETF	243.49	243.72	243.44	243.59	2831862.0
2017-06-07 14:30:00	SPY	ETF	243.59	243.79	243.57	243.68	2342872.0
2017-06-07 15:00:00	SPY	ETF	243.67	243.76	243.55	243.725	4438851.0
2017-06-07 15:30:00	SPY	ETF	243.72	243.92	243.52	243.65	8362549.0
2017-06-07 16:00:00	SPY	ETF	243.65	243.7087	243.08	243.58	7913768.0
2017-06-07 16:30:00	SPY	ETF	243.58	243.66	243.58	243.62	1438878.0
2017-06-07 17:00:00	SPY	ETF	243.62	243.62	243.55	243.59	135033.0
2017-06-07 17:30:00	SPY	ETF	243.6	243.68	243.6	243.63	118070.0
2017-06-07 18:00:00	SPY	ETF	243.63	243.67	243.56	243.63	124927.0
2017-06-07 18:30:00	SPY	ETF	243.63	243.65	243.6	243.6	10267.0
2017-06-07 19:00:00	SPY	ETF	243.59	243.6	243.52	243.52	19490.0
2017-06-07 19:30:00	SPY	ETF	243.53	243.63	243.53	243.63	25496.0
2017-06-07 04:00:00	QQQ	ETF	143.0	143.01	142.99	142.99	1662.0
2017-06-07 04:30:00	QQQ	ETF	143.05	143.05	143.05	143.05	700.0
2017-06-07 05:00:00	QQQ	ETF	143.02	143.02	143.02	143.02	200.0
2017-06-07 05:30:00	QQQ	ETF	143.05	143.09	143.04	143.09	6000.0
2017-06-07 06:00:00	QQQ	ETF	143.17	143.2	143.16	143.2	15000.0
2017-06-07 06:30:00	QQQ	ETF	143.13	143.13	143.11	143.12	5750.0
2017-06-07 07:00:00	QQQ	ETF	143.14	143.15	143.11	143.15	14600.0
2017-06-07 07:30:00	QQQ	ETF	143.15	143.19	143.11	143.19	24200.0
2017-06-07 08:00:00	QQQ	ETF	143.21	143.23	143.16	143.18	40780.0
2017-06-07 08:30:00	QQQ	ETF	143.19	143.23	143.18	143.22	42700.0
2017-06-07 09:00:00	QQQ	ETF	143.22	143.31	143.22	143.23	166714.0
2017-06-07 09:30:00	QQQ	ETF	143.23	143.49	143.06	143.29	3079229.0
2017-06-07 10:00:00	QQQ	ETF	143.29	143.42	143.16	143.17	1319414.0
2017-06-07 10:30:00	QQQ	ETF	143.17	143.31	142.92	143.18	1379834.0
2017-06-07 11:00:00	QQQ	ETF	143.19	143.38	143.15	143.16	565316.0
2017-06-07 11:30:00	QQQ	ETF	143.16	143.31	143.16	143.26	600351.0
2017-06-07 12:00:00	QQQ	ETF	143.26	143.26	143.0501	143.095	348470.0
2017-06-07 12:30:00	QQQ	ETF	143.09	143.11	142.6	142.82	1689218.0
2017-06-07 13:00:00	QQQ	ETF	142.83	143.05	142.81	143.0	1001713.0

> showing 50 of 14,702 rows — these rows as CSV

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