PREVIEW / etf_30min / 2021-11-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-18.parquet
  size:    640 KB
  rows:    24,452

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
2021-11-18 04:00:00	SPY	ETF	469.25	469.83	469.25	469.8	33175.0
2021-11-18 04:30:00	SPY	ETF	469.85	469.85	469.45	469.45	6733.0
2021-11-18 05:00:00	SPY	ETF	469.33	469.45	469.22	469.42	54566.0
2021-11-18 05:30:00	SPY	ETF	469.34	469.55	469.34	469.55	2485.0
2021-11-18 06:00:00	SPY	ETF	469.49	469.8	469.39	469.78	56757.0
2021-11-18 06:30:00	SPY	ETF	469.74	469.74	469.57	469.61	8055.0
2021-11-18 07:00:00	SPY	ETF	469.62	469.63	469.25	469.43	78727.0
2021-11-18 07:30:00	SPY	ETF	469.42	469.44	469.18	469.21	89868.0
2021-11-18 08:00:00	SPY	ETF	469.6	469.8004	468.471	469.23	119068.0
2021-11-18 08:30:00	SPY	ETF	469.22	469.47	469.17	469.21	94931.0
2021-11-18 09:00:00	SPY	ETF	469.23	469.49	469.15	469.23	108647.0
2021-11-18 09:30:00	SPY	ETF	469.24	469.3	468.275	468.49	4119527.0
2021-11-18 10:00:00	SPY	ETF	468.5	468.7	466.34	466.82	4591089.0
2021-11-18 10:30:00	SPY	ETF	466.83	467.68	466.78	467.505	2928669.0
2021-11-18 11:00:00	SPY	ETF	467.49	468.15	467.12	467.98	2538294.0
2021-11-18 11:30:00	SPY	ETF	467.97	469.25	467.95	469.0	2375574.0
2021-11-18 12:00:00	SPY	ETF	469.04	469.97	469.03	469.88	1805387.0
2021-11-18 12:30:00	SPY	ETF	469.88	469.94	468.77	469.015	2174574.0
2021-11-18 13:00:00	SPY	ETF	469.0	469.56	468.88	469.18	1465091.0
2021-11-18 13:30:00	SPY	ETF	469.17	469.47	469.05	469.3799	1186905.0
2021-11-18 14:00:00	SPY	ETF	469.355	469.49	468.8	468.98	1597861.0
2021-11-18 14:30:00	SPY	ETF	468.97	469.559	468.64	469.49	1315915.0
2021-11-18 15:00:00	SPY	ETF	469.49	469.8	469.36	469.73	1920893.0
2021-11-18 15:30:00	SPY	ETF	469.73	470.01	469.41	469.72	7022895.0
2021-11-18 16:00:00	SPY	ETF	469.71	470.0	469.0	469.75	2305282.0
2021-11-18 16:30:00	SPY	ETF	469.77	470.13	469.75	470.0	105507.0
2021-11-18 17:00:00	SPY	ETF	470.0	470.04	469.94	469.96	36385.0
2021-11-18 17:30:00	SPY	ETF	469.97	470.0	469.73	469.97	47195.0
2021-11-18 18:00:00	SPY	ETF	469.97	470.21	469.79	470.02	53310.0
2021-11-18 18:30:00	SPY	ETF	469.73	470.16	469.73	470.01	17695.0
2021-11-18 19:00:00	SPY	ETF	470.01	470.25	469.9096	470.03	23795.0
2021-11-18 19:30:00	SPY	ETF	470.04	470.17	470.03	470.1	24046.0
2021-11-18 04:00:00	QQQ	ETF	398.62	400.0	398.62	399.94	48409.0
2021-11-18 04:30:00	QQQ	ETF	399.92	399.92	399.46	399.46	21107.0
2021-11-18 05:00:00	QQQ	ETF	399.47	399.58	399.35	399.58	17323.0
2021-11-18 05:30:00	QQQ	ETF	399.56	399.78	399.55	399.78	4659.0
2021-11-18 06:00:00	QQQ	ETF	399.76	399.95	399.61	399.87	22505.0
2021-11-18 06:30:00	QQQ	ETF	399.76	399.91	399.71	399.79	13306.0
2021-11-18 07:00:00	QQQ	ETF	399.74	399.799	399.63	399.73	48222.0
2021-11-18 07:30:00	QQQ	ETF	399.77	399.82	399.55	399.61	41221.0
2021-11-18 08:00:00	QQQ	ETF	399.6701	399.9496	397.928	399.58	131852.0
2021-11-18 08:30:00	QQQ	ETF	399.59	399.88	399.58	399.71	126442.0
2021-11-18 09:00:00	QQQ	ETF	399.73	399.96	399.64	399.7104	145550.0
2021-11-18 09:30:00	QQQ	ETF	399.72	400.31	398.65	399.71	4390104.0
2021-11-18 10:00:00	QQQ	ETF	399.76	400.26	397.45	398.2	4898529.0
2021-11-18 10:30:00	QQQ	ETF	398.18	399.14	398.11	398.81	2099386.0
2021-11-18 11:00:00	QQQ	ETF	398.78	399.72	398.18	399.44	1891227.0
2021-11-18 11:30:00	QQQ	ETF	399.44	401.68	399.44	401.1	2894283.0
2021-11-18 12:00:00	QQQ	ETF	401.09	401.87	401.04	401.86	1453562.0
2021-11-18 12:30:00	QQQ	ETF	401.86	401.94	400.35	400.7	2071337.0

> showing 50 of 24,452 rows — these rows as CSV

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