PREVIEW / etf_30min / 2019-10-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-14.parquet
  size:    473 KB
  rows:    16,577

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-10-14 04:00:00	SPY	ETF	296.06	296.12	295.8	296.05	20494.0
2019-10-14 04:30:00	SPY	ETF	296.15	296.45	296.15	296.4	5700.0
2019-10-14 05:00:00	SPY	ETF	296.35	296.35	295.23	295.45	38470.0
2019-10-14 05:30:00	SPY	ETF	295.46	295.63	294.83	294.99	62008.0
2019-10-14 06:00:00	SPY	ETF	295.05	295.24	295.01	295.12	20161.0
2019-10-14 06:30:00	SPY	ETF	295.04	295.59	295.01	295.56	37891.0
2019-10-14 07:00:00	SPY	ETF	295.51	295.57	295.38	295.55	84372.0
2019-10-14 07:30:00	SPY	ETF	295.59	295.96	295.54	295.92	144837.0
2019-10-14 08:00:00	SPY	ETF	295.94	297.3	295.4	295.8	277391.0
2019-10-14 08:30:00	SPY	ETF	295.8	295.88	295.55	295.71	171905.0
2019-10-14 09:00:00	SPY	ETF	295.7	296.06	295.53	295.93	350440.0
2019-10-14 09:30:00	SPY	ETF	295.93	296.3	295.57	296.14	4707242.0
2019-10-14 10:00:00	SPY	ETF	296.14	296.59	295.83	295.93	3325973.0
2019-10-14 10:30:00	SPY	ETF	295.93	296.605	295.93	296.59	1732947.0
2019-10-14 11:00:00	SPY	ETF	296.585	296.67	296.11	296.19	2439979.0
2019-10-14 11:30:00	SPY	ETF	296.19	296.609	296.16	296.325	1883385.0
2019-10-14 12:00:00	SPY	ETF	296.335	296.41	296.01	296.13	1149258.0
2019-10-14 12:30:00	SPY	ETF	296.125	296.325	296.01	296.15	1190892.0
2019-10-14 13:00:00	SPY	ETF	296.14	296.32	296.03	296.145	1879705.0
2019-10-14 13:30:00	SPY	ETF	296.1493	296.38	295.91	296.37	1739105.0
2019-10-14 14:00:00	SPY	ETF	296.36	296.54	296.26	296.4	2412021.0
2019-10-14 14:30:00	SPY	ETF	296.405	296.41	296.1033	296.22	1854483.0
2019-10-14 15:00:00	SPY	ETF	296.215	296.39	296.04	296.26	2164080.0
2019-10-14 15:30:00	SPY	ETF	296.26	296.28	295.905	296.01	6110529.0
2019-10-14 16:00:00	SPY	ETF	296.01	296.18	295.79	295.98	5791640.0
2019-10-14 16:30:00	SPY	ETF	295.99	296.07	295.89	296.03	262497.0
2019-10-14 17:00:00	SPY	ETF	296.02	296.02	295.98	295.98	9885.0
2019-10-14 17:30:00	SPY	ETF	296.0	296.03	296.0	296.02	15236.0
2019-10-14 18:00:00	SPY	ETF	296.05	296.32	296.05	296.3	28483.0
2019-10-14 18:30:00	SPY	ETF	296.28	296.37	296.25	296.32	7726.0
2019-10-14 19:00:00	SPY	ETF	296.33	296.42	296.32	296.4	17722.0
2019-10-14 19:30:00	SPY	ETF	296.39	296.74	296.36	296.67	24536.0
2019-10-14 04:00:00	QQQ	ETF	190.87	190.92	190.75	190.91	6201.0
2019-10-14 04:30:00	QQQ	ETF	190.95	191.14	190.89	191.09	6980.0
2019-10-14 05:00:00	QQQ	ETF	190.98	191.02	190.26	190.42	43150.0
2019-10-14 05:30:00	QQQ	ETF	190.48	190.5	189.96	190.11	29200.0
2019-10-14 06:00:00	QQQ	ETF	190.08	190.19	190.05	190.06	14876.0
2019-10-14 06:30:00	QQQ	ETF	190.08	190.47	189.97	190.41	21669.0
2019-10-14 07:00:00	QQQ	ETF	190.39	190.54	190.35	190.47	27958.0
2019-10-14 07:30:00	QQQ	ETF	190.59	190.84	190.55	190.77	33944.0
2019-10-14 08:00:00	QQQ	ETF	190.85	191.72	190.3999	190.73	112692.0
2019-10-14 08:30:00	QQQ	ETF	190.71	190.77	190.56	190.67	50727.0
2019-10-14 09:00:00	QQQ	ETF	190.67	190.92	190.56	190.82	83368.0
2019-10-14 09:30:00	QQQ	ETF	190.82	191.35	190.645	191.155	1810439.0
2019-10-14 10:00:00	QQQ	ETF	191.15	191.57	190.985	191.07	1143394.0
2019-10-14 10:30:00	QQQ	ETF	191.08	191.66	191.08	191.64	778166.0
2019-10-14 11:00:00	QQQ	ETF	191.64	191.7	191.23	191.283	638522.0
2019-10-14 11:30:00	QQQ	ETF	191.3	191.56	191.28	191.33	889801.0
2019-10-14 12:00:00	QQQ	ETF	191.34	191.4	191.09	191.11	383446.0
2019-10-14 12:30:00	QQQ	ETF	191.11	191.2666	191.03	191.145	369768.0

> showing 50 of 16,577 rows — these rows as CSV

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