PREVIEW / etf_30min / 2020-10-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-08.parquet
  size:    554 KB
  rows:    20,425

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-10-08 04:00:00	SPY	ETF	342.7	342.7	341.53	341.53	29784.0
2020-10-08 04:30:00	SPY	ETF	341.58	342.16	341.58	342.16	6456.0
2020-10-08 05:00:00	SPY	ETF	342.16	342.2	342.03	342.05	10163.0
2020-10-08 05:30:00	SPY	ETF	342.06	342.07	341.72	341.86	7034.0
2020-10-08 06:00:00	SPY	ETF	341.85	342.21	341.85	342.15	7983.0
2020-10-08 06:30:00	SPY	ETF	342.17	343.0	342.0	342.04	47506.0
2020-10-08 07:00:00	SPY	ETF	342.0	342.3	341.94	342.24	154597.0
2020-10-08 07:30:00	SPY	ETF	342.22	342.31	341.81	342.21	69427.0
2020-10-08 08:00:00	SPY	ETF	342.21	343.06	341.95	342.88	432518.0
2020-10-08 08:30:00	SPY	ETF	342.88	342.94	342.4	342.79	111417.0
2020-10-08 09:00:00	SPY	ETF	342.79	342.98	342.65	342.87	149618.0
2020-10-08 09:30:00	SPY	ETF	342.85	343.2099	342.31	343.153	4466982.0
2020-10-08 10:00:00	SPY	ETF	343.18	343.44	342.29	342.77	3575919.0
2020-10-08 10:30:00	SPY	ETF	342.7698	343.57	342.75	342.99	2794904.0
2020-10-08 11:00:00	SPY	ETF	343.0	343.5	342.63	342.7001	3729088.0
2020-10-08 11:30:00	SPY	ETF	342.7	342.93	341.86	342.43	2912395.0
2020-10-08 12:00:00	SPY	ETF	342.44	343.38	342.3813	343.2975	1991048.0
2020-10-08 12:30:00	SPY	ETF	343.29	343.47	343.07	343.32	1198362.0
2020-10-08 13:00:00	SPY	ETF	343.35	343.38	342.87	343.05	1408548.0
2020-10-08 13:30:00	SPY	ETF	343.035	343.26	342.89	342.91	1117416.0
2020-10-08 14:00:00	SPY	ETF	342.92	343.54	342.781	343.3701	1983830.0
2020-10-08 14:30:00	SPY	ETF	343.38	343.68	343.31	343.5	2782975.0
2020-10-08 15:00:00	SPY	ETF	343.51	343.72	343.02	343.63	2873038.0
2020-10-08 15:30:00	SPY	ETF	343.62	343.85	343.35	343.73	6314418.0
2020-10-08 16:00:00	SPY	ETF	343.7	343.85	343.48	343.8	4690254.0
2020-10-08 16:30:00	SPY	ETF	343.78	344.63	343.68	344.55	519038.0
2020-10-08 17:00:00	SPY	ETF	344.58	344.58	343.78	344.41	182284.0
2020-10-08 17:30:00	SPY	ETF	344.43	344.6	344.43	344.58	83846.0
2020-10-08 18:00:00	SPY	ETF	344.59	345.3	344.59	345.27	141781.0
2020-10-08 18:30:00	SPY	ETF	345.26	345.45	345.07	345.16	80997.0
2020-10-08 19:00:00	SPY	ETF	345.2	345.3	345.0	345.09	110355.0
2020-10-08 19:30:00	SPY	ETF	345.1	345.3	344.97	345.26	118082.0
2020-10-08 04:00:00	QQQ	ETF	281.82	281.96	281.28	281.28	26371.0
2020-10-08 04:30:00	QQQ	ETF	281.28	281.71	281.28	281.71	2110.0
2020-10-08 05:00:00	QQQ	ETF	281.71	282.05	281.68	281.92	15797.0
2020-10-08 05:30:00	QQQ	ETF	281.87	281.87	281.41	281.5	14339.0
2020-10-08 06:00:00	QQQ	ETF	281.42	281.71	281.4	281.49	13957.0
2020-10-08 06:30:00	QQQ	ETF	281.52	282.01	281.28	281.34	44717.0
2020-10-08 07:00:00	QQQ	ETF	281.3	281.6	281.23	281.57	64634.0
2020-10-08 07:30:00	QQQ	ETF	281.55	282.03	281.31	281.89	116295.0
2020-10-08 08:00:00	QQQ	ETF	281.3601	282.5	280.83	282.1	276923.0
2020-10-08 08:30:00	QQQ	ETF	282.1	282.23	281.68	282.15	144903.0
2020-10-08 09:00:00	QQQ	ETF	282.18	282.42	282.15	282.34	159257.0
2020-10-08 09:30:00	QQQ	ETF	282.32	282.47	280.8801	281.6333	3148058.0
2020-10-08 10:00:00	QQQ	ETF	281.67	281.83	280.31	280.7	2215886.0
2020-10-08 10:30:00	QQQ	ETF	280.71	281.428	280.64	280.93	1646568.0
2020-10-08 11:00:00	QQQ	ETF	280.95	281.89	280.78	281.27	1660127.0
2020-10-08 11:30:00	QQQ	ETF	281.23	281.5395	280.5	281.221	1227897.0
2020-10-08 12:00:00	QQQ	ETF	281.22	282.01	281.215	281.73	1306977.0
2020-10-08 12:30:00	QQQ	ETF	281.73	282.13	281.5901	281.81	994425.0

> showing 50 of 20,425 rows — these rows as CSV

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