PREVIEW / etf_30min / 2021-05-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-03.parquet
  size:    626 KB
  rows:    23,952

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
2021-05-03 04:00:00	SPY	ETF	419.2	419.2	418.91	418.91	7933.0
2021-05-03 04:30:00	SPY	ETF	418.96	419.21	418.91	418.91	1850.0
2021-05-03 05:00:00	SPY	ETF	418.94	418.94	418.66	418.66	9837.0
2021-05-03 05:30:00	SPY	ETF	418.26	418.38	417.95	418.38	78954.0
2021-05-03 06:00:00	SPY	ETF	418.38	418.71	418.36	418.63	122039.0
2021-05-03 06:30:00	SPY	ETF	418.7	419.33	418.7	419.01	118397.0
2021-05-03 07:00:00	SPY	ETF	418.93	419.4	418.93	419.3	76897.0
2021-05-03 07:30:00	SPY	ETF	419.33	419.44	419.05	419.15	121693.0
2021-05-03 08:00:00	SPY	ETF	419.33	419.42	419.0	419.21	227124.0
2021-05-03 08:30:00	SPY	ETF	419.23	419.6	418.88	418.89	223947.0
2021-05-03 09:00:00	SPY	ETF	418.85	419.43	418.81	419.43	186278.0
2021-05-03 09:30:00	SPY	ETF	419.43	419.84	418.62	419.49	5562239.0
2021-05-03 10:00:00	SPY	ETF	419.48	419.74	418.87	419.35	4203261.0
2021-05-03 10:30:00	SPY	ETF	419.35	419.74	418.59	418.799	3147995.0
2021-05-03 11:00:00	SPY	ETF	418.793	418.793	418.17	418.225	3394083.0
2021-05-03 11:30:00	SPY	ETF	418.22	418.96	418.14	418.8119	2606768.0
2021-05-03 12:00:00	SPY	ETF	418.793	418.81	418.34	418.425	1407931.0
2021-05-03 12:30:00	SPY	ETF	418.41	418.56	418.18	418.47	1861611.0
2021-05-03 13:00:00	SPY	ETF	418.48	418.71	418.26	418.345	1365657.0
2021-05-03 13:30:00	SPY	ETF	418.345	418.64	418.285	418.57	1254390.0
2021-05-03 14:00:00	SPY	ETF	418.57	418.98	418.57	418.935	1931460.0
2021-05-03 14:30:00	SPY	ETF	418.93	419.27	418.92	419.115	2599898.0
2021-05-03 15:00:00	SPY	ETF	419.12	419.135	418.46	418.6	3653541.0
2021-05-03 15:30:00	SPY	ETF	418.61	418.64	417.665	418.1699	9811329.0
2021-05-03 16:00:00	SPY	ETF	418.17	418.3	417.82	417.9	2124104.0
2021-05-03 16:30:00	SPY	ETF	417.9	418.2	417.89	417.95	100774.0
2021-05-03 17:00:00	SPY	ETF	418.02	418.05	417.76	417.98	95794.0
2021-05-03 17:30:00	SPY	ETF	417.98	418.2	417.82	417.98	39332.0
2021-05-03 18:00:00	SPY	ETF	417.97	418.1	417.9	417.94	14668.0
2021-05-03 18:30:00	SPY	ETF	418.2	418.2	417.9	417.95	9520.0
2021-05-03 19:00:00	SPY	ETF	417.94	417.95	417.48	417.63	23224.0
2021-05-03 19:30:00	SPY	ETF	417.62	417.71	417.52	417.61	13665.0
2021-05-03 04:00:00	QQQ	ETF	338.61	338.97	338.49	338.49	46474.0
2021-05-03 04:30:00	QQQ	ETF	338.51	338.56	338.33	338.36	4512.0
2021-05-03 05:00:00	QQQ	ETF	338.27	338.32	337.84	337.85	15244.0
2021-05-03 05:30:00	QQQ	ETF	337.81	337.92	337.52	337.9	28366.0
2021-05-03 06:00:00	QQQ	ETF	337.9	338.08	337.87	337.96	12785.0
2021-05-03 06:30:00	QQQ	ETF	337.96	338.64	337.96	338.24	55891.0
2021-05-03 07:00:00	QQQ	ETF	338.29	338.79	338.29	338.75	46588.0
2021-05-03 07:30:00	QQQ	ETF	338.63	338.86	338.45	338.63	123892.0
2021-05-03 08:00:00	QQQ	ETF	338.43	339.0	338.11	338.82	94358.0
2021-05-03 08:30:00	QQQ	ETF	338.83	339.19	338.78	338.85	110104.0
2021-05-03 09:00:00	QQQ	ETF	338.91	339.21	338.77	339.17	124517.0
2021-05-03 09:30:00	QQQ	ETF	339.24	339.24	337.67	338.24	3805178.0
2021-05-03 10:00:00	QQQ	ETF	338.24	340.0	337.85	339.46	2965273.0
2021-05-03 10:30:00	QQQ	ETF	339.46	339.73	337.3399	337.5799	2423909.0
2021-05-03 11:00:00	QQQ	ETF	337.56	337.565	335.85	335.98	2360811.0
2021-05-03 11:30:00	QQQ	ETF	335.95	337.0	335.915	336.74	1390451.0
2021-05-03 12:00:00	QQQ	ETF	336.73	336.93	336.23	336.2628	907898.0
2021-05-03 12:30:00	QQQ	ETF	336.25	336.31	335.73	336.19	1145541.0

> showing 50 of 23,952 rows — these rows as CSV

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