PREVIEW / etf_30min / 2022-12-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-29.parquet
  size:    714 KB
  rows:    28,299

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
2022-12-29 04:00:00	SPY	ETF	377.09	378.28	377.03	378.18	42895.0
2022-12-29 04:30:00	SPY	ETF	378.12	378.46	378.05	378.37	7610.0
2022-12-29 05:00:00	SPY	ETF	378.3	378.38	378.03	378.19	25954.0
2022-12-29 05:30:00	SPY	ETF	378.1	378.48	378.05	378.48	14489.0
2022-12-29 06:00:00	SPY	ETF	378.5	378.88	378.5	378.62	37321.0
2022-12-29 06:30:00	SPY	ETF	378.57	378.7	378.38	378.58	13680.0
2022-12-29 07:00:00	SPY	ETF	378.59	378.76	378.2	378.68	64787.0
2022-12-29 07:30:00	SPY	ETF	378.63	378.63	378.42	378.55	34654.0
2022-12-29 08:00:00	SPY	ETF	378.59	378.99	377.05	378.73	177483.0
2022-12-29 08:30:00	SPY	ETF	378.7	380.16	378.65	379.7	395455.0
2022-12-29 09:00:00	SPY	ETF	379.66	380.0	379.5099	379.66	231581.0
2022-12-29 09:30:00	SPY	ETF	379.63	381.8099	379.08	381.6	6054982.0
2022-12-29 10:00:00	SPY	ETF	381.6	382.92	381.3401	382.3	5554682.0
2022-12-29 10:30:00	SPY	ETF	382.3184	383.26	382.315	383.1101	4574289.0
2022-12-29 11:00:00	SPY	ETF	383.12	383.2501	382.275	382.86	2854846.0
2022-12-29 11:30:00	SPY	ETF	382.85	384.24	382.85	383.89	3109564.0
2022-12-29 12:00:00	SPY	ETF	383.89	384.14	383.615	383.795	2433117.0
2022-12-29 12:30:00	SPY	ETF	383.8	383.98	383.26	383.8	1689372.0
2022-12-29 13:00:00	SPY	ETF	383.81	383.98	383.19	383.6001	1718364.0
2022-12-29 13:30:00	SPY	ETF	383.61	383.98	383.34	383.88	1413621.0
2022-12-29 14:00:00	SPY	ETF	383.87	384.35	383.6	383.605	1947741.0
2022-12-29 14:30:00	SPY	ETF	383.61	384.09	383.4305	383.55	1644984.0
2022-12-29 15:00:00	SPY	ETF	383.52	383.91	383.15	383.4363	2825172.0
2022-12-29 15:30:00	SPY	ETF	383.435	384.04	383.19	383.39	7520398.0
2022-12-29 16:00:00	SPY	ETF	383.39	383.55	383.14	383.22	4557268.0
2022-12-29 16:30:00	SPY	ETF	383.21	383.44	382.99	383.08	326864.0
2022-12-29 17:00:00	SPY	ETF	383.05	383.09	382.94	383.04	65268.0
2022-12-29 17:30:00	SPY	ETF	383.01	383.1	383.01	383.1	25510.0
2022-12-29 18:00:00	SPY	ETF	383.1	383.18	382.75	382.79	37916.0
2022-12-29 18:30:00	SPY	ETF	382.8	382.87	382.7	382.76	26716.0
2022-12-29 19:00:00	SPY	ETF	382.79	382.83	382.59	382.71	17498.0
2022-12-29 19:30:00	SPY	ETF	382.7	382.79	382.66	382.73	20172.0
2022-12-29 04:00:00	QQQ	ETF	260.91	261.92	260.91	261.84	24468.0
2022-12-29 04:30:00	QQQ	ETF	261.62	261.9	261.62	261.84	10483.0
2022-12-29 05:00:00	QQQ	ETF	261.8	261.86	261.64	261.8	16656.0
2022-12-29 05:30:00	QQQ	ETF	261.71	262.04	261.71	261.97	27770.0
2022-12-29 06:00:00	QQQ	ETF	262.03	262.38	262.03	262.08	22517.0
2022-12-29 06:30:00	QQQ	ETF	262.12	262.12	261.78	261.99	19505.0
2022-12-29 07:00:00	QQQ	ETF	261.95	262.12	261.68	261.8	72627.0
2022-12-29 07:30:00	QQQ	ETF	261.84	261.85	261.65	261.81	38384.0
2022-12-29 08:00:00	QQQ	ETF	262.06	262.3404	260.295	261.89	169117.0
2022-12-29 08:30:00	QQQ	ETF	261.92	263.37	261.92	263.03	581880.0
2022-12-29 09:00:00	QQQ	ETF	263.07	263.34	262.85	262.96	504035.0
2022-12-29 09:30:00	QQQ	ETF	262.96	265.14	262.25	264.7883	5568422.0
2022-12-29 10:00:00	QQQ	ETF	264.8	266.09	264.34	265.51	3458421.0
2022-12-29 10:30:00	QQQ	ETF	265.53	266.58	265.53	266.47	2031543.0
2022-12-29 11:00:00	QQQ	ETF	266.48	266.61	265.77	266.275	1804138.0
2022-12-29 11:30:00	QQQ	ETF	266.29	267.405	266.285	267.1	2130400.0
2022-12-29 12:00:00	QQQ	ETF	267.1	267.24	266.55	266.7049	1717398.0
2022-12-29 12:30:00	QQQ	ETF	266.69	266.77	266.15	266.575	1284981.0

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

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