PREVIEW / etf_30min / 2023-07-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-03.parquet
  size:    474 KB
  rows:    17,516

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-07-03 04:00:00	SPY	ETF	443.5	443.75	443.5	443.67	19407.0
2023-07-03 04:30:00	SPY	ETF	443.69	443.85	443.67	443.71	8518.0
2023-07-03 05:00:00	SPY	ETF	443.71	443.71	443.59	443.63	7038.0
2023-07-03 05:30:00	SPY	ETF	443.57	443.63	443.51	443.58	9380.0
2023-07-03 06:00:00	SPY	ETF	443.6	443.95	443.31	443.95	168641.0
2023-07-03 06:30:00	SPY	ETF	443.9	443.93	443.61	443.61	14807.0
2023-07-03 07:00:00	SPY	ETF	443.62	443.68	443.44	443.521	16875.0
2023-07-03 07:30:00	SPY	ETF	443.5	443.5	443.1	443.17	29136.0
2023-07-03 08:00:00	SPY	ETF	443.5311	443.89	443.0203	443.21	66717.0
2023-07-03 08:30:00	SPY	ETF	443.21	443.21	442.95	443.12	88820.0
2023-07-03 09:00:00	SPY	ETF	443.11	443.3	442.82	442.96	149849.0
2023-07-03 09:30:00	SPY	ETF	442.92	443.55	442.63	443.46	4652255.0
2023-07-03 10:00:00	SPY	ETF	443.5	443.68	443.0899	443.4801	2764185.0
2023-07-03 10:30:00	SPY	ETF	443.49	443.57	443.02	443.2001	2688934.0
2023-07-03 11:00:00	SPY	ETF	443.21	443.61	443.16	443.545	2037027.0
2023-07-03 11:30:00	SPY	ETF	443.55	443.72	443.4365	443.625	2338828.0
2023-07-03 12:00:00	SPY	ETF	443.6199	443.95	443.55	443.89	2100178.0
2023-07-03 12:30:00	SPY	ETF	443.885	444.08	443.71	443.89	5827084.0
2023-07-03 13:00:00	SPY	ETF	443.9	444.03	443.59	443.94	1719478.0
2023-07-03 13:30:00	SPY	ETF	443.9	444.0	443.62	443.79	72759.0
2023-07-03 14:00:00	SPY	ETF	443.71	443.9	443.6991	443.9	72058.0
2023-07-03 14:30:00	SPY	ETF	443.9	443.97	443.88	443.91	2371.0
2023-07-03 15:00:00	SPY	ETF	443.9	443.97	443.9	443.97	3084.0
2023-07-03 15:30:00	SPY	ETF	444.0	444.1	443.9	443.99	10413.0
2023-07-03 16:00:00	SPY	ETF	444.03	444.03	443.81	443.81	2636.0
2023-07-03 16:30:00	SPY	ETF	443.75	444.0	443.75	443.95	11936.0
2023-07-03 04:00:00	QQQ	ETF	370.29	370.86	370.26	370.63	20000.0
2023-07-03 04:30:00	QQQ	ETF	370.61	370.99	370.61	370.78	18167.0
2023-07-03 05:00:00	QQQ	ETF	370.71	370.75	370.57	370.64	10018.0
2023-07-03 05:30:00	QQQ	ETF	370.58	370.59	370.5	370.56	4939.0
2023-07-03 06:00:00	QQQ	ETF	370.54	370.63	369.87	370.57	13220.0
2023-07-03 06:30:00	QQQ	ETF	370.51	370.57	370.3	370.3	19899.0
2023-07-03 07:00:00	QQQ	ETF	370.37	370.4	370.04	370.1	113970.0
2023-07-03 07:30:00	QQQ	ETF	370.1	370.1	369.68	369.68	47360.0
2023-07-03 08:00:00	QQQ	ETF	370.39	370.9404	369.55	369.87	96181.0
2023-07-03 08:30:00	QQQ	ETF	369.89	370.15	369.61	370.01	68410.0
2023-07-03 09:00:00	QQQ	ETF	369.95	370.2	369.82	370.08	158770.0
2023-07-03 09:30:00	QQQ	ETF	370.07	370.93	369.66	370.47	3628276.0
2023-07-03 10:00:00	QQQ	ETF	370.5	370.8601	369.85	370.1079	2005617.0
2023-07-03 10:30:00	QQQ	ETF	370.1	370.19	369.0301	369.14	2328831.0
2023-07-03 11:00:00	QQQ	ETF	369.16	369.59	369.0	369.31	1761367.0
2023-07-03 11:30:00	QQQ	ETF	369.32	369.42	368.97	369.3062	1390718.0
2023-07-03 12:00:00	QQQ	ETF	369.3	369.87	369.1808	369.7399	1370020.0
2023-07-03 12:30:00	QQQ	ETF	369.73	370.3801	369.66	370.34	2613561.0
2023-07-03 13:00:00	QQQ	ETF	370.35	370.37	370.0	370.02	285009.0
2023-07-03 13:30:00	QQQ	ETF	370.04	370.29	369.97	370.0199	54991.0
2023-07-03 14:00:00	QQQ	ETF	370.02	370.09	369.97	369.97	21177.0
2023-07-03 14:30:00	QQQ	ETF	369.95	370.05	369.93	370.05	7935.0
2023-07-03 15:00:00	QQQ	ETF	370.02	370.1	370.02	370.05	3628.0
2023-07-03 15:30:00	QQQ	ETF	370.05	370.18	370.05	370.15	3994.0

> showing 50 of 17,516 rows — these rows as CSV

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