PREVIEW / etf_30min / 2023-07-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-18.parquet
  size:    735 KB
  rows:    28,490

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-18 04:00:00	SPY	ETF	450.52	450.98	450.52	450.92	10092.0
2023-07-18 04:30:00	SPY	ETF	450.91	451.02	450.5	450.65	9044.0
2023-07-18 05:00:00	SPY	ETF	450.62	450.8	450.62	450.75	2122.0
2023-07-18 05:30:00	SPY	ETF	450.79	451.01	450.79	450.9	2699.0
2023-07-18 06:00:00	SPY	ETF	450.94	451.01	450.72	450.72	3686.0
2023-07-18 06:30:00	SPY	ETF	450.73	450.73	450.56	450.66	3865.0
2023-07-18 07:00:00	SPY	ETF	450.61	450.74	450.58	450.67	12136.0
2023-07-18 07:30:00	SPY	ETF	450.68	450.68	450.42	450.61	13578.0
2023-07-18 08:00:00	SPY	ETF	450.24	450.84	450.24	450.55	48289.0
2023-07-18 08:30:00	SPY	ETF	450.7	450.75	450.01	450.29	184924.0
2023-07-18 09:00:00	SPY	ETF	450.29	450.52	450.19	450.5	72105.0
2023-07-18 09:30:00	SPY	ETF	450.5	451.63	450.0484	451.52	5357983.0
2023-07-18 10:00:00	SPY	ETF	451.51	451.835	451.43	451.64	3454921.0
2023-07-18 10:30:00	SPY	ETF	451.65	452.31	451.3401	452.26	2677162.0
2023-07-18 11:00:00	SPY	ETF	452.26	452.69	452.26	452.32	2730377.0
2023-07-18 11:30:00	SPY	ETF	452.33	453.3784	452.05	453.2	4593424.0
2023-07-18 12:00:00	SPY	ETF	453.22	453.28	452.44	452.99	2852365.0
2023-07-18 12:30:00	SPY	ETF	452.98	453.1399	452.775	452.845	2321200.0
2023-07-18 13:00:00	SPY	ETF	452.85	453.4	452.82	453.1801	2440296.0
2023-07-18 13:30:00	SPY	ETF	453.19	453.52	453.13	453.49	2029327.0
2023-07-18 14:00:00	SPY	ETF	453.485	454.32	453.41	454.31	3492253.0
2023-07-18 14:30:00	SPY	ETF	454.315	454.43	453.76	454.15	3142611.0
2023-07-18 15:00:00	SPY	ETF	454.155	454.845	453.8398	454.485	3506784.0
2023-07-18 15:30:00	SPY	ETF	454.48	454.86	454.09	454.19	14949887.0
2023-07-18 16:00:00	SPY	ETF	454.18	454.19	453.0	453.87	4103674.0
2023-07-18 16:30:00	SPY	ETF	453.87	453.95	453.77	453.77	100559.0
2023-07-18 17:00:00	SPY	ETF	453.87	453.87	453.75	453.75	25917.0
2023-07-18 17:30:00	SPY	ETF	453.75	453.83	453.73	453.73	10880.0
2023-07-18 18:00:00	SPY	ETF	453.7	454.06	453.7	454.0	30845.0
2023-07-18 18:30:00	SPY	ETF	453.98	454.0	453.93	453.95	7000.0
2023-07-18 19:00:00	SPY	ETF	454.01	454.07	454.0	454.01	26396.0
2023-07-18 19:30:00	SPY	ETF	454.01	454.12	453.98	454.04	31462.0
2023-07-18 04:00:00	QQQ	ETF	382.33	382.62	382.33	382.44	13060.0
2023-07-18 04:30:00	QQQ	ETF	382.46	382.57	382.02	382.19	10338.0
2023-07-18 05:00:00	QQQ	ETF	382.17	382.24	382.12	382.2	4063.0
2023-07-18 05:30:00	QQQ	ETF	382.17	382.4	382.15	382.31	4756.0
2023-07-18 06:00:00	QQQ	ETF	382.35	382.43	382.11	382.11	28677.0
2023-07-18 06:30:00	QQQ	ETF	382.13	382.17	381.91	382.11	51945.0
2023-07-18 07:00:00	QQQ	ETF	382.12	382.34	382.12	382.15	44035.0
2023-07-18 07:30:00	QQQ	ETF	382.1	382.14	381.9	382.1	35635.0
2023-07-18 08:00:00	QQQ	ETF	382.1389	382.34	381.88	382.24	65107.0
2023-07-18 08:30:00	QQQ	ETF	382.19	382.48	381.52	381.92	289240.0
2023-07-18 09:00:00	QQQ	ETF	381.95	382.02	381.7	381.93	95804.0
2023-07-18 09:30:00	QQQ	ETF	381.95	381.99	380.0	381.1062	5725336.0
2023-07-18 10:00:00	QQQ	ETF	381.09	381.36	380.48	380.8	3117079.0
2023-07-18 10:30:00	QQQ	ETF	380.79	381.6	380.43	381.32	2618069.0
2023-07-18 11:00:00	QQQ	ETF	381.33	381.78	381.13	381.15	1607218.0
2023-07-18 11:30:00	QQQ	ETF	381.165	383.73	380.92	383.5588	5444963.0
2023-07-18 12:00:00	QQQ	ETF	383.56	384.205	383.22	384.205	3867662.0
2023-07-18 12:30:00	QQQ	ETF	384.19	384.67	383.89	384.1727	2913626.0

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

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