PREVIEW / etf_30min / 2023-05-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-02.parquet
  size:    692 KB
  rows:    27,864

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-02 04:00:00	SPY	ETF	415.16	415.28	415.0	415.1	7400.0
2023-05-02 04:30:00	SPY	ETF	415.14	415.25	414.96	415.05	16215.0
2023-05-02 05:00:00	SPY	ETF	415.06	415.11	414.89	415.0	47895.0
2023-05-02 05:30:00	SPY	ETF	415.0	415.4	414.93	415.2	39617.0
2023-05-02 06:00:00	SPY	ETF	415.08	415.08	414.7	414.98	41256.0
2023-05-02 06:30:00	SPY	ETF	414.95	415.19	414.89	415.13	72085.0
2023-05-02 07:00:00	SPY	ETF	415.13	415.37	415.05	415.12	76987.0
2023-05-02 07:30:00	SPY	ETF	415.09	415.18	414.91	415.06	41080.0
2023-05-02 08:00:00	SPY	ETF	415.1	416.1	414.67	414.75	144322.0
2023-05-02 08:30:00	SPY	ETF	414.63	415.0	414.57	414.76	167800.0
2023-05-02 09:00:00	SPY	ETF	414.72	414.88	414.53	414.77	183806.0
2023-05-02 09:30:00	SPY	ETF	414.77	414.83	413.65	413.8401	5237578.0
2023-05-02 10:00:00	SPY	ETF	413.89	414.11	410.57	410.975	8979916.0
2023-05-02 10:30:00	SPY	ETF	410.975	410.98	408.975	409.0865	9842287.0
2023-05-02 11:00:00	SPY	ETF	409.07	409.2199	408.12	408.42	7784997.0
2023-05-02 11:30:00	SPY	ETF	408.42	409.425	407.82	408.71	6455173.0
2023-05-02 12:00:00	SPY	ETF	408.69	409.385	408.425	409.31	2988860.0
2023-05-02 12:30:00	SPY	ETF	409.32	409.85	409.12	409.67	3525085.0
2023-05-02 13:00:00	SPY	ETF	409.66	410.39	409.48	410.255	3451438.0
2023-05-02 13:30:00	SPY	ETF	410.25	411.29	410.091	410.82	3919931.0
2023-05-02 14:00:00	SPY	ETF	410.83	410.89	409.79	410.205	4276675.0
2023-05-02 14:30:00	SPY	ETF	410.22	411.18	410.03	411.08	3563664.0
2023-05-02 15:00:00	SPY	ETF	411.08	411.58	410.64	411.34	5358822.0
2023-05-02 15:30:00	SPY	ETF	411.34	411.365	410.46	410.87	11377825.0
2023-05-02 16:00:00	SPY	ETF	410.87	411.08	410.78	410.85	3468361.0
2023-05-02 16:30:00	SPY	ETF	410.86	410.89	410.51	410.51	252786.0
2023-05-02 17:00:00	SPY	ETF	410.64	410.64	410.38	410.4896	38286.0
2023-05-02 17:30:00	SPY	ETF	410.49	410.54	410.4	410.4	36282.0
2023-05-02 18:00:00	SPY	ETF	410.5	410.69	410.47	410.59	32904.0
2023-05-02 18:30:00	SPY	ETF	410.64	410.66	410.51	410.56	7501.0
2023-05-02 19:00:00	SPY	ETF	410.51	410.81	410.49	410.78	76044.0
2023-05-02 19:30:00	SPY	ETF	410.78	411.0	410.73	411.0	83203.0
2023-05-02 04:00:00	QQQ	ETF	322.33	322.61	322.22	322.3	19595.0
2023-05-02 04:30:00	QQQ	ETF	322.4	322.51	322.19	322.25	7136.0
2023-05-02 05:00:00	QQQ	ETF	322.14	322.32	322.13	322.18	5322.0
2023-05-02 05:30:00	QQQ	ETF	322.33	322.7	322.2	322.5	12289.0
2023-05-02 06:00:00	QQQ	ETF	322.32	322.32	322.11	322.21	3849.0
2023-05-02 06:30:00	QQQ	ETF	322.3	322.48	322.22	322.31	56951.0
2023-05-02 07:00:00	QQQ	ETF	322.33	322.54	322.25	322.29	88441.0
2023-05-02 07:30:00	QQQ	ETF	322.29	322.3	322.04	322.13	45538.0
2023-05-02 08:00:00	QQQ	ETF	322.3	322.7296	321.81	321.86	122061.0
2023-05-02 08:30:00	QQQ	ETF	321.79	322.26	321.7399	322.06	128738.0
2023-05-02 09:00:00	QQQ	ETF	322.07	322.21	321.92	322.15	115960.0
2023-05-02 09:30:00	QQQ	ETF	322.12	322.45	321.3	321.84	3978222.0
2023-05-02 10:00:00	QQQ	ETF	321.87	322.17	319.67	319.995	5151567.0
2023-05-02 10:30:00	QQQ	ETF	319.9906	319.9906	318.21	318.35	5134550.0
2023-05-02 11:00:00	QQQ	ETF	318.33	318.4509	317.72	318.15	4527504.0
2023-05-02 11:30:00	QQQ	ETF	318.16	318.81	317.61	317.92	3581081.0
2023-05-02 12:00:00	QQQ	ETF	317.91	318.665	317.7	318.65	1751152.0
2023-05-02 12:30:00	QQQ	ETF	318.645	319.23	318.6	319.09	2006999.0

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

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