PREVIEW / etf_30min / 2022-01-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-07.parquet
  size:    664 KB
  rows:    26,020

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-07 04:00:00	SPY	ETF	468.89	468.89	467.24	468.45	31206.0
2022-01-07 04:30:00	SPY	ETF	468.45	468.86	468.43	468.43	22890.0
2022-01-07 05:00:00	SPY	ETF	468.45	469.18	468.21	469.06	20511.0
2022-01-07 05:30:00	SPY	ETF	469.07	469.25	468.95	469.01	24889.0
2022-01-07 06:00:00	SPY	ETF	469.01	469.23	468.8	469.08	26011.0
2022-01-07 06:30:00	SPY	ETF	469.13	469.21	468.62	468.68	35350.0
2022-01-07 07:00:00	SPY	ETF	468.54	469.2	468.49	468.68	29589.0
2022-01-07 07:30:00	SPY	ETF	468.67	468.79	468.23	468.33	46533.0
2022-01-07 08:00:00	SPY	ETF	468.29	469.1996	467.51	468.34	110598.0
2022-01-07 08:30:00	SPY	ETF	468.5	469.3	466.27	466.98	1208983.0
2022-01-07 09:00:00	SPY	ETF	466.99	467.97	466.99	467.95	365773.0
2022-01-07 09:30:00	SPY	ETF	467.95	469.2	466.73	468.64	7708328.0
2022-01-07 10:00:00	SPY	ETF	468.65	468.78	466.81	467.0	4119897.0
2022-01-07 10:30:00	SPY	ETF	467.005	467.35	464.65	465.25	6031743.0
2022-01-07 11:00:00	SPY	ETF	465.27	466.5376	464.685	466.45	5330558.0
2022-01-07 11:30:00	SPY	ETF	466.44	468.09	466.08	467.6574	4020307.0
2022-01-07 12:00:00	SPY	ETF	467.66	467.81	466.77	467.08	2360432.0
2022-01-07 12:30:00	SPY	ETF	467.08	467.43	466.47	467.26	2047100.0
2022-01-07 13:00:00	SPY	ETF	467.26	467.69	466.79	467.01	1933732.0
2022-01-07 13:30:00	SPY	ETF	467.03	467.54	466.59	466.91	1721839.0
2022-01-07 14:00:00	SPY	ETF	466.91	467.15	466.1	466.57	2883405.0
2022-01-07 14:30:00	SPY	ETF	466.57	467.73	466.385	467.47	3130751.0
2022-01-07 15:00:00	SPY	ETF	467.47	467.98	466.65	466.965	3047038.0
2022-01-07 15:30:00	SPY	ETF	466.96	467.48	465.92	466.12	8928329.0
2022-01-07 16:00:00	SPY	ETF	466.13	467.259	465.96	466.07	3656265.0
2022-01-07 16:30:00	SPY	ETF	466.06	466.07	465.95	465.99	67915.0
2022-01-07 17:00:00	SPY	ETF	466.01	466.33	465.99	466.13	87383.0
2022-01-07 17:30:00	SPY	ETF	466.12	466.12	465.9	466.0	50850.0
2022-01-07 18:00:00	SPY	ETF	465.95	466.01	465.9	465.94	8730.0
2022-01-07 18:30:00	SPY	ETF	466.06	466.09	466.02	466.0401	14425.0
2022-01-07 19:00:00	SPY	ETF	466.11	466.11	466.06	466.09	3656.0
2022-01-07 19:30:00	SPY	ETF	466.15	466.15	465.9	465.9	19987.0
2022-01-07 04:00:00	QQQ	ETF	385.35	385.35	382.24	383.99	51201.0
2022-01-07 04:30:00	QQQ	ETF	383.97	384.52	383.84	383.91	54528.0
2022-01-07 05:00:00	QQQ	ETF	383.98	385.11	383.71	385.11	13407.0
2022-01-07 05:30:00	QQQ	ETF	385.05	385.3	384.91	384.94	7148.0
2022-01-07 06:00:00	QQQ	ETF	384.72	385.5	384.63	385.46	17333.0
2022-01-07 06:30:00	QQQ	ETF	385.56	385.64	384.9	384.9	26269.0
2022-01-07 07:00:00	QQQ	ETF	384.95	385.56	384.72	385.04	60391.0
2022-01-07 07:30:00	QQQ	ETF	385.03	385.04	384.3	384.36	55157.0
2022-01-07 08:00:00	QQQ	ETF	385.03	385.59	382.49	384.14	203717.0
2022-01-07 08:30:00	QQQ	ETF	384.61	385.67	380.89	382.1	2008679.0
2022-01-07 09:00:00	QQQ	ETF	382.28	384.1	382.13	384.1	561579.0
2022-01-07 09:30:00	QQQ	ETF	384.03	385.76	381.1	384.8975	10458388.0
2022-01-07 10:00:00	QQQ	ETF	384.9	385.04	381.43	381.65	5878730.0
2022-01-07 10:30:00	QQQ	ETF	381.64	382.165	378.04	379.07	7339933.0
2022-01-07 11:00:00	QQQ	ETF	379.08	380.63	378.62	380.5	4940486.0
2022-01-07 11:30:00	QQQ	ETF	380.5	381.99	379.99	381.31	4382538.0
2022-01-07 12:00:00	QQQ	ETF	381.32	381.66	380.23	380.67	2041350.0
2022-01-07 12:30:00	QQQ	ETF	380.64	381.36	379.85	381.1317	2017492.0

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

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