PREVIEW / etf_1hour / 2021-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-07.parquet
  size:    430 KB
  rows:    15,075

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-10-07 04:00:00	SPY	ETF	437.01	437.94	436.99	437.6	78189.0
2021-10-07 05:00:00	SPY	ETF	437.49	437.66	437.32	437.66	8554.0
2021-10-07 06:00:00	SPY	ETF	437.73	438.59	437.65	438.59	154017.0
2021-10-07 07:00:00	SPY	ETF	438.55	439.3	438.43	438.9	426938.0
2021-10-07 08:00:00	SPY	ETF	438.6201	439.37	436.55	439.0	620738.0
2021-10-07 09:00:00	SPY	ETF	439.02	440.6771	438.12	440.67	10116905.0
2021-10-07 10:00:00	SPY	ETF	440.67	441.68	440.52	441.34	11625464.0
2021-10-07 11:00:00	SPY	ETF	441.345	441.41	440.46	441.375	5304973.0
2021-10-07 12:00:00	SPY	ETF	441.39	441.55	440.7	441.16	4068079.0
2021-10-07 13:00:00	SPY	ETF	441.16	441.22	440.48	440.5673	3547961.0
2021-10-07 14:00:00	SPY	ETF	440.56	440.62	439.02	439.15	6347392.0
2021-10-07 15:00:00	SPY	ETF	439.14	440.0	438.2	438.64	13197302.0
2021-10-07 16:00:00	SPY	ETF	438.63	439.02	438.46	438.58	3001757.0
2021-10-07 17:00:00	SPY	ETF	438.73	438.76	438.62	438.67	182996.0
2021-10-07 18:00:00	SPY	ETF	438.66	439.14	438.6	439.14	68863.0
2021-10-07 19:00:00	SPY	ETF	439.18	439.65	439.0	439.58	49949.0
2021-10-07 04:00:00	QQQ	ETF	363.09	363.48	362.76	363.23	113989.0
2021-10-07 05:00:00	QQQ	ETF	363.22	363.33	362.85	362.95	34247.0
2021-10-07 06:00:00	QQQ	ETF	363.14	363.55	362.85	363.52	61379.0
2021-10-07 07:00:00	QQQ	ETF	363.51	364.44	363.44	364.16	361705.0
2021-10-07 08:00:00	QQQ	ETF	363.7601	364.43	359.67	363.59	474214.0
2021-10-07 09:00:00	QQQ	ETF	363.56	364.62	362.25	364.6	6370159.0
2021-10-07 10:00:00	QQQ	ETF	364.61	365.65	364.4	365.23	6095312.0
2021-10-07 11:00:00	QQQ	ETF	365.24	365.66	364.57	365.635	3256756.0
2021-10-07 12:00:00	QQQ	ETF	365.64	365.69	364.88	365.34	2427637.0
2021-10-07 13:00:00	QQQ	ETF	365.3375	365.3375	364.65	364.76	2237588.0
2021-10-07 14:00:00	QQQ	ETF	364.76	364.88	363.57	363.89	3995428.0
2021-10-07 15:00:00	QQQ	ETF	363.9	364.43	362.49	362.93	6920340.0
2021-10-07 16:00:00	QQQ	ETF	362.94	363.3	362.83	363.02	1132491.0
2021-10-07 17:00:00	QQQ	ETF	363.15	363.15	362.93	363.02	19524.0
2021-10-07 18:00:00	QQQ	ETF	363.02	363.3	362.98	363.27	50307.0
2021-10-07 19:00:00	QQQ	ETF	363.34	364.0	363.16	363.81	57116.0
2021-10-07 04:00:00	IWM	ETF	220.86	221.0	220.25	220.72	53044.0
2021-10-07 05:00:00	IWM	ETF	220.65	220.78	220.6	220.77	3325.0
2021-10-07 06:00:00	IWM	ETF	221.1	221.65	220.89	221.65	63860.0
2021-10-07 07:00:00	IWM	ETF	221.65	221.95	221.5	221.83	58775.0
2021-10-07 08:00:00	IWM	ETF	221.84	222.06	221.03	221.71	78268.0
2021-10-07 09:00:00	IWM	ETF	221.73	223.48	221.37	223.32	3914787.0
2021-10-07 10:00:00	IWM	ETF	223.33	224.36	223.27	224.02	3408705.0
2021-10-07 11:00:00	IWM	ETF	224.015	224.505	224.01	224.4203	2026816.0
2021-10-07 12:00:00	IWM	ETF	224.43	224.6	224.1	224.58	1458141.0
2021-10-07 13:00:00	IWM	ETF	224.59	224.95	224.38	224.49	1563405.0
2021-10-07 14:00:00	IWM	ETF	224.48	224.53	223.26	223.45	1767891.0
2021-10-07 15:00:00	IWM	ETF	223.43	223.88	222.88	223.34	3141282.0
2021-10-07 16:00:00	IWM	ETF	223.26	223.6	223.1682	223.26	1503821.0
2021-10-07 17:00:00	IWM	ETF	223.46	223.46	223.1	223.39	10128.0
2021-10-07 18:00:00	IWM	ETF	223.35	223.65	223.26	223.61	20949.0
2021-10-07 19:00:00	IWM	ETF	223.68	224.07	223.6	224.0	44340.0
2021-10-07 04:00:00	DIA	ETF	345.6	346.01	345.28	345.97	2250.0
2021-10-07 05:00:00	DIA	ETF	345.73	345.73	345.73	345.73	100.0

> showing 50 of 15,075 rows — these rows as CSV

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