PREVIEW / etf_30min / 2024-03-27

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-27.parquet
  size:    791 KB
  rows:    31,605

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
2024-03-27 04:00:00	SPY	ETF	520.32	520.79	520.3	520.66	25834.0
2024-03-27 04:30:00	SPY	ETF	520.72	520.86	520.57	520.66	10344.0
2024-03-27 05:00:00	SPY	ETF	520.82	520.94	520.72	520.72	3474.0
2024-03-27 05:30:00	SPY	ETF	520.62	520.94	520.51	520.87	5750.0
2024-03-27 06:00:00	SPY	ETF	520.94	521.19	520.75	521.13	18588.0
2024-03-27 06:30:00	SPY	ETF	521.15	521.36	521.14	521.27	17822.0
2024-03-27 07:00:00	SPY	ETF	521.24	521.29	520.36	521.17	221631.0
2024-03-27 07:30:00	SPY	ETF	521.19	521.25	520.86	520.91	80412.0
2024-03-27 08:00:00	SPY	ETF	520.93	521.31	520.3	520.68	189263.0
2024-03-27 08:30:00	SPY	ETF	520.7	521.35	520.7	521.33	156636.0
2024-03-27 09:00:00	SPY	ETF	521.34	521.85	521.33	521.71	189022.0
2024-03-27 09:30:00	SPY	ETF	521.71	521.78	520.74	520.89	4933610.0
2024-03-27 10:00:00	SPY	ETF	520.9	520.95	519.73	519.9398	4665321.0
2024-03-27 10:30:00	SPY	ETF	519.935	520.425	519.63	519.845	3379157.0
2024-03-27 11:00:00	SPY	ETF	519.85	520.16	519.69	519.69	1735356.0
2024-03-27 11:30:00	SPY	ETF	519.71	520.08	519.53	519.54	1862570.0
2024-03-27 12:00:00	SPY	ETF	519.54	520.1286	519.485	520.08	1497074.0
2024-03-27 12:30:00	SPY	ETF	520.08	520.4799	520.07	520.3099	1586361.0
2024-03-27 13:00:00	SPY	ETF	520.31	520.5	519.73	520.325	1635824.0
2024-03-27 13:30:00	SPY	ETF	520.33	520.435	520.094	520.175	926342.0
2024-03-27 14:00:00	SPY	ETF	520.18	520.91	520.02	520.84	1911192.0
2024-03-27 14:30:00	SPY	ETF	520.8401	520.98	520.14	520.27	1992071.0
2024-03-27 15:00:00	SPY	ETF	520.27	521.05	519.84	520.9	3081870.0
2024-03-27 15:30:00	SPY	ETF	520.895	523.2	520.767	523.17	17549071.0
2024-03-27 16:00:00	SPY	ETF	523.17	523.54	522.97	523.26	4640534.0
2024-03-27 16:30:00	SPY	ETF	523.3	523.4	522.8983	522.91	1308485.0
2024-03-27 17:00:00	SPY	ETF	522.94	523.04	522.9	523.03	72078.0
2024-03-27 17:30:00	SPY	ETF	523.03	523.17	522.69	522.98	135915.0
2024-03-27 18:00:00	SPY	ETF	522.95	523.17	522.29	522.61	92225.0
2024-03-27 18:30:00	SPY	ETF	522.56	522.68	522.37	522.43	41572.0
2024-03-27 19:00:00	SPY	ETF	522.45	522.6	522.4	522.6	15990.0
2024-03-27 19:30:00	SPY	ETF	522.6	522.63	522.37	522.43	21204.0
2024-03-27 04:00:00	QQQ	ETF	444.38	445.15	444.38	445.07	32507.0
2024-03-27 04:30:00	QQQ	ETF	445.05	445.37	444.94	445.18	13303.0
2024-03-27 05:00:00	QQQ	ETF	445.25	445.47	445.09	445.22	6712.0
2024-03-27 05:30:00	QQQ	ETF	445.18	445.4	444.9	445.31	22499.0
2024-03-27 06:00:00	QQQ	ETF	445.25	445.71	445.19	445.71	38675.0
2024-03-27 06:30:00	QQQ	ETF	445.74	445.88	445.65	445.84	43506.0
2024-03-27 07:00:00	QQQ	ETF	445.74	445.76	445.41	445.6	50468.0
2024-03-27 07:30:00	QQQ	ETF	445.62	445.67	445.34	445.41	30612.0
2024-03-27 08:00:00	QQQ	ETF	445.36	445.83	444.4	445.19	86363.0
2024-03-27 08:30:00	QQQ	ETF	445.22	446.0	445.22	446.0	117343.0
2024-03-27 09:00:00	QQQ	ETF	446.01	446.5202	445.9745	446.36	126562.0
2024-03-27 09:30:00	QQQ	ETF	446.43	446.54	443.5196	443.621	4129793.0
2024-03-27 10:00:00	QQQ	ETF	443.61	443.8	441.93	442.77	3728906.0
2024-03-27 10:30:00	QQQ	ETF	442.8	443.47	442.49	442.9	1935853.0
2024-03-27 11:00:00	QQQ	ETF	442.9	443.14	442.43	442.4499	1262590.0
2024-03-27 11:30:00	QQQ	ETF	442.47	443.07	442.2	442.325	1779521.0
2024-03-27 12:00:00	QQQ	ETF	442.32	443.34	442.23	443.275	1282512.0
2024-03-27 12:30:00	QQQ	ETF	443.28	443.69	443.19	443.39	1164413.0

> showing 50 of 31,605 rows — these rows as CSV

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