PREVIEW / etf_30min / 2020-08-17

all etf 30-min files

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

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-08-17 04:00:00	SPY	ETF	337.44	337.54	337.01	337.18	2014.0
2020-08-17 04:30:00	SPY	ETF	337.05	337.32	337.0	337.32	22657.0
2020-08-17 05:00:00	SPY	ETF	337.48	337.7	337.4	337.56	2774.0
2020-08-17 05:30:00	SPY	ETF	337.46	337.47	337.2	337.31	3922.0
2020-08-17 06:00:00	SPY	ETF	337.31	337.41	337.2	337.26	12076.0
2020-08-17 06:30:00	SPY	ETF	337.25	337.37	337.17	337.37	10504.0
2020-08-17 07:00:00	SPY	ETF	337.33	337.44	337.23	337.35	38374.0
2020-08-17 07:30:00	SPY	ETF	337.32	337.51	337.17	337.31	127514.0
2020-08-17 08:00:00	SPY	ETF	337.34	337.58	336.6436	337.45	232985.0
2020-08-17 08:30:00	SPY	ETF	337.44	337.88	337.37	337.83	163228.0
2020-08-17 09:00:00	SPY	ETF	337.82	337.96	337.75	337.95	115407.0
2020-08-17 09:30:00	SPY	ETF	337.94	338.17	337.71	337.89	4185861.0
2020-08-17 10:00:00	SPY	ETF	337.89	337.98	337.48	337.93	2024575.0
2020-08-17 10:30:00	SPY	ETF	337.93	338.34	337.91	338.02	2105218.0
2020-08-17 11:00:00	SPY	ETF	338.025	338.3	337.73	338.17	2017705.0
2020-08-17 11:30:00	SPY	ETF	338.16	338.18	337.74	338.01	1550314.0
2020-08-17 12:00:00	SPY	ETF	338.015	338.06	337.76	337.835	1058132.0
2020-08-17 12:30:00	SPY	ETF	337.84	338.191	337.83	338.125	882641.0
2020-08-17 13:00:00	SPY	ETF	338.16	338.1699	338.0	338.06	786062.0
2020-08-17 13:30:00	SPY	ETF	338.055	338.16	337.96	338.055	1251206.0
2020-08-17 14:00:00	SPY	ETF	338.05	338.16	337.97	338.06	1229330.0
2020-08-17 14:30:00	SPY	ETF	338.07	338.14	337.81	337.915	2841400.0
2020-08-17 15:00:00	SPY	ETF	337.91	337.96	337.58	337.88	2073835.0
2020-08-17 15:30:00	SPY	ETF	337.89	338.16	337.72	337.88	5738428.0
2020-08-17 16:00:00	SPY	ETF	337.87	338.09	337.62	338.04	5076862.0
2020-08-17 16:30:00	SPY	ETF	338.04	338.14	337.91	337.99	365131.0
2020-08-17 17:00:00	SPY	ETF	338.01	338.03	337.98	338.01	22527.0
2020-08-17 17:30:00	SPY	ETF	338.04	338.05	337.99	338.05	15909.0
2020-08-17 18:00:00	SPY	ETF	338.02	338.02	337.79	337.95	79585.0
2020-08-17 18:30:00	SPY	ETF	337.95	338.07	337.93	338.07	23116.0
2020-08-17 19:00:00	SPY	ETF	338.08	338.6	338.02	338.6	57194.0
2020-08-17 19:30:00	SPY	ETF	338.64	338.79	338.54	338.63	51064.0
2020-08-17 04:00:00	QQQ	ETF	273.28	273.37	273.0	273.0	12265.0
2020-08-17 04:30:00	QQQ	ETF	273.03	273.22	273.03	273.16	5155.0
2020-08-17 05:00:00	QQQ	ETF	273.17	273.43	273.15	273.39	6200.0
2020-08-17 05:30:00	QQQ	ETF	273.28	273.28	273.12	273.12	3300.0
2020-08-17 06:00:00	QQQ	ETF	273.14	273.3	273.1	273.25	7503.0
2020-08-17 06:30:00	QQQ	ETF	273.29	273.33	273.25	273.33	7475.0
2020-08-17 07:00:00	QQQ	ETF	273.33	273.65	273.25	273.52	60820.0
2020-08-17 07:30:00	QQQ	ETF	273.52	273.57	273.25	273.3	124239.0
2020-08-17 08:00:00	QQQ	ETF	273.3804	273.73	272.59	273.6401	84766.0
2020-08-17 08:30:00	QQQ	ETF	273.66	274.02	273.58	273.92	55676.0
2020-08-17 09:00:00	QQQ	ETF	273.84	274.1	273.84	273.9	44274.0
2020-08-17 09:30:00	QQQ	ETF	273.92	274.86	273.74	274.78	2416060.0
2020-08-17 10:00:00	QQQ	ETF	274.78	275.07	274.13	274.635	1726389.0
2020-08-17 10:30:00	QQQ	ETF	274.635	274.88	274.48	274.625	1327361.0
2020-08-17 11:00:00	QQQ	ETF	274.605	274.85	274.2	274.76	1107823.0
2020-08-17 11:30:00	QQQ	ETF	274.77	274.81	274.17	274.54	865577.0
2020-08-17 12:00:00	QQQ	ETF	274.54	274.74	274.34	274.53	831447.0
2020-08-17 12:30:00	QQQ	ETF	274.52	275.0494	274.5	274.9991	789030.0

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

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