PREVIEW / etf_30min / 2022-01-11

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-11.parquet
  size:    672 KB
  rows:    26,226

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-01-11 04:00:00	SPY	ETF	465.99	467.29	465.97	467.24	31099.0
2022-01-11 04:30:00	SPY	ETF	467.24	467.91	467.24	467.55	43697.0
2022-01-11 05:00:00	SPY	ETF	467.59	468.06	467.42	467.46	20401.0
2022-01-11 05:30:00	SPY	ETF	467.34	467.72	467.34	467.45	10406.0
2022-01-11 06:00:00	SPY	ETF	467.47	467.47	466.84	466.92	18277.0
2022-01-11 06:30:00	SPY	ETF	466.92	467.47	466.92	466.96	26131.0
2022-01-11 07:00:00	SPY	ETF	466.81	467.19	466.81	467.07	74859.0
2022-01-11 07:30:00	SPY	ETF	467.11	467.11	466.24	466.24	52265.0
2022-01-11 08:00:00	SPY	ETF	467.0399	467.8896	464.93	466.39	132258.0
2022-01-11 08:30:00	SPY	ETF	466.37	466.7	465.37	465.45	351332.0
2022-01-11 09:00:00	SPY	ETF	465.37	465.48	464.95	465.22	253422.0
2022-01-11 09:30:00	SPY	ETF	465.22	465.46	462.05	462.86	9130623.0
2022-01-11 10:00:00	SPY	ETF	462.86	464.57	462.55	464.09	5027105.0
2022-01-11 10:30:00	SPY	ETF	464.11	464.97	462.35	463.43	5582569.0
2022-01-11 11:00:00	SPY	ETF	463.44	466.76	463.34	466.53	5899712.0
2022-01-11 11:30:00	SPY	ETF	466.55	468.06	466.2079	467.55	3640240.0
2022-01-11 12:00:00	SPY	ETF	467.55	468.01	466.66	466.83	2673950.0
2022-01-11 12:30:00	SPY	ETF	466.82	467.84	466.68	467.76	1724764.0
2022-01-11 13:00:00	SPY	ETF	467.76	468.38	466.99	468.08	2232117.0
2022-01-11 13:30:00	SPY	ETF	468.09	468.57	467.99	468.47	1594602.0
2022-01-11 14:00:00	SPY	ETF	468.46	468.51	467.7	468.375	1810146.0
2022-01-11 14:30:00	SPY	ETF	468.37	469.39	468.035	468.885	2763620.0
2022-01-11 15:00:00	SPY	ETF	468.88	469.63	468.88	469.4464	3665842.0
2022-01-11 15:30:00	SPY	ETF	469.44	469.85	468.54	469.74	9335046.0
2022-01-11 16:00:00	SPY	ETF	469.72	469.97	469.1374	469.63	2343335.0
2022-01-11 16:30:00	SPY	ETF	469.66	469.82	469.64	469.82	127181.0
2022-01-11 17:00:00	SPY	ETF	469.66	469.78	469.6	469.75	64254.0
2022-01-11 17:30:00	SPY	ETF	469.76	469.79	469.7	469.75	17169.0
2022-01-11 18:00:00	SPY	ETF	469.7	469.98	469.57	469.6	81171.0
2022-01-11 18:30:00	SPY	ETF	469.75	469.75	469.55	469.65	16732.0
2022-01-11 19:00:00	SPY	ETF	469.62	470.03	469.6	469.95	23631.0
2022-01-11 19:30:00	SPY	ETF	469.96	470.17	469.75	469.93	42169.0
2022-01-11 04:00:00	QQQ	ETF	380.76	382.45	380.44	382.36	74486.0
2022-01-11 04:30:00	QQQ	ETF	382.37	383.3	382.27	383.0	50387.0
2022-01-11 05:00:00	QQQ	ETF	382.94	383.43	382.78	382.81	25157.0
2022-01-11 05:30:00	QQQ	ETF	382.68	383.3	382.68	382.91	7193.0
2022-01-11 06:00:00	QQQ	ETF	382.9	382.9	382.04	382.1	47300.0
2022-01-11 06:30:00	QQQ	ETF	382.03	382.79	382.03	382.14	38573.0
2022-01-11 07:00:00	QQQ	ETF	382.11	382.53	382.04	382.43	52008.0
2022-01-11 07:30:00	QQQ	ETF	382.44	382.46	381.32	381.4	171644.0
2022-01-11 08:00:00	QQQ	ETF	382.49	383.2796	379.64	381.4504	235180.0
2022-01-11 08:30:00	QQQ	ETF	381.46	381.86	380.16	380.22	318090.0
2022-01-11 09:00:00	QQQ	ETF	380.05	380.12	378.87	379.369	503952.0
2022-01-11 09:30:00	QQQ	ETF	379.35	380.0598	377.2182	379.0	9791064.0
2022-01-11 10:00:00	QQQ	ETF	379.02	381.53	378.54	380.33	6898555.0
2022-01-11 10:30:00	QQQ	ETF	380.34	381.42	377.93	379.38	5888148.0
2022-01-11 11:00:00	QQQ	ETF	379.4	383.9782	379.229	383.87	6143752.0
2022-01-11 11:30:00	QQQ	ETF	383.8684	385.67	383.38	385.5399	4416774.0
2022-01-11 12:00:00	QQQ	ETF	385.56	385.79	383.68	383.85	3098621.0
2022-01-11 12:30:00	QQQ	ETF	383.88	384.73	383.68	384.34	2139177.0

> showing 50 of 26,226 rows — these rows as CSV

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