PREVIEW / etf_30min / 2020-02-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-06.parquet
  size:    540 KB
  rows:    19,497

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
2020-02-06 04:00:00	SPY	ETF	334.48	334.64	333.78	333.8	21450.0
2020-02-06 04:30:00	SPY	ETF	334.07	334.07	333.83	333.91	6317.0
2020-02-06 05:00:00	SPY	ETF	333.8	333.93	333.73	333.9	3319.0
2020-02-06 05:30:00	SPY	ETF	333.91	333.95	333.64	333.64	3261.0
2020-02-06 06:00:00	SPY	ETF	333.68	333.94	333.68	333.91	2506.0
2020-02-06 06:30:00	SPY	ETF	333.91	334.5	333.9	334.5	21876.0
2020-02-06 07:00:00	SPY	ETF	334.43	334.51	334.18	334.18	107908.0
2020-02-06 07:30:00	SPY	ETF	334.18	334.28	333.91	334.0	143899.0
2020-02-06 08:00:00	SPY	ETF	334.15	335.15	332.86	334.11	155666.0
2020-02-06 08:30:00	SPY	ETF	334.22	334.36	332.86	333.99	227071.0
2020-02-06 09:00:00	SPY	ETF	333.97	334.11	333.8	333.93	364605.0
2020-02-06 09:30:00	SPY	ETF	333.91	334.06	332.8	333.73	6596911.0
2020-02-06 10:00:00	SPY	ETF	333.73	333.95	332.94	333.18	4179463.0
2020-02-06 10:30:00	SPY	ETF	333.18	333.77	333.06	333.5	3597477.0
2020-02-06 11:00:00	SPY	ETF	333.51	334.06	333.32	333.94	3778990.0
2020-02-06 11:30:00	SPY	ETF	333.935	334.05	333.4697	333.4705	1717362.0
2020-02-06 12:00:00	SPY	ETF	333.46	334.07	333.42	334.07	1735719.0
2020-02-06 12:30:00	SPY	ETF	334.07	334.125	333.8501	334.065	1597094.0
2020-02-06 13:00:00	SPY	ETF	334.055	334.19	333.72	333.73	1371663.0
2020-02-06 13:30:00	SPY	ETF	333.72	333.92	333.51	333.8701	2538063.0
2020-02-06 14:00:00	SPY	ETF	333.87	334.11	333.71	333.99	2784012.0
2020-02-06 14:30:00	SPY	ETF	333.995	334.11	333.76	333.77	3243456.0
2020-02-06 15:00:00	SPY	ETF	333.78	333.999	333.49	333.59	3639848.0
2020-02-06 15:30:00	SPY	ETF	333.59	334.09	333.58	333.96	5864637.0
2020-02-06 16:00:00	SPY	ETF	333.96	334.05	332.8263	334.0	3555668.0
2020-02-06 16:30:00	SPY	ETF	334.02	334.32	333.99	334.3	255530.0
2020-02-06 17:00:00	SPY	ETF	334.37	334.51	334.03	334.35	1032857.0
2020-02-06 17:30:00	SPY	ETF	334.38	334.38	333.916	334.36	552889.0
2020-02-06 18:00:00	SPY	ETF	334.38	334.52	334.28	334.33	95269.0
2020-02-06 18:30:00	SPY	ETF	334.29	334.49	334.26	334.44	16904.0
2020-02-06 19:00:00	SPY	ETF	334.45	334.47	334.2	334.25	75720.0
2020-02-06 19:30:00	SPY	ETF	334.21	334.22	333.24	333.63	179607.0
2020-02-06 04:00:00	QQQ	ETF	229.71	229.91	229.2	229.27	50170.0
2020-02-06 04:30:00	QQQ	ETF	229.3	229.44	229.2	229.34	8080.0
2020-02-06 05:00:00	QQQ	ETF	229.19	229.35	229.09	229.35	15300.0
2020-02-06 05:30:00	QQQ	ETF	229.27	229.28	228.98	228.98	10550.0
2020-02-06 06:00:00	QQQ	ETF	228.93	229.21	228.93	229.2	3305.0
2020-02-06 06:30:00	QQQ	ETF	229.17	229.72	229.17	229.72	32413.0
2020-02-06 07:00:00	QQQ	ETF	229.68	229.76	229.46	229.47	98516.0
2020-02-06 07:30:00	QQQ	ETF	229.43	229.57	229.19	229.29	66052.0
2020-02-06 08:00:00	QQQ	ETF	229.27	230.25	228.22	229.25	111479.0
2020-02-06 08:30:00	QQQ	ETF	229.34	229.47	228.95	229.07	196770.0
2020-02-06 09:00:00	QQQ	ETF	228.98	229.12	228.76	228.8	189721.0
2020-02-06 09:30:00	QQQ	ETF	228.78	229.22	227.98	229.22	3100729.0
2020-02-06 10:00:00	QQQ	ETF	229.21	229.32	228.66	228.8	1466272.0
2020-02-06 10:30:00	QQQ	ETF	228.8	229.46	228.72	229.31	1120869.0
2020-02-06 11:00:00	QQQ	ETF	229.335	229.9869	229.19	229.86	1176095.0
2020-02-06 11:30:00	QQQ	ETF	229.86	229.95	229.5	229.51	1014542.0
2020-02-06 12:00:00	QQQ	ETF	229.5	229.93	229.4501	229.91	579030.0
2020-02-06 12:30:00	QQQ	ETF	229.92	230.12	229.8	230.09	950276.0

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

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