PREVIEW / etf_30min / 2024-04-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-04.parquet
  size:    809 KB
  rows:    32,517

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-04-04 04:00:00	SPY	ETF	520.61	521.4	520.61	521.34	31195.0
2024-04-04 04:30:00	SPY	ETF	521.36	521.54	521.15	521.26	29376.0
2024-04-04 05:00:00	SPY	ETF	521.24	521.43	521.05	521.42	3566.0
2024-04-04 05:30:00	SPY	ETF	521.41	521.43	521.25	521.35	9218.0
2024-04-04 06:00:00	SPY	ETF	521.32	521.4	521.15	521.37	3517.0
2024-04-04 06:30:00	SPY	ETF	521.3	521.61	521.13	521.56	14693.0
2024-04-04 07:00:00	SPY	ETF	521.62	521.64	521.39	521.44	67265.0
2024-04-04 07:30:00	SPY	ETF	521.44	521.48	520.8	521.39	58353.0
2024-04-04 08:00:00	SPY	ETF	521.6208	521.6208	519.41	521.4	175054.0
2024-04-04 08:30:00	SPY	ETF	521.5	523.1	521.31	522.98	403686.0
2024-04-04 09:00:00	SPY	ETF	523.01	523.6	522.87	523.52	446077.0
2024-04-04 09:30:00	SPY	ETF	523.52	523.7	522.58	522.84	5694197.0
2024-04-04 10:00:00	SPY	ETF	522.84	523.04	522.47	522.92	2252502.0
2024-04-04 10:30:00	SPY	ETF	522.92	522.965	522.61	522.73	1641261.0
2024-04-04 11:00:00	SPY	ETF	522.73	522.87	522.36	522.75	1642932.0
2024-04-04 11:30:00	SPY	ETF	522.77	523.31	522.68	523.26	1706320.0
2024-04-04 12:00:00	SPY	ETF	523.27	523.8674	523.18	523.5102	2413271.0
2024-04-04 12:30:00	SPY	ETF	523.52	523.62	523.28	523.44	1174313.0
2024-04-04 13:00:00	SPY	ETF	523.44	523.47	523.155	523.17	1168932.0
2024-04-04 13:30:00	SPY	ETF	523.17	523.19	521.71	521.86	2710798.0
2024-04-04 14:00:00	SPY	ETF	521.865	521.865	517.84	518.01	10065898.0
2024-04-04 14:30:00	SPY	ETF	518.0	518.0	515.5	515.891	11769351.0
2024-04-04 15:00:00	SPY	ETF	515.89	516.06	513.66	513.69	9661536.0
2024-04-04 15:30:00	SPY	ETF	513.71	514.38	512.755	513.03	17987511.0
2024-04-04 16:00:00	SPY	ETF	513.03	519.8062	512.56	512.65	3150103.0
2024-04-04 16:30:00	SPY	ETF	512.66	513.08	512.58	513.04	277467.0
2024-04-04 17:00:00	SPY	ETF	513.05	513.3	513.05	513.2	115454.0
2024-04-04 17:30:00	SPY	ETF	513.2	513.39	513.2	513.3	27691.0
2024-04-04 18:00:00	SPY	ETF	513.35	514.02	513.12	513.4	120092.0
2024-04-04 18:30:00	SPY	ETF	513.45	513.85	513.4	513.43	29504.0
2024-04-04 19:00:00	SPY	ETF	513.36	513.7	513.32	513.5	11886.0
2024-04-04 19:30:00	SPY	ETF	513.62	513.79	513.37	513.38	30689.0
2024-04-04 04:00:00	QQQ	ETF	443.95	444.3	443.86	444.23	25401.0
2024-04-04 04:30:00	QQQ	ETF	444.22	444.44	444.02	444.07	11655.0
2024-04-04 05:00:00	QQQ	ETF	444.07	444.32	443.93	444.32	7802.0
2024-04-04 05:30:00	QQQ	ETF	444.23	444.35	444.21	444.34	2882.0
2024-04-04 06:00:00	QQQ	ETF	444.21	444.39	444.08	444.35	1867.0
2024-04-04 06:30:00	QQQ	ETF	444.22	444.47	443.92	444.45	10791.0
2024-04-04 07:00:00	QQQ	ETF	444.46	444.48	444.15	444.21	20346.0
2024-04-04 07:30:00	QQQ	ETF	444.2	444.28	444.09	444.28	18283.0
2024-04-04 08:00:00	QQQ	ETF	444.35	444.48	441.769	444.33	80271.0
2024-04-04 08:30:00	QQQ	ETF	444.35	446.32	444.121	446.2	269150.0
2024-04-04 09:00:00	QQQ	ETF	446.25	446.57	446.11	446.38	253151.0
2024-04-04 09:30:00	QQQ	ETF	446.33	446.95	445.4906	445.77	4785832.0
2024-04-04 10:00:00	QQQ	ETF	445.77	446.08	445.03	445.58	1815579.0
2024-04-04 10:30:00	QQQ	ETF	445.58	445.666	445.07	445.39	1259732.0
2024-04-04 11:00:00	QQQ	ETF	445.39	445.59	444.91	445.43	1183295.0
2024-04-04 11:30:00	QQQ	ETF	445.43	446.2	445.34	446.2	1132253.0
2024-04-04 12:00:00	QQQ	ETF	446.2	446.89	446.115	446.63	1824797.0
2024-04-04 12:30:00	QQQ	ETF	446.6401	446.929	446.51	446.705	1079852.0

> showing 50 of 32,517 rows — these rows as CSV

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