PREVIEW / etf_30min / 2023-12-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-27.parquet
  size:    790 KB
  rows:    31,591

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-12-27 04:00:00	SPY	ETF	475.64	475.66	475.55	475.65	7869.0
2023-12-27 04:30:00	SPY	ETF	475.63	475.66	475.49	475.56	2405.0
2023-12-27 05:00:00	SPY	ETF	475.6	475.63	475.49	475.55	2592.0
2023-12-27 05:30:00	SPY	ETF	475.62	475.64	475.58	475.64	3180.0
2023-12-27 06:00:00	SPY	ETF	475.55	475.69	475.55	475.69	16280.0
2023-12-27 06:30:00	SPY	ETF	475.69	475.69	475.55	475.64	4126.0
2023-12-27 07:00:00	SPY	ETF	475.66	475.66	475.37	475.59	19920.0
2023-12-27 07:30:00	SPY	ETF	475.55	475.72	475.55	475.69	17192.0
2023-12-27 08:00:00	SPY	ETF	475.47	476.07	475.45	476.02	54251.0
2023-12-27 08:30:00	SPY	ETF	476.01	476.08	475.74	475.74	40292.0
2023-12-27 09:00:00	SPY	ETF	475.72	475.74	475.32	475.3803	88316.0
2023-12-27 09:30:00	SPY	ETF	475.44	476.14	475.27	476.01	3712431.0
2023-12-27 10:00:00	SPY	ETF	476.01	476.14	475.16	475.74	3023818.0
2023-12-27 10:30:00	SPY	ETF	475.74	475.79	475.08	475.41	2472171.0
2023-12-27 11:00:00	SPY	ETF	475.41	475.485	475.185	475.47	2142623.0
2023-12-27 11:30:00	SPY	ETF	475.47	475.93	475.41	475.775	1874445.0
2023-12-27 12:00:00	SPY	ETF	475.77	476.07	475.57	475.84	1552395.0
2023-12-27 12:30:00	SPY	ETF	475.84	475.97	475.29	475.55	1423727.0
2023-12-27 13:00:00	SPY	ETF	475.54	476.66	475.54	476.2399	2952052.0
2023-12-27 13:30:00	SPY	ETF	476.25	476.49	476.01	476.02	1433017.0
2023-12-27 14:00:00	SPY	ETF	476.02	476.0203	474.89	475.8062	4093894.0
2023-12-27 14:30:00	SPY	ETF	475.8	475.83	475.19	475.51	2164321.0
2023-12-27 15:00:00	SPY	ETF	475.51	475.935	475.36	475.645	2311806.0
2023-12-27 15:30:00	SPY	ETF	475.63	476.57	475.16	476.51	10344196.0
2023-12-27 16:00:00	SPY	ETF	476.5	476.73	476.2344	476.42	3655774.0
2023-12-27 16:30:00	SPY	ETF	476.51	476.63	476.48	476.6099	104147.0
2023-12-27 17:00:00	SPY	ETF	476.58	476.64	476.51	476.57	883902.0
2023-12-27 17:30:00	SPY	ETF	476.59	476.6	476.54	476.54	9552.0
2023-12-27 18:00:00	SPY	ETF	476.56	476.66	476.43	476.57	34945.0
2023-12-27 18:30:00	SPY	ETF	476.55	476.6073	476.5	476.55	18114.0
2023-12-27 19:00:00	SPY	ETF	476.5601	476.7496	476.5601	476.73	19231.0
2023-12-27 19:30:00	SPY	ETF	476.7399	476.9	476.7399	476.9	10273.0
2023-12-27 04:00:00	QQQ	ETF	411.07	411.08	410.74	410.81	32544.0
2023-12-27 04:30:00	QQQ	ETF	410.83	410.87	410.75	410.8	3657.0
2023-12-27 05:00:00	QQQ	ETF	410.81	410.85	410.7	410.82	3065.0
2023-12-27 05:30:00	QQQ	ETF	410.85	410.91	410.75	410.8	14390.0
2023-12-27 06:00:00	QQQ	ETF	410.75	410.89	410.75	410.87	3415.0
2023-12-27 06:30:00	QQQ	ETF	410.82	410.89	410.78	410.8	2275.0
2023-12-27 07:00:00	QQQ	ETF	410.85	410.889	410.6	410.77	35111.0
2023-12-27 07:30:00	QQQ	ETF	410.77	410.93	410.65	410.87	12223.0
2023-12-27 08:00:00	QQQ	ETF	410.85	411.29	410.6196	411.22	47387.0
2023-12-27 08:30:00	QQQ	ETF	411.25	411.3	411.08	411.18	28009.0
2023-12-27 09:00:00	QQQ	ETF	411.12	411.27	410.9	410.97	43669.0
2023-12-27 09:30:00	QQQ	ETF	410.95	411.655	410.94	411.51	2076721.0
2023-12-27 10:00:00	QQQ	ETF	411.51	411.714	410.08	410.68	2111742.0
2023-12-27 10:30:00	QQQ	ETF	410.68	410.7	410.15	410.62	1456599.0
2023-12-27 11:00:00	QQQ	ETF	410.61	410.64	410.29	410.6101	1160528.0
2023-12-27 11:30:00	QQQ	ETF	410.63	411.08	410.57	410.88	1427179.0
2023-12-27 12:00:00	QQQ	ETF	410.88	411.05	410.71	410.92	970566.0
2023-12-27 12:30:00	QQQ	ETF	410.91	411.07	410.36	410.59	1130282.0

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

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