PREVIEW / etf_1hour / 2021-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-31.parquet
  size:    432 KB
  rows:    15,357

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-12-31 04:00:00	SPY	ETF	475.83	476.08	475.59	475.79	4405.0
2021-12-31 05:00:00	SPY	ETF	475.88	475.88	475.43	475.51	8036.0
2021-12-31 06:00:00	SPY	ETF	475.48	475.56	474.96	475.07	100092.0
2021-12-31 07:00:00	SPY	ETF	475.06	475.77	474.69	475.66	122187.0
2021-12-31 08:00:00	SPY	ETF	475.6796	476.0	474.79	475.68	125650.0
2021-12-31 09:00:00	SPY	ETF	475.67	476.86	475.44	475.71	4046894.0
2021-12-31 10:00:00	SPY	ETF	475.7	476.26	474.87	475.8	5305649.0
2021-12-31 11:00:00	SPY	ETF	475.8	475.95	475.26	475.32	2820234.0
2021-12-31 12:00:00	SPY	ETF	475.34	476.1701	474.94	476.1371	3190353.0
2021-12-31 13:00:00	SPY	ETF	476.13	476.49	475.87	476.32	2664778.0
2021-12-31 14:00:00	SPY	ETF	476.32	476.66	475.75	475.96	4587925.0
2021-12-31 15:00:00	SPY	ETF	475.945	476.7	474.67	474.88	15392567.0
2021-12-31 16:00:00	SPY	ETF	474.88	475.55	474.7634	475.03	4288123.0
2021-12-31 17:00:00	SPY	ETF	474.95	475.33	474.95	475.15	47850.0
2021-12-31 18:00:00	SPY	ETF	475.15	475.23	474.96	475.13	7336.0
2021-12-31 19:00:00	SPY	ETF	475.07	475.32	475.04	475.32	18422.0
2021-12-31 04:00:00	QQQ	ETF	400.0	400.14	399.42	399.86	20516.0
2021-12-31 05:00:00	QQQ	ETF	399.82	399.82	399.5	399.6	9091.0
2021-12-31 06:00:00	QQQ	ETF	399.5	399.5	398.98	399.11	18696.0
2021-12-31 07:00:00	QQQ	ETF	399.13	399.93	398.77	399.88	64204.0
2021-12-31 08:00:00	QQQ	ETF	399.28	400.4	398.82	400.1996	141394.0
2021-12-31 09:00:00	QQQ	ETF	400.14	401.0589	399.1	399.34	3334643.0
2021-12-31 10:00:00	QQQ	ETF	399.38	399.99	398.37	399.19	3364634.0
2021-12-31 11:00:00	QQQ	ETF	399.16	399.595	398.42	398.82	2236566.0
2021-12-31 12:00:00	QQQ	ETF	398.84	399.2	398.2	399.17	2276178.0
2021-12-31 13:00:00	QQQ	ETF	399.16	399.39	398.54	398.861	2201094.0
2021-12-31 14:00:00	QQQ	ETF	398.86	399.055	398.4	398.59	2334936.0
2021-12-31 15:00:00	QQQ	ETF	398.6	399.2	397.34	397.56	7659457.0
2021-12-31 16:00:00	QQQ	ETF	397.59	398.7	397.59	397.8	1123596.0
2021-12-31 17:00:00	QQQ	ETF	397.85	397.901	397.7	397.85	296966.0
2021-12-31 18:00:00	QQQ	ETF	397.81	397.9199	397.75	397.75	122116.0
2021-12-31 19:00:00	QQQ	ETF	397.83	398.09	397.8	398.05	27356.0
2021-12-31 04:00:00	IWM	ETF	222.69	222.86	222.55	222.72	23072.0
2021-12-31 05:00:00	IWM	ETF	222.71	222.8	222.3	222.36	56755.0
2021-12-31 06:00:00	IWM	ETF	222.42	222.53	222.05	222.07	9870.0
2021-12-31 07:00:00	IWM	ETF	222.08	222.64	221.93	222.51	74120.0
2021-12-31 08:00:00	IWM	ETF	222.31	222.75	221.97	222.65	28057.0
2021-12-31 09:00:00	IWM	ETF	222.67	224.12	222.39	223.6	2850552.0
2021-12-31 10:00:00	IWM	ETF	223.65	224.03	222.55	223.06	2660927.0
2021-12-31 11:00:00	IWM	ETF	223.04	223.41	222.69	222.86	1163902.0
2021-12-31 12:00:00	IWM	ETF	222.87	223.37	222.495	223.345	1605389.0
2021-12-31 13:00:00	IWM	ETF	223.345	223.355	222.81	223.21	902212.0
2021-12-31 14:00:00	IWM	ETF	223.21	223.52	222.82	223.17	1491200.0
2021-12-31 15:00:00	IWM	ETF	223.18	223.57	222.47	222.5102	5362113.0
2021-12-31 16:00:00	IWM	ETF	222.52	223.279	222.44	222.56	2212266.0
2021-12-31 17:00:00	IWM	ETF	222.5	223.03	222.45	222.67	97925.0
2021-12-31 18:00:00	IWM	ETF	222.48	222.65	222.46	222.46	1945.0
2021-12-31 19:00:00	IWM	ETF	222.46	222.95	222.46	222.87	8849.0
2021-12-31 04:00:00	DIA	ETF	363.6	363.6	363.6	363.6	256.0
2021-12-31 05:00:00	DIA	ETF	363.7	363.71	363.5	363.5	400.0

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

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