PREVIEW / etf_30min / 2023-07-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-20.parquet
  size:    711 KB
  rows:    28,536

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-20 04:00:00	SPY	ETF	454.55	454.97	454.55	454.8	18075.0
2023-07-20 04:30:00	SPY	ETF	454.75	454.82	454.72	454.74	11458.0
2023-07-20 05:00:00	SPY	ETF	454.72	454.72	454.48	454.6	4423.0
2023-07-20 05:30:00	SPY	ETF	454.6	454.76	454.46	454.73	4193.0
2023-07-20 06:00:00	SPY	ETF	454.72	455.03	454.69	454.98	15059.0
2023-07-20 06:30:00	SPY	ETF	454.91	455.1	454.81	454.9	6411.0
2023-07-20 07:00:00	SPY	ETF	454.89	454.89	454.59	454.67	97316.0
2023-07-20 07:30:00	SPY	ETF	454.63	454.92	454.58	454.83	43228.0
2023-07-20 08:00:00	SPY	ETF	454.84	454.9496	454.4	454.47	109877.0
2023-07-20 08:30:00	SPY	ETF	454.47	454.49	454.08	454.13	143028.0
2023-07-20 09:00:00	SPY	ETF	454.11	454.22	453.64	454.16	291981.0
2023-07-20 09:30:00	SPY	ETF	454.16	455.1	454.08	454.81	5401782.0
2023-07-20 10:00:00	SPY	ETF	454.82	454.95	453.23	453.485	5364719.0
2023-07-20 10:30:00	SPY	ETF	453.49	453.85	452.81	453.67	4855471.0
2023-07-20 11:00:00	SPY	ETF	453.665	454.17	453.44	453.74	3123168.0
2023-07-20 11:30:00	SPY	ETF	453.74	454.365	453.71	454.06	2785489.0
2023-07-20 12:00:00	SPY	ETF	454.06	454.78	453.87	453.87	3103234.0
2023-07-20 12:30:00	SPY	ETF	453.88	453.96	453.33	453.495	2854822.0
2023-07-20 13:00:00	SPY	ETF	453.5	453.7	453.19	453.6604	1873600.0
2023-07-20 13:30:00	SPY	ETF	453.66	453.805	453.255	453.3989	1747490.0
2023-07-20 14:00:00	SPY	ETF	453.39	453.49	452.0891	452.09	3436418.0
2023-07-20 14:30:00	SPY	ETF	452.115	452.77	452.085	452.485	3088038.0
2023-07-20 15:00:00	SPY	ETF	452.49	452.745	451.44	451.5199	4281844.0
2023-07-20 15:30:00	SPY	ETF	451.52	452.41	451.515	452.18	9314398.0
2023-07-20 16:00:00	SPY	ETF	452.18	452.52	452.16	452.48	2411977.0
2023-07-20 16:30:00	SPY	ETF	452.49	452.5	452.34	452.34	121531.0
2023-07-20 17:00:00	SPY	ETF	452.38	452.48	452.31	452.4	14546.0
2023-07-20 17:30:00	SPY	ETF	452.32	452.42	452.31	452.3102	21457.0
2023-07-20 18:00:00	SPY	ETF	452.5	452.53	452.27	452.41	22206.0
2023-07-20 18:30:00	SPY	ETF	452.3701	452.41	452.13	452.2	18224.0
2023-07-20 19:00:00	SPY	ETF	452.2	452.34	452.2	452.33	3352.0
2023-07-20 19:30:00	SPY	ETF	452.33	452.41	452.19	452.25	16009.0
2023-07-20 04:00:00	QQQ	ETF	383.03	383.22	382.46	382.5	29672.0
2023-07-20 04:30:00	QQQ	ETF	382.43	382.67	382.41	382.58	16751.0
2023-07-20 05:00:00	QQQ	ETF	382.53	382.62	382.38	382.57	6945.0
2023-07-20 05:30:00	QQQ	ETF	382.61	382.65	382.26	382.65	8783.0
2023-07-20 06:00:00	QQQ	ETF	382.63	383.25	382.6	383.19	30167.0
2023-07-20 06:30:00	QQQ	ETF	383.2	383.37	383.02	383.13	23887.0
2023-07-20 07:00:00	QQQ	ETF	383.22	383.23	382.72	382.95	90251.0
2023-07-20 07:30:00	QQQ	ETF	382.94	383.48	382.76	383.43	89547.0
2023-07-20 08:00:00	QQQ	ETF	383.19	384.04	382.4604	383.21	155129.0
2023-07-20 08:30:00	QQQ	ETF	383.15	383.17	382.25	382.58	354578.0
2023-07-20 09:00:00	QQQ	ETF	382.58	382.74	381.9	382.5704	476601.0
2023-07-20 09:30:00	QQQ	ETF	382.61	384.095	382.54	383.27	5868754.0
2023-07-20 10:00:00	QQQ	ETF	383.28	383.37	380.475	380.7	5634517.0
2023-07-20 10:30:00	QQQ	ETF	380.695	380.7093	379.36	380.0301	5264953.0
2023-07-20 11:00:00	QQQ	ETF	380.03	380.98	379.93	380.43	3011947.0
2023-07-20 11:30:00	QQQ	ETF	380.43	381.45	380.32	380.46	2722489.0
2023-07-20 12:00:00	QQQ	ETF	380.47	381.39	379.689	379.71	2903713.0
2023-07-20 12:30:00	QQQ	ETF	379.73	379.89	379.03	379.24	2746778.0

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

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