PREVIEW / etf_1hour / 2021-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-06.parquet
  size:    425 KB
  rows:    14,688

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-06 04:00:00	SPY	ETF	405.5	406.01	405.0	405.78	23977.0
2021-04-06 05:00:00	SPY	ETF	405.54	405.7	405.41	405.53	10335.0
2021-04-06 06:00:00	SPY	ETF	405.63	405.73	405.26	405.47	38795.0
2021-04-06 07:00:00	SPY	ETF	405.52	405.91	405.47	405.91	159935.0
2021-04-06 08:00:00	SPY	ETF	405.62	406.24	405.2	405.68	389682.0
2021-04-06 09:00:00	SPY	ETF	405.72	406.89	405.51	406.77	5539098.0
2021-04-06 10:00:00	SPY	ETF	406.77	407.1999	406.55	406.82	5871406.0
2021-04-06 11:00:00	SPY	ETF	406.81	407.24	406.51	407.17	3596429.0
2021-04-06 12:00:00	SPY	ETF	407.18	407.21	406.65	406.82	4531520.0
2021-04-06 13:00:00	SPY	ETF	406.81	406.85	405.87	406.63	4802683.0
2021-04-06 14:00:00	SPY	ETF	406.635	406.83	406.29	406.58	4991845.0
2021-04-06 15:00:00	SPY	ETF	406.58	406.69	405.4	406.06	13581205.0
2021-04-06 16:00:00	SPY	ETF	406.06	406.23	405.89	406.22	4279968.0
2021-04-06 17:00:00	SPY	ETF	406.23	406.35	406.15	406.26	95126.0
2021-04-06 18:00:00	SPY	ETF	406.28	406.58	406.12	406.49	53393.0
2021-04-06 19:00:00	SPY	ETF	406.44	406.77	406.39	406.73	195007.0
2021-04-06 04:00:00	QQQ	ETF	330.07	330.69	329.69	330.4	65734.0
2021-04-06 05:00:00	QQQ	ETF	330.33	330.46	330.09	330.26	58968.0
2021-04-06 06:00:00	QQQ	ETF	330.34	330.54	329.93	330.22	34633.0
2021-04-06 07:00:00	QQQ	ETF	330.25	330.98	330.11	330.92	201204.0
2021-04-06 08:00:00	QQQ	ETF	330.1996	331.649	329.78	331.2	286428.0
2021-04-06 09:00:00	QQQ	ETF	331.3	331.44	330.02	331.41	3881650.0
2021-04-06 10:00:00	QQQ	ETF	331.44	331.9599	330.65	331.66	4426698.0
2021-04-06 11:00:00	QQQ	ETF	331.66	332.83	331.36	332.76	3106071.0
2021-04-06 12:00:00	QQQ	ETF	332.765	332.785	331.7701	331.8808	2322159.0
2021-04-06 13:00:00	QQQ	ETF	331.865	331.9438	330.18	331.305	3067065.0
2021-04-06 14:00:00	QQQ	ETF	331.33	331.905	331.11	331.65	2326851.0
2021-04-06 15:00:00	QQQ	ETF	331.64	331.78	330.16	330.78	5871961.0
2021-04-06 16:00:00	QQQ	ETF	330.8	331.09	330.76	331.08	554450.0
2021-04-06 17:00:00	QQQ	ETF	331.0	331.1	330.84	331.05	26415.0
2021-04-06 18:00:00	QQQ	ETF	331.02	331.35	330.9	331.23	52761.0
2021-04-06 19:00:00	QQQ	ETF	331.25	331.38	331.22	331.34	56130.0
2021-04-06 04:00:00	IWM	ETF	223.78	224.11	223.34	224.11	10341.0
2021-04-06 05:00:00	IWM	ETF	223.89	223.91	223.74	223.74	600.0
2021-04-06 06:00:00	IWM	ETF	223.51	223.6	223.17	223.3	19375.0
2021-04-06 07:00:00	IWM	ETF	223.39	224.43	223.36	224.42	75255.0
2021-04-06 08:00:00	IWM	ETF	224.0099	225.009	223.2496	224.63	83376.0
2021-04-06 09:00:00	IWM	ETF	224.68	226.27	224.57	226.23	2230804.0
2021-04-06 10:00:00	IWM	ETF	226.24	226.69	225.61	225.95	2519835.0
2021-04-06 11:00:00	IWM	ETF	225.94	226.3	225.13	225.64	2040948.0
2021-04-06 12:00:00	IWM	ETF	225.62	225.968	225.29	225.88	1979708.0
2021-04-06 13:00:00	IWM	ETF	225.88	225.98	224.92	225.58	1561738.0
2021-04-06 14:00:00	IWM	ETF	225.59	225.9	224.7401	224.83	2583575.0
2021-04-06 15:00:00	IWM	ETF	224.82	224.92	223.84	224.325	4907132.0
2021-04-06 16:00:00	IWM	ETF	224.31	224.69	224.28	224.67	935043.0
2021-04-06 17:00:00	IWM	ETF	224.52	224.97	224.51	224.72	95585.0
2021-04-06 18:00:00	IWM	ETF	224.8	224.89	224.56	224.85	69410.0
2021-04-06 19:00:00	IWM	ETF	224.79	225.0	224.72	225.0	24504.0
2021-04-06 04:00:00	DIA	ETF	334.89	335.2	334.74	335.2	1212.0
2021-04-06 06:00:00	DIA	ETF	334.81	334.81	334.81	334.81	200.0

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

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