PREVIEW / etf_30min / 2023-05-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-22.parquet
  size:    673 KB
  rows:    27,176

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
2023-05-22 04:00:00	SPY	ETF	418.05	418.89	418.05	418.79	20402.0
2023-05-22 04:30:00	SPY	ETF	418.83	418.87	418.69	418.74	3404.0
2023-05-22 05:00:00	SPY	ETF	418.75	418.79	418.64	418.67	10387.0
2023-05-22 05:30:00	SPY	ETF	418.67	418.67	418.44	418.44	15516.0
2023-05-22 06:00:00	SPY	ETF	418.37	418.71	418.37	418.62	46764.0
2023-05-22 06:30:00	SPY	ETF	418.66	418.66	418.18	418.41	20375.0
2023-05-22 07:00:00	SPY	ETF	418.44	418.46	418.1	418.37	37833.0
2023-05-22 07:30:00	SPY	ETF	418.389	418.9	418.37	418.89	33694.0
2023-05-22 08:00:00	SPY	ETF	418.4013	419.25	418.1	419.17	141175.0
2023-05-22 08:30:00	SPY	ETF	419.08	419.22	418.72	418.88	265040.0
2023-05-22 09:00:00	SPY	ETF	418.93	419.0	418.63	418.63	226771.0
2023-05-22 09:30:00	SPY	ETF	418.64	420.39	418.62	419.0684	5551244.0
2023-05-22 10:00:00	SPY	ETF	419.06	419.38	417.35	419.131	7181537.0
2023-05-22 10:30:00	SPY	ETF	419.15	419.35	418.03	418.81	3171234.0
2023-05-22 11:00:00	SPY	ETF	418.82	419.4	418.75	419.2908	2695323.0
2023-05-22 11:30:00	SPY	ETF	419.3	419.5	418.685	419.25	2465141.0
2023-05-22 12:00:00	SPY	ETF	419.25	419.46	418.74	418.895	1918446.0
2023-05-22 12:30:00	SPY	ETF	418.901	419.11	418.77	419.085	1352169.0
2023-05-22 13:00:00	SPY	ETF	419.08	419.43	418.25	419.115	3532015.0
2023-05-22 13:30:00	SPY	ETF	419.08	419.4899	419.07	419.16	1960030.0
2023-05-22 14:00:00	SPY	ETF	419.14	419.71	419.1	419.695	1995732.0
2023-05-22 14:30:00	SPY	ETF	419.7	420.24	419.42	419.76	3139123.0
2023-05-22 15:00:00	SPY	ETF	419.76	419.95	418.76	419.045	3752006.0
2023-05-22 15:30:00	SPY	ETF	419.05	419.09	418.405	418.78	6843680.0
2023-05-22 16:00:00	SPY	ETF	418.77	418.98	418.64	418.84	1995377.0
2023-05-22 16:30:00	SPY	ETF	418.79	419.01	418.74	419.01	125814.0
2023-05-22 17:00:00	SPY	ETF	419.0	419.02	418.79	419.0072	98521.0
2023-05-22 17:30:00	SPY	ETF	418.98	419.05	418.98	419.0	14083.0
2023-05-22 18:00:00	SPY	ETF	419.02	419.08	418.84	419.061	60854.0
2023-05-22 18:30:00	SPY	ETF	419.06	419.16	419.01	419.11	24447.0
2023-05-22 19:00:00	SPY	ETF	419.15	419.98	418.99	419.9	142157.0
2023-05-22 19:30:00	SPY	ETF	419.92	419.94	419.75	419.92	160660.0
2023-05-22 04:00:00	QQQ	ETF	336.57	336.97	336.57	336.89	26369.0
2023-05-22 04:30:00	QQQ	ETF	336.86	336.86	336.57	336.66	7274.0
2023-05-22 05:00:00	QQQ	ETF	336.69	336.7	336.45	336.45	5244.0
2023-05-22 05:30:00	QQQ	ETF	336.49	336.49	336.02	336.06	13672.0
2023-05-22 06:00:00	QQQ	ETF	336.08	336.32	335.91	336.1	20310.0
2023-05-22 06:30:00	QQQ	ETF	336.06	336.2	335.92	336.14	32831.0
2023-05-22 07:00:00	QQQ	ETF	336.14	336.16	335.74	335.98	101761.0
2023-05-22 07:30:00	QQQ	ETF	336.01	336.5	335.98	336.47	62901.0
2023-05-22 08:00:00	QQQ	ETF	336.15	336.93	335.77	336.7	122689.0
2023-05-22 08:30:00	QQQ	ETF	336.68	336.79	336.29	336.45	229160.0
2023-05-22 09:00:00	QQQ	ETF	336.46	336.62	336.21	336.26	343732.0
2023-05-22 09:30:00	QQQ	ETF	336.26	338.67	336.24	338.22	5475728.0
2023-05-22 10:00:00	QQQ	ETF	338.23	338.47	336.61	337.605	4178637.0
2023-05-22 10:30:00	QQQ	ETF	337.61	337.93	337.01	337.76	2467099.0
2023-05-22 11:00:00	QQQ	ETF	337.77	338.15	337.59	337.85	1684395.0
2023-05-22 11:30:00	QQQ	ETF	337.84	338.02	337.08	337.38	1398201.0
2023-05-22 12:00:00	QQQ	ETF	337.38	337.81	337.1001	337.14	1282329.0
2023-05-22 12:30:00	QQQ	ETF	337.15	337.5285	336.918	337.47	781480.0

> showing 50 of 27,176 rows — these rows as CSV

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