PREVIEW / etf_1hour / 2021-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-07.parquet
  size:    412 KB
  rows:    14,543

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-07-07 04:00:00	SPY	ETF	433.27	433.69	432.9	433.22	16075.0
2021-07-07 05:00:00	SPY	ETF	433.2	433.66	433.2	433.52	10627.0
2021-07-07 06:00:00	SPY	ETF	433.44	433.7	433.28	433.7	26995.0
2021-07-07 07:00:00	SPY	ETF	433.64	433.74	433.45	433.66	484627.0
2021-07-07 08:00:00	SPY	ETF	433.6996	433.96	432.66	433.23	425904.0
2021-07-07 09:00:00	SPY	ETF	433.22	434.19	433.2	433.72	5545016.0
2021-07-07 10:00:00	SPY	ETF	433.74	433.8396	431.51	432.65	9873164.0
2021-07-07 11:00:00	SPY	ETF	432.64	434.16	432.285	433.785	6634457.0
2021-07-07 12:00:00	SPY	ETF	433.78	434.45	433.77	434.05	3853053.0
2021-07-07 13:00:00	SPY	ETF	434.05	434.2275	433.6119	433.88	3027654.0
2021-07-07 14:00:00	SPY	ETF	433.8896	434.75	433.74	434.48	6584447.0
2021-07-07 15:00:00	SPY	ETF	434.48	434.76	434.095	434.43	10490526.0
2021-07-07 16:00:00	SPY	ETF	434.42	434.67	434.21	434.65	3011411.0
2021-07-07 17:00:00	SPY	ETF	434.59	434.63	434.55	434.62	41723.0
2021-07-07 18:00:00	SPY	ETF	434.62	434.68	434.46	434.6	87483.0
2021-07-07 19:00:00	SPY	ETF	434.61	434.61	434.44	434.48	40595.0
2021-07-07 04:00:00	QQQ	ETF	361.67	362.17	361.33	361.48	110411.0
2021-07-07 05:00:00	QQQ	ETF	361.52	361.92	361.49	361.68	18429.0
2021-07-07 06:00:00	QQQ	ETF	361.56	362.1	361.5	361.86	42019.0
2021-07-07 07:00:00	QQQ	ETF	361.87	362.36	361.82	362.15	124440.0
2021-07-07 08:00:00	QQQ	ETF	361.89	362.46	360.25	362.22	251447.0
2021-07-07 09:00:00	QQQ	ETF	362.25	362.76	361.16	361.61	5626554.0
2021-07-07 10:00:00	QQQ	ETF	361.605	361.8618	358.94	360.1598	7544859.0
2021-07-07 11:00:00	QQQ	ETF	360.15	361.435	359.2599	361.06	4116871.0
2021-07-07 12:00:00	QQQ	ETF	361.06	361.4	360.36	360.74	2164378.0
2021-07-07 13:00:00	QQQ	ETF	360.74	360.85	360.05	360.58	1877582.0
2021-07-07 14:00:00	QQQ	ETF	360.62	361.41	360.36	361.12	3021844.0
2021-07-07 15:00:00	QQQ	ETF	361.11	361.29	360.55	360.83	3107615.0
2021-07-07 16:00:00	QQQ	ETF	360.82	361.071	360.64	361.01	1047929.0
2021-07-07 17:00:00	QQQ	ETF	360.88	361.05	360.88	361.0	23184.0
2021-07-07 18:00:00	QQQ	ETF	360.95	361.04	360.87	361.032	23980.0
2021-07-07 19:00:00	QQQ	ETF	361.01	361.08	360.9	360.99	37292.0
2021-07-07 04:00:00	IWM	ETF	226.09	226.12	225.91	226.0	9608.0
2021-07-07 05:00:00	IWM	ETF	226.02	226.4	226.02	226.38	8400.0
2021-07-07 06:00:00	IWM	ETF	226.18	226.18	225.9	226.03	4260.0
2021-07-07 07:00:00	IWM	ETF	226.09	226.09	225.65	226.01	92495.0
2021-07-07 08:00:00	IWM	ETF	225.8	226.32	224.96	224.99	291363.0
2021-07-07 09:00:00	IWM	ETF	225.07	226.67	224.7	224.8	2533003.0
2021-07-07 10:00:00	IWM	ETF	224.8043	224.81	221.8	222.735	5382310.0
2021-07-07 11:00:00	IWM	ETF	222.74	224.815	222.68	224.6	3534431.0
2021-07-07 12:00:00	IWM	ETF	224.59	225.25	224.41	224.53	2064587.0
2021-07-07 13:00:00	IWM	ETF	224.525	224.6	223.61	223.64	1868542.0
2021-07-07 14:00:00	IWM	ETF	223.65	224.55	222.54	223.4114	2632938.0
2021-07-07 15:00:00	IWM	ETF	223.425	224.27	223.365	223.76	3061598.0
2021-07-07 16:00:00	IWM	ETF	223.76	224.13	222.9833	224.05	928256.0
2021-07-07 17:00:00	IWM	ETF	224.08	224.09	224.02	224.02	2568.0
2021-07-07 18:00:00	IWM	ETF	224.09	224.18	224.05	224.15	118282.0
2021-07-07 19:00:00	IWM	ETF	224.15	224.15	223.97	223.99	16748.0
2021-07-07 04:00:00	DIA	ETF	345.78	345.87	345.77	345.87	800.0
2021-07-07 05:00:00	DIA	ETF	346.1	346.26	346.03	346.03	1900.0

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

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