PREVIEW / etf_1hour / 2021-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-09.parquet
  size:    413 KB
  rows:    14,181

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-04-09 04:00:00	SPY	ETF	409.12	409.13	408.56	409.03	17889.0
2021-04-09 05:00:00	SPY	ETF	408.95	408.96	408.7	408.96	9514.0
2021-04-09 06:00:00	SPY	ETF	408.89	409.0	408.59	408.78	18777.0
2021-04-09 07:00:00	SPY	ETF	408.75	409.42	408.75	409.09	133610.0
2021-04-09 08:00:00	SPY	ETF	408.9701	409.4299	407.9	408.04	588611.0
2021-04-09 09:00:00	SPY	ETF	408.02	409.11	407.72	409.06	4659709.0
2021-04-09 10:00:00	SPY	ETF	409.07	409.24	408.42	408.6343	7687163.0
2021-04-09 11:00:00	SPY	ETF	408.635	409.47	408.565	409.38	4406545.0
2021-04-09 12:00:00	SPY	ETF	409.375	409.53	409.14	409.4681	3186626.0
2021-04-09 13:00:00	SPY	ETF	409.465	409.98	409.31	409.805	3775371.0
2021-04-09 14:00:00	SPY	ETF	409.805	409.95	409.59	409.71	3809820.0
2021-04-09 15:00:00	SPY	ETF	409.71	411.67	409.5	411.44	16917834.0
2021-04-09 16:00:00	SPY	ETF	411.44	411.59	410.59	411.49	3451225.0
2021-04-09 17:00:00	SPY	ETF	410.76	411.09	410.76	410.8199	145885.0
2021-04-09 18:00:00	SPY	ETF	410.81	410.9	410.81	410.86	19021.0
2021-04-09 19:00:00	SPY	ETF	410.85	410.9	410.68	410.68	22698.0
2021-04-09 04:00:00	QQQ	ETF	335.2	335.2	334.44	334.92	56920.0
2021-04-09 05:00:00	QQQ	ETF	334.85	334.89	334.41	334.69	31352.0
2021-04-09 06:00:00	QQQ	ETF	334.71	334.86	334.15	334.7	46958.0
2021-04-09 07:00:00	QQQ	ETF	334.67	335.28	334.52	334.6	206788.0
2021-04-09 08:00:00	QQQ	ETF	335.3	336.37	332.69	333.11	1072313.0
2021-04-09 09:00:00	QQQ	ETF	333.09	334.67	332.7	334.44	4828789.0
2021-04-09 10:00:00	QQQ	ETF	334.44	335.08	334.01	334.19	3949530.0
2021-04-09 11:00:00	QQQ	ETF	334.19	335.65	333.82	335.53	3288664.0
2021-04-09 12:00:00	QQQ	ETF	335.54	335.825	335.19	335.7	2219769.0
2021-04-09 13:00:00	QQQ	ETF	335.688	336.12	335.48	335.91	2428867.0
2021-04-09 14:00:00	QQQ	ETF	335.92	336.16	335.49	335.69	2079285.0
2021-04-09 15:00:00	QQQ	ETF	335.69	337.32	335.3	337.1	6585960.0
2021-04-09 16:00:00	QQQ	ETF	337.11	337.29	336.45	336.62	989981.0
2021-04-09 17:00:00	QQQ	ETF	336.67	337.11	336.5	336.6	55324.0
2021-04-09 18:00:00	QQQ	ETF	336.67	336.68	336.6	336.6	3587.0
2021-04-09 19:00:00	QQQ	ETF	336.64	336.68	336.44	336.44	22774.0
2021-04-09 04:00:00	IWM	ETF	223.24	223.24	222.51	222.9	10930.0
2021-04-09 05:00:00	IWM	ETF	222.87	223.1	222.87	223.0	5900.0
2021-04-09 06:00:00	IWM	ETF	223.11	223.17	222.9	223.12	17056.0
2021-04-09 07:00:00	IWM	ETF	223.15	223.94	223.15	223.6	81916.0
2021-04-09 08:00:00	IWM	ETF	223.5699	223.84	222.26	222.26	201066.0
2021-04-09 09:00:00	IWM	ETF	222.29	222.67	221.24	222.1209	2916546.0
2021-04-09 10:00:00	IWM	ETF	222.11	223.0	221.38	222.42	4302223.0
2021-04-09 11:00:00	IWM	ETF	222.4	222.83	221.92	222.3	1791122.0
2021-04-09 12:00:00	IWM	ETF	222.26	222.44	221.73	222.24	1324194.0
2021-04-09 13:00:00	IWM	ETF	222.23	222.29	221.58	221.89	1017826.0
2021-04-09 14:00:00	IWM	ETF	221.88	222.18	221.7	221.8701	1271106.0
2021-04-09 15:00:00	IWM	ETF	221.87	223.09	221.42	222.6	3643386.0
2021-04-09 16:00:00	IWM	ETF	222.59	222.98	222.42	222.66	1891463.0
2021-04-09 17:00:00	IWM	ETF	222.72	222.72	222.4	222.4	38534.0
2021-04-09 18:00:00	IWM	ETF	222.4	222.53	222.35	222.44	8650.0
2021-04-09 19:00:00	IWM	ETF	222.3	222.3	222.21	222.21	1524.0
2021-04-09 04:00:00	DIA	ETF	335.5	335.52	335.26	335.52	4099.0
2021-04-09 07:00:00	DIA	ETF	335.68	336.03	335.68	336.03	4800.0

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

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