PREVIEW / etf_1hour / 2021-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-08.parquet
  size:    413 KB
  rows:    14,426

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-08 04:00:00	SPY	ETF	438.66	438.83	437.88	437.97	52005.0
2021-10-08 05:00:00	SPY	ETF	437.87	438.61	437.8	438.61	31957.0
2021-10-08 06:00:00	SPY	ETF	438.57	439.05	438.55	438.66	35053.0
2021-10-08 07:00:00	SPY	ETF	438.84	439.23	438.84	438.98	186705.0
2021-10-08 08:00:00	SPY	ETF	438.99	440.34	437.84	439.58	2360815.0
2021-10-08 09:00:00	SPY	ETF	439.69	440.09	437.97	438.37	8293253.0
2021-10-08 10:00:00	SPY	ETF	438.37	439.7	438.0401	438.74	8553581.0
2021-10-08 11:00:00	SPY	ETF	438.74	439.41	438.21	438.345	4962891.0
2021-10-08 12:00:00	SPY	ETF	438.35	438.67	437.78	438.2	5115840.0
2021-10-08 13:00:00	SPY	ETF	438.2	438.4199	437.19	438.06	5126380.0
2021-10-08 14:00:00	SPY	ETF	438.05	439.31	437.975	438.73	5032914.0
2021-10-08 15:00:00	SPY	ETF	438.73	439.14	437.48	437.83	12808492.0
2021-10-08 16:00:00	SPY	ETF	437.83	438.5268	437.23	437.6	3050018.0
2021-10-08 17:00:00	SPY	ETF	437.6	438.5775	434.8734	437.36	1156275.0
2021-10-08 18:00:00	SPY	ETF	437.33	437.45	437.22	437.25	32097.0
2021-10-08 19:00:00	SPY	ETF	437.32	437.39	437.25	437.35	23530.0
2021-10-08 04:00:00	QQQ	ETF	362.33	362.56	361.84	361.94	72303.0
2021-10-08 05:00:00	QQQ	ETF	361.94	362.75	361.85	362.74	48019.0
2021-10-08 06:00:00	QQQ	ETF	362.76	362.93	362.46	362.68	31010.0
2021-10-08 07:00:00	QQQ	ETF	362.7	363.41	362.7	363.28	151281.0
2021-10-08 08:00:00	QQQ	ETF	362.9999	365.6	361.99	364.92	1764616.0
2021-10-08 09:00:00	QQQ	ETF	364.92	365.05	361.95	362.04	5920139.0
2021-10-08 10:00:00	QQQ	ETF	362.01	363.4999	361.22	362.08	5651250.0
2021-10-08 11:00:00	QQQ	ETF	362.08	362.67	361.05	361.4106	4062858.0
2021-10-08 12:00:00	QQQ	ETF	361.44	362.24	361.1513	361.6199	3072239.0
2021-10-08 13:00:00	QQQ	ETF	361.62	361.8406	360.61	361.5	3263259.0
2021-10-08 14:00:00	QQQ	ETF	361.485	362.54	361.42	362.0201	2884285.0
2021-10-08 15:00:00	QQQ	ETF	362.02	362.31	360.71	361.1	5383932.0
2021-10-08 16:00:00	QQQ	ETF	361.11	361.16	360.65	360.94	2738815.0
2021-10-08 17:00:00	QQQ	ETF	360.98	361.02	360.89	360.9	14056.0
2021-10-08 18:00:00	QQQ	ETF	360.82	360.94	360.82	360.94	3183.0
2021-10-08 19:00:00	QQQ	ETF	360.86	360.89	360.81	360.85	4331.0
2021-10-08 04:00:00	IWM	ETF	223.83	223.96	223.3	223.3	15009.0
2021-10-08 05:00:00	IWM	ETF	223.34	223.56	223.15	223.56	6098.0
2021-10-08 06:00:00	IWM	ETF	223.66	224.21	223.66	223.91	11749.0
2021-10-08 07:00:00	IWM	ETF	223.87	224.34	223.82	223.96	31366.0
2021-10-08 08:00:00	IWM	ETF	223.8996	224.3	222.15	223.06	629490.0
2021-10-08 09:00:00	IWM	ETF	223.12	223.83	222.275	223.052	2599000.0
2021-10-08 10:00:00	IWM	ETF	223.04	224.11	222.71	223.55	2322170.0
2021-10-08 11:00:00	IWM	ETF	223.56	223.64	222.4	222.47	1125779.0
2021-10-08 12:00:00	IWM	ETF	222.47	222.668	221.835	222.34	1350476.0
2021-10-08 13:00:00	IWM	ETF	222.34	222.58	221.625	222.105	1229284.0
2021-10-08 14:00:00	IWM	ETF	222.1	222.705	222.08	222.39	1164085.0
2021-10-08 15:00:00	IWM	ETF	222.39	222.55	221.5	221.6	3157041.0
2021-10-08 16:00:00	IWM	ETF	221.6	222.4814	221.39	221.7	766508.0
2021-10-08 17:00:00	IWM	ETF	221.6	221.7	221.51	221.6	18333.0
2021-10-08 18:00:00	IWM	ETF	221.5	221.68	221.45	221.48	3449.0
2021-10-08 19:00:00	IWM	ETF	221.48	221.7	221.01	221.65	11276.0
2021-10-08 04:00:00	DIA	ETF	347.31	347.42	347.31	347.35	705.0
2021-10-08 05:00:00	DIA	ETF	347.25	347.5	347.25	347.5	1283.0

> showing 50 of 14,426 rows — these rows as CSV

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