PREVIEW / etf_30min / 2023-07-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-28.parquet
  size:    699 KB
  rows:    28,063

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-07-28 04:00:00	SPY	ETF	454.21	454.34	453.65	453.65	13998.0
2023-07-28 04:30:00	SPY	ETF	453.7	454.11	453.7	454.11	8490.0
2023-07-28 05:00:00	SPY	ETF	454.14	454.28	454.0	454.12	23465.0
2023-07-28 05:30:00	SPY	ETF	454.19	454.72	454.16	454.57	59831.0
2023-07-28 06:00:00	SPY	ETF	454.64	454.64	454.37	454.42	11001.0
2023-07-28 06:30:00	SPY	ETF	454.45	454.6	454.12	454.5	59696.0
2023-07-28 07:00:00	SPY	ETF	454.48	454.9	454.0	454.85	140461.0
2023-07-28 07:30:00	SPY	ETF	454.85	455.13	454.76	455.05	100484.0
2023-07-28 08:00:00	SPY	ETF	454.73	455.57	452.17	455.569	212981.0
2023-07-28 08:30:00	SPY	ETF	455.59	455.81	455.15	455.78	462074.0
2023-07-28 09:00:00	SPY	ETF	455.78	455.98	455.43	455.84	275870.0
2023-07-28 09:30:00	SPY	ETF	455.88	456.59	455.16	456.1499	7063964.0
2023-07-28 10:00:00	SPY	ETF	456.14	456.87	456.03	456.4	6094756.0
2023-07-28 10:30:00	SPY	ETF	456.395	456.83	455.94	456.7822	3955134.0
2023-07-28 11:00:00	SPY	ETF	456.79	457.6195	456.59	457.44	2927176.0
2023-07-28 11:30:00	SPY	ETF	457.445	457.78	457.21	457.68	2846834.0
2023-07-28 12:00:00	SPY	ETF	457.675	457.68	456.88	457.5957	2755087.0
2023-07-28 12:30:00	SPY	ETF	457.6	457.62	456.9299	457.0399	2056667.0
2023-07-28 13:00:00	SPY	ETF	457.04	457.045	456.15	456.1512	2611931.0
2023-07-28 13:30:00	SPY	ETF	456.15	456.45	455.06	456.27	4380106.0
2023-07-28 14:00:00	SPY	ETF	456.27	456.935	456.21	456.91	3007311.0
2023-07-28 14:30:00	SPY	ETF	456.9086	457.36	456.14	457.0099	2940017.0
2023-07-28 15:00:00	SPY	ETF	457.01	457.305	456.64	456.666	2660535.0
2023-07-28 15:30:00	SPY	ETF	456.665	457.18	456.33	456.91	11578385.0
2023-07-28 16:00:00	SPY	ETF	456.88	456.9914	455.0	456.95	3548358.0
2023-07-28 16:30:00	SPY	ETF	456.94	456.95	456.81	456.9	249416.0
2023-07-28 17:00:00	SPY	ETF	456.73	457.08	456.73	457.05	39373.0
2023-07-28 17:30:00	SPY	ETF	457.08	457.09	456.9	456.96	34408.0
2023-07-28 18:00:00	SPY	ETF	456.92	457.0	456.51	456.86	39400.0
2023-07-28 18:30:00	SPY	ETF	456.85	456.92	456.7	456.7	4179.0
2023-07-28 19:00:00	SPY	ETF	456.83	456.92	456.83	456.8999	6955.0
2023-07-28 19:30:00	SPY	ETF	456.9	457.01	456.84	457.01	17710.0
2023-07-28 04:00:00	QQQ	ETF	379.17	379.54	378.31	378.79	44824.0
2023-07-28 04:30:00	QQQ	ETF	378.77	379.19	378.77	379.1	14147.0
2023-07-28 05:00:00	QQQ	ETF	379.16	379.25	378.9	379.16	19409.0
2023-07-28 05:30:00	QQQ	ETF	379.19	379.8	379.11	379.8	43648.0
2023-07-28 06:00:00	QQQ	ETF	379.82	379.9	379.59	379.65	16861.0
2023-07-28 06:30:00	QQQ	ETF	379.65	380.06	379.33	379.79	21756.0
2023-07-28 07:00:00	QQQ	ETF	379.76	380.24	379.52	380.06	83624.0
2023-07-28 07:30:00	QQQ	ETF	380.04	380.29	380.0	380.2	100612.0
2023-07-28 08:00:00	QQQ	ETF	379.7608	381.0	376.338	380.76	282792.0
2023-07-28 08:30:00	QQQ	ETF	380.8	381.1	380.39	380.88	409087.0
2023-07-28 09:00:00	QQQ	ETF	380.91	381.29	380.4	380.72	317448.0
2023-07-28 09:30:00	QQQ	ETF	380.74	382.69	380.22	382.02	6294738.0
2023-07-28 10:00:00	QQQ	ETF	382.03	382.93	381.82	382.18	3175900.0
2023-07-28 10:30:00	QQQ	ETF	382.16	383.12	381.79	382.6102	2710590.0
2023-07-28 11:00:00	QQQ	ETF	382.63	384.03	382.565	383.7647	2306743.0
2023-07-28 11:30:00	QQQ	ETF	383.75	384.52	383.61	384.49	2103334.0
2023-07-28 12:00:00	QQQ	ETF	384.485	384.49	383.56	384.395	2470188.0
2023-07-28 12:30:00	QQQ	ETF	384.4	384.42	383.345	383.53	1809950.0

> showing 50 of 28,063 rows — these rows as CSV

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