PREVIEW / etf_30min / 2022-01-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-06.parquet
  size:    671 KB
  rows:    26,642

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-06 04:00:00	SPY	ETF	468.46	468.49	467.7	468.11	24348.0
2022-01-06 04:30:00	SPY	ETF	468.0	468.17	467.55	468.17	19377.0
2022-01-06 05:00:00	SPY	ETF	468.29	469.02	468.09	468.84	25320.0
2022-01-06 05:30:00	SPY	ETF	468.95	469.46	468.64	468.78	39006.0
2022-01-06 06:00:00	SPY	ETF	468.78	469.17	468.34	468.38	54514.0
2022-01-06 06:30:00	SPY	ETF	468.4	468.7	468.06	468.29	18330.0
2022-01-06 07:00:00	SPY	ETF	468.24	468.93	467.95	468.05	81401.0
2022-01-06 07:30:00	SPY	ETF	467.97	468.5	467.87	468.28	102999.0
2022-01-06 08:00:00	SPY	ETF	468.28	469.0504	466.4	468.57	248768.0
2022-01-06 08:30:00	SPY	ETF	468.6	468.86	468.11	468.52	246913.0
2022-01-06 09:00:00	SPY	ETF	468.49	468.78	467.8	467.88	343576.0
2022-01-06 09:30:00	SPY	ETF	467.89	470.395	466.81	467.05	9171192.0
2022-01-06 10:00:00	SPY	ETF	467.04	468.65	465.43	467.66	8335557.0
2022-01-06 10:30:00	SPY	ETF	467.655	469.72	467.64	468.72	5904077.0
2022-01-06 11:00:00	SPY	ETF	468.74	469.985	468.07	468.59	4383145.0
2022-01-06 11:30:00	SPY	ETF	468.6	469.35	468.03	469.22	3265225.0
2022-01-06 12:00:00	SPY	ETF	469.22	469.75	468.69	469.63	2686250.0
2022-01-06 12:30:00	SPY	ETF	469.635	470.82	469.3	469.56	3299938.0
2022-01-06 13:00:00	SPY	ETF	469.56	469.975	468.53	468.63	2398500.0
2022-01-06 13:30:00	SPY	ETF	468.63	469.17	468.4	469.07	2101335.0
2022-01-06 14:00:00	SPY	ETF	469.07	469.61	468.28	468.77	2859406.0
2022-01-06 14:30:00	SPY	ETF	468.75	469.68	468.58	469.42	2819812.0
2022-01-06 15:00:00	SPY	ETF	469.39	470.175	468.355	468.96	3584885.0
2022-01-06 15:30:00	SPY	ETF	468.97	469.13	467.09	467.93	10508721.0
2022-01-06 16:00:00	SPY	ETF	467.93	468.56	467.8	468.45	2466746.0
2022-01-06 16:30:00	SPY	ETF	468.5	468.71	467.94	468.58	461469.0
2022-01-06 17:00:00	SPY	ETF	468.51	468.64	468.51	468.51	19239.0
2022-01-06 17:30:00	SPY	ETF	468.55	468.67	468.55	468.65	13404.0
2022-01-06 18:00:00	SPY	ETF	468.68	469.15	468.68	469.03	68544.0
2022-01-06 18:30:00	SPY	ETF	467.94	469.18	467.94	469.18	27020.0
2022-01-06 19:00:00	SPY	ETF	469.06	469.6	469.06	469.6	41792.0
2022-01-06 19:30:00	SPY	ETF	469.5	469.69	469.5	469.59	22298.0
2022-01-06 04:00:00	QQQ	ETF	384.15	384.15	382.78	383.53	53805.0
2022-01-06 04:30:00	QQQ	ETF	383.42	383.44	382.91	383.4	22009.0
2022-01-06 05:00:00	QQQ	ETF	383.53	384.09	383.31	383.92	31024.0
2022-01-06 05:30:00	QQQ	ETF	384.01	384.18	383.19	383.19	75830.0
2022-01-06 06:00:00	QQQ	ETF	383.44	383.63	382.57	382.7	46543.0
2022-01-06 06:30:00	QQQ	ETF	382.67	383.06	382.21	382.48	82781.0
2022-01-06 07:00:00	QQQ	ETF	382.41	383.16	382.07	382.12	139563.0
2022-01-06 07:30:00	QQQ	ETF	382.16	382.5	381.73	382.22	148057.0
2022-01-06 08:00:00	QQQ	ETF	382.1801	384.578	380.97	382.7	319286.0
2022-01-06 08:30:00	QQQ	ETF	382.94	383.06	382.12	382.5	269165.0
2022-01-06 09:00:00	QQQ	ETF	382.3	383.36	382.19	382.3	528303.0
2022-01-06 09:30:00	QQQ	ETF	382.39	386.26	381.94	383.07	9681049.0
2022-01-06 10:00:00	QQQ	ETF	383.05	384.87	380.13	383.92	10491347.0
2022-01-06 10:30:00	QQQ	ETF	383.91	386.7676	383.86	386.03	6314013.0
2022-01-06 11:00:00	QQQ	ETF	386.03	387.35	384.83	385.48	4318999.0
2022-01-06 11:30:00	QQQ	ETF	385.49	386.29	384.32	385.81	3489040.0
2022-01-06 12:00:00	QQQ	ETF	385.87	386.19	384.83	385.73	2124517.0
2022-01-06 12:30:00	QQQ	ETF	385.71	387.12	385.17	385.56	2203127.0

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

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