PREVIEW / etf_30min / 2019-12-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-30.parquet
  size:    539 KB
  rows:    19,118

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
2019-12-30 04:00:00	SPY	ETF	323.11	323.15	322.91	323.04	33231.0
2019-12-30 04:30:00	SPY	ETF	323.06	323.06	322.89	322.91	6541.0
2019-12-30 05:00:00	SPY	ETF	322.94	322.94	322.82	322.86	1206.0
2019-12-30 05:30:00	SPY	ETF	322.85	322.85	322.71	322.74	1170.0
2019-12-30 06:00:00	SPY	ETF	322.66	322.66	322.45	322.49	52669.0
2019-12-30 06:30:00	SPY	ETF	322.63	322.68	322.62	322.67	7660.0
2019-12-30 07:00:00	SPY	ETF	322.71	322.85	322.71	322.83	43546.0
2019-12-30 07:30:00	SPY	ETF	322.81	322.86	322.73	322.73	27897.0
2019-12-30 08:00:00	SPY	ETF	322.8	323.09	322.53	322.85	116486.0
2019-12-30 08:30:00	SPY	ETF	322.8301	323.05	322.81	323.02	75603.0
2019-12-30 09:00:00	SPY	ETF	323.01	323.15	322.96	322.98	89867.0
2019-12-30 09:30:00	SPY	ETF	322.95	323.1	321.29	321.47	7507855.0
2019-12-30 10:00:00	SPY	ETF	321.4705	321.63	320.55	320.9	5131590.0
2019-12-30 10:30:00	SPY	ETF	320.9	321.25	320.67	321.21	2791564.0
2019-12-30 11:00:00	SPY	ETF	321.215	321.47	320.85	321.41	2517934.0
2019-12-30 11:30:00	SPY	ETF	321.4	321.6	321.18	321.47	1854614.0
2019-12-30 12:00:00	SPY	ETF	321.46	321.91	321.43	321.875	2331034.0
2019-12-30 12:30:00	SPY	ETF	321.88	322.06	321.83	321.8315	2524919.0
2019-12-30 13:00:00	SPY	ETF	321.83	321.91	321.57	321.59	2227728.0
2019-12-30 13:30:00	SPY	ETF	321.59	321.8	321.51	321.73	1379452.0
2019-12-30 14:00:00	SPY	ETF	321.735	321.745	321.13	321.27	1959926.0
2019-12-30 14:30:00	SPY	ETF	321.27	321.3	321.105	321.15	2385232.0
2019-12-30 15:00:00	SPY	ETF	321.15	321.43	321.07	321.36	2242139.0
2019-12-30 15:30:00	SPY	ETF	321.36	321.41	320.7	321.1	6994103.0
2019-12-30 16:00:00	SPY	ETF	321.11	321.33	321.0677	321.15	5795007.0
2019-12-30 16:30:00	SPY	ETF	321.15	321.23	321.08	321.19	213988.0
2019-12-30 17:00:00	SPY	ETF	321.19	321.19	321.12	321.12	7225.0
2019-12-30 17:30:00	SPY	ETF	321.12	321.17	321.09	321.16	9979.0
2019-12-30 18:00:00	SPY	ETF	321.14	321.29	321.08	321.26	80714.0
2019-12-30 18:30:00	SPY	ETF	321.26	321.29	321.16	321.29	11093.0
2019-12-30 19:00:00	SPY	ETF	321.28	321.31	321.27	321.3	21242.0
2019-12-30 19:30:00	SPY	ETF	321.29	321.38	321.29	321.38	14472.0
2019-12-30 04:00:00	QQQ	ETF	213.86	213.86	213.7	213.77	10227.0
2019-12-30 04:30:00	QQQ	ETF	213.72	213.72	213.62	213.62	5900.0
2019-12-30 05:00:00	QQQ	ETF	213.62	213.63	213.52	213.53	6058.0
2019-12-30 05:30:00	QQQ	ETF	213.48	213.51	213.42	213.48	4600.0
2019-12-30 06:00:00	QQQ	ETF	213.37	213.44	213.24	213.33	8830.0
2019-12-30 06:30:00	QQQ	ETF	213.4	213.47	213.38	213.43	16545.0
2019-12-30 07:00:00	QQQ	ETF	213.47	213.56	213.47	213.54	26696.0
2019-12-30 07:30:00	QQQ	ETF	213.55	213.63	213.51	213.51	20396.0
2019-12-30 08:00:00	QQQ	ETF	213.51	213.61	213.41	213.58	84417.0
2019-12-30 08:30:00	QQQ	ETF	213.5	213.7	213.46	213.63	71753.0
2019-12-30 09:00:00	QQQ	ETF	213.57	213.68	213.5	213.53	57739.0
2019-12-30 09:30:00	QQQ	ETF	213.51	213.63	211.47	211.72	4142851.0
2019-12-30 10:00:00	QQQ	ETF	211.73	211.95	211.16	211.67	2356988.0
2019-12-30 10:30:00	QQQ	ETF	211.67	211.99	211.47	211.91	1150278.0
2019-12-30 11:00:00	QQQ	ETF	211.92	212.23	211.59	212.17	983474.0
2019-12-30 11:30:00	QQQ	ETF	212.17	212.34	212.04	212.27	621887.0
2019-12-30 12:00:00	QQQ	ETF	212.26	212.57	212.24	212.54	672740.0
2019-12-30 12:30:00	QQQ	ETF	212.54	212.76	212.54	212.6499	646023.0

> showing 50 of 19,118 rows — these rows as CSV

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