PREVIEW / etf_30min / 2023-12-04

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-04.parquet
  size:    793 KB
  rows:    31,131

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-04 04:00:00	SPY	ETF	458.06	459.0	457.6	457.74	31004.0
2023-12-04 04:30:00	SPY	ETF	457.77	458.0	457.68	458.0	4316.0
2023-12-04 05:00:00	SPY	ETF	458.0	458.01	457.81	458.01	9786.0
2023-12-04 05:30:00	SPY	ETF	457.96	458.0	457.63	457.8	8745.0
2023-12-04 06:00:00	SPY	ETF	457.85	457.95	457.65	457.81	15310.0
2023-12-04 06:30:00	SPY	ETF	457.89	457.89	457.38	457.53	120267.0
2023-12-04 07:00:00	SPY	ETF	457.51	457.52	457.18	457.43	51080.0
2023-12-04 07:30:00	SPY	ETF	457.43	457.84	457.4	457.76	80280.0
2023-12-04 08:00:00	SPY	ETF	457.45	458.46	457.1696	457.42	127218.0
2023-12-04 08:30:00	SPY	ETF	457.42	457.43	456.4	456.44	333561.0
2023-12-04 09:00:00	SPY	ETF	456.45	456.48	455.32	455.62	672131.0
2023-12-04 09:30:00	SPY	ETF	455.6	456.83	455.51	455.99	6839436.0
2023-12-04 10:00:00	SPY	ETF	455.98	456.315	454.64	454.8151	5813607.0
2023-12-04 10:30:00	SPY	ETF	454.815	455.08	454.34	454.5501	5716252.0
2023-12-04 11:00:00	SPY	ETF	454.55	455.16	454.43	455.07	3533423.0
2023-12-04 11:30:00	SPY	ETF	455.0643	456.03	454.87	455.94	3156617.0
2023-12-04 12:00:00	SPY	ETF	455.95	456.45	455.76	456.2564	3059842.0
2023-12-04 12:30:00	SPY	ETF	456.25	456.74	456.17	456.67	2840981.0
2023-12-04 13:00:00	SPY	ETF	456.67	456.69	455.84	455.86	2568093.0
2023-12-04 13:30:00	SPY	ETF	455.865	456.28	455.765	455.89	2253318.0
2023-12-04 14:00:00	SPY	ETF	455.8898	456.0999	455.495	455.84	2571368.0
2023-12-04 14:30:00	SPY	ETF	455.835	456.19	455.68	455.985	2350992.0
2023-12-04 15:00:00	SPY	ETF	455.98	456.15	455.67	456.03	2675041.0
2023-12-04 15:30:00	SPY	ETF	456.035	456.937	455.81	456.66	9856182.0
2023-12-04 16:00:00	SPY	ETF	456.66	456.7997	455.9554	456.28	2457543.0
2023-12-04 16:30:00	SPY	ETF	456.3	456.31	455.924	456.28	428183.0
2023-12-04 17:00:00	SPY	ETF	456.28	456.29	456.13	456.2	28621.0
2023-12-04 17:30:00	SPY	ETF	456.25	456.27	456.1	456.2	19577.0
2023-12-04 18:00:00	SPY	ETF	456.21	456.27	456.04	456.07	38499.0
2023-12-04 18:30:00	SPY	ETF	456.04	456.05	455.86	455.96	15455.0
2023-12-04 19:00:00	SPY	ETF	455.9603	455.99	455.89	455.89	16010.0
2023-12-04 19:30:00	SPY	ETF	455.95	455.99	455.8199	455.82	42022.0
2023-12-04 04:00:00	QQQ	ETF	389.03	389.9	388.6	388.67	22189.0
2023-12-04 04:30:00	QQQ	ETF	388.74	388.78	388.43	388.66	9443.0
2023-12-04 05:00:00	QQQ	ETF	388.71	388.83	388.51	388.78	9359.0
2023-12-04 05:30:00	QQQ	ETF	388.68	388.81	388.37	388.61	15825.0
2023-12-04 06:00:00	QQQ	ETF	388.72	388.76	388.4	388.57	17572.0
2023-12-04 06:30:00	QQQ	ETF	388.59	388.61	388.02	388.19	31330.0
2023-12-04 07:00:00	QQQ	ETF	388.16	388.24	387.75	388.22	90185.0
2023-12-04 07:30:00	QQQ	ETF	388.15	388.6	388.12	388.51	31045.0
2023-12-04 08:00:00	QQQ	ETF	388.1494	390.232	387.72	388.1694	102324.0
2023-12-04 08:30:00	QQQ	ETF	388.14	388.15	387.09	387.17	236951.0
2023-12-04 09:00:00	QQQ	ETF	387.17	387.18	385.7601	386.11	388927.0
2023-12-04 09:30:00	QQQ	ETF	386.09	386.42	385.13	385.5291	5089366.0
2023-12-04 10:00:00	QQQ	ETF	385.51	386.295	383.25	383.42	5161350.0
2023-12-04 10:30:00	QQQ	ETF	383.42	383.68	382.66	383.055	4258340.0
2023-12-04 11:00:00	QQQ	ETF	383.05	383.85	382.84	383.85	2311688.0
2023-12-04 11:30:00	QQQ	ETF	383.84	385.285	383.62	385.195	2388226.0
2023-12-04 12:00:00	QQQ	ETF	385.2	385.79	384.97	385.48	2361712.0
2023-12-04 12:30:00	QQQ	ETF	385.49	386.19	385.455	386.0806	2112724.0

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

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