PREVIEW / etf_30min / 2023-08-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-01.parquet
  size:    732 KB
  rows:    29,241

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-08-01 04:00:00	SPY	ETF	457.3	457.3	456.71	456.72	34914.0
2023-08-01 04:30:00	SPY	ETF	456.65	456.78	456.31	456.78	5120.0
2023-08-01 05:00:00	SPY	ETF	456.63	456.66	456.3	456.38	10244.0
2023-08-01 05:30:00	SPY	ETF	456.28	456.59	456.22	456.59	10165.0
2023-08-01 06:00:00	SPY	ETF	456.58	456.84	456.54	456.84	19817.0
2023-08-01 06:30:00	SPY	ETF	456.67	457.14	456.67	457.1	48966.0
2023-08-01 07:00:00	SPY	ETF	457.1	457.19	456.69	456.69	61985.0
2023-08-01 07:30:00	SPY	ETF	456.61	456.7	456.26	456.35	252886.0
2023-08-01 08:00:00	SPY	ETF	457.18	458.15	455.88	455.89	162848.0
2023-08-01 08:30:00	SPY	ETF	455.89	456.0	455.57	455.86	195775.0
2023-08-01 09:00:00	SPY	ETF	455.86	456.24	455.69	456.21	149225.0
2023-08-01 09:30:00	SPY	ETF	456.27	456.94	456.06	456.79	4373037.0
2023-08-01 10:00:00	SPY	ETF	456.8	457.25	455.53	455.93	6323045.0
2023-08-01 10:30:00	SPY	ETF	455.93	456.645	455.775	456.33	3379561.0
2023-08-01 11:00:00	SPY	ETF	456.34	456.46	455.8	456.2534	2145761.0
2023-08-01 11:30:00	SPY	ETF	456.25	456.33	455.8	456.13	1735017.0
2023-08-01 12:00:00	SPY	ETF	456.14	456.27	455.66	455.79	1751596.0
2023-08-01 12:30:00	SPY	ETF	455.785	456.35	455.49	456.315	1862849.0
2023-08-01 13:00:00	SPY	ETF	456.32	456.5	456.16	456.335	1376728.0
2023-08-01 13:30:00	SPY	ETF	456.34	456.47	455.975	456.43	1590129.0
2023-08-01 14:00:00	SPY	ETF	456.44	456.97	456.415	456.585	2519772.0
2023-08-01 14:30:00	SPY	ETF	456.59	456.88	456.49	456.71	1873470.0
2023-08-01 15:00:00	SPY	ETF	456.72	456.99	456.51	456.69	2080822.0
2023-08-01 15:30:00	SPY	ETF	456.68	456.92	456.19	456.465	5954765.0
2023-08-01 16:00:00	SPY	ETF	456.47	456.52	456.14	456.49	1467731.0
2023-08-01 16:30:00	SPY	ETF	456.5	456.5	456.17	456.26	128508.0
2023-08-01 17:00:00	SPY	ETF	456.29	456.48	454.81	455.33	1068734.0
2023-08-01 17:30:00	SPY	ETF	455.35	455.46	454.35	454.75	209273.0
2023-08-01 18:00:00	SPY	ETF	454.63	455.05	453.54	455.0	350619.0
2023-08-01 18:30:00	SPY	ETF	455.0	455.09	454.81	455.09	35967.0
2023-08-01 19:00:00	SPY	ETF	455.09	455.16	454.77	454.84	23982.0
2023-08-01 19:30:00	SPY	ETF	454.8	455.04	454.67	455.02	47281.0
2023-08-01 04:00:00	QQQ	ETF	383.07	383.16	382.68	382.69	34190.0
2023-08-01 04:30:00	QQQ	ETF	382.64	382.74	382.31	382.67	20928.0
2023-08-01 05:00:00	QQQ	ETF	382.54	382.75	382.3	382.31	10080.0
2023-08-01 05:30:00	QQQ	ETF	382.3	382.56	382.1	382.56	25091.0
2023-08-01 06:00:00	QQQ	ETF	382.58	382.78	382.54	382.7	9316.0
2023-08-01 06:30:00	QQQ	ETF	382.66	383.04	382.52	382.97	13024.0
2023-08-01 07:00:00	QQQ	ETF	382.98	383.1	382.37	382.46	45291.0
2023-08-01 07:30:00	QQQ	ETF	382.41	382.41	381.65	381.65	156811.0
2023-08-01 08:00:00	QQQ	ETF	382.9795	383.99	381.47	381.48	202514.0
2023-08-01 08:30:00	QQQ	ETF	381.49	381.81	381.36	381.779	175833.0
2023-08-01 09:00:00	QQQ	ETF	381.73	382.37	381.65	382.26	214761.0
2023-08-01 09:30:00	QQQ	ETF	382.31	382.589	381.56	381.92	4136302.0
2023-08-01 10:00:00	QQQ	ETF	381.96	382.75	380.69	381.94	4551234.0
2023-08-01 10:30:00	QQQ	ETF	381.95	383.28	381.8447	382.84	3198815.0
2023-08-01 11:00:00	QQQ	ETF	382.85	383.115	382.28	382.945	2053525.0
2023-08-01 11:30:00	QQQ	ETF	382.94	383.09	382.5	382.925	1531078.0
2023-08-01 12:00:00	QQQ	ETF	382.92	382.9899	382.12	382.2888	1315561.0
2023-08-01 12:30:00	QQQ	ETF	382.28	383.08	381.88	383.04	1509048.0

> showing 50 of 29,241 rows — these rows as CSV

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