PREVIEW / etf_1hour / 2021-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-16.parquet
  size:    415 KB
  rows:    14,411

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-09-16 04:00:00	SPY	ETF	447.97	448.03	447.62	447.64	66349.0
2021-09-16 05:00:00	SPY	ETF	447.63	447.68	447.11	447.2	33340.0
2021-09-16 06:00:00	SPY	ETF	447.25	447.38	447.12	447.37	179691.0
2021-09-16 07:00:00	SPY	ETF	447.38	447.6	446.88	446.95	190172.0
2021-09-16 08:00:00	SPY	ETF	447.37	448.215	446.35	447.52	894598.0
2021-09-16 09:00:00	SPY	ETF	447.61	448.27	445.82	446.14	7230692.0
2021-09-16 10:00:00	SPY	ETF	446.13	446.135	444.02	444.58	10897494.0
2021-09-16 11:00:00	SPY	ETF	444.58	445.32	444.37	445.3	5998327.0
2021-09-16 12:00:00	SPY	ETF	445.305	446.4571	445.005	445.99	4069456.0
2021-09-16 13:00:00	SPY	ETF	445.98	446.76	445.42	446.745	4393321.0
2021-09-16 14:00:00	SPY	ETF	446.75	447.55	446.48	447.46	5459540.0
2021-09-16 15:00:00	SPY	ETF	447.46	448.36	446.99	447.15	13735133.0
2021-09-16 16:00:00	SPY	ETF	447.15	447.21	446.69	446.75	2069416.0
2021-09-16 17:00:00	SPY	ETF	446.74	446.85	446.63	446.73	43194.0
2021-09-16 18:00:00	SPY	ETF	446.73	447.17	446.64	446.78	99971.0
2021-09-16 19:00:00	SPY	ETF	446.79	446.81	446.3	446.51	64312.0
2021-09-16 04:00:00	QQQ	ETF	378.15	378.15	377.37	377.43	102899.0
2021-09-16 05:00:00	QQQ	ETF	377.44	377.5	376.94	377.04	22007.0
2021-09-16 06:00:00	QQQ	ETF	377.02	377.3	377.02	377.28	16019.0
2021-09-16 07:00:00	QQQ	ETF	377.28	377.47	376.84	376.9	65786.0
2021-09-16 08:00:00	QQQ	ETF	377.2901	378.333	376.45	377.07	227887.0
2021-09-16 09:00:00	QQQ	ETF	377.15	378.05	375.37	375.94	3832917.0
2021-09-16 10:00:00	QQQ	ETF	375.89	376.0599	374.81	375.37	4669492.0
2021-09-16 11:00:00	QQQ	ETF	375.37	375.8025	374.695	375.79	2745800.0
2021-09-16 12:00:00	QQQ	ETF	375.79	376.63	375.68	376.4525	2071163.0
2021-09-16 13:00:00	QQQ	ETF	376.45	377.485	376.11	377.4	2062787.0
2021-09-16 14:00:00	QQQ	ETF	377.41	378.09	377.181	377.9609	2179337.0
2021-09-16 15:00:00	QQQ	ETF	377.97	378.9	377.9	378.34	6198834.0
2021-09-16 16:00:00	QQQ	ETF	378.33	378.34	377.87	378.1	763954.0
2021-09-16 17:00:00	QQQ	ETF	378.0	378.15	377.95	378.05	14483.0
2021-09-16 18:00:00	QQQ	ETF	378.04	378.09	377.89	378.0	10057.0
2021-09-16 19:00:00	QQQ	ETF	377.96	378.04	377.48	377.6401	26471.0
2021-09-16 04:00:00	IWM	ETF	222.01	222.31	222.01	222.1	28938.0
2021-09-16 05:00:00	IWM	ETF	222.11	222.11	221.73	221.77	12631.0
2021-09-16 06:00:00	IWM	ETF	221.76	221.88	221.48	221.73	138878.0
2021-09-16 07:00:00	IWM	ETF	221.78	221.99	221.52	221.61	19704.0
2021-09-16 08:00:00	IWM	ETF	221.8201	222.54	220.87	222.37	158641.0
2021-09-16 09:00:00	IWM	ETF	222.48	222.74	220.9	221.37	2569869.0
2021-09-16 10:00:00	IWM	ETF	221.36	221.49	220.26	220.54	2938404.0
2021-09-16 11:00:00	IWM	ETF	220.54	221.485	220.405	221.48	1909391.0
2021-09-16 12:00:00	IWM	ETF	221.485	222.08	221.3805	221.79	1643371.0
2021-09-16 13:00:00	IWM	ETF	221.78	222.56	221.55	222.43	1716343.0
2021-09-16 14:00:00	IWM	ETF	222.43	222.92	222.27	222.885	1760264.0
2021-09-16 15:00:00	IWM	ETF	222.89	223.34	222.14	222.18	4018248.0
2021-09-16 16:00:00	IWM	ETF	222.19	222.27	221.1469	222.13	655752.0
2021-09-16 17:00:00	IWM	ETF	222.15	222.19	221.85	221.96	277489.0
2021-09-16 18:00:00	IWM	ETF	222.01	222.19	222.01	222.09	26345.0
2021-09-16 19:00:00	IWM	ETF	222.12	222.13	221.71	221.84	12231.0
2021-09-16 04:00:00	DIA	ETF	348.82	348.82	348.81	348.81	1400.0
2021-09-16 05:00:00	DIA	ETF	348.68	348.68	348.41	348.41	2000.0

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

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