PREVIEW / etf_1hour / 2021-09-15

all etf 1-hour files

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

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-15 04:00:00	SPY	ETF	444.61	445.32	444.61	445.15	35345.0
2021-09-15 05:00:00	SPY	ETF	445.14	445.41	445.03	445.3	8905.0
2021-09-15 06:00:00	SPY	ETF	445.33	445.4	444.58	444.58	24138.0
2021-09-15 07:00:00	SPY	ETF	444.73	444.76	444.12	444.47	149714.0
2021-09-15 08:00:00	SPY	ETF	444.7	445.07	443.74	444.74	358020.0
2021-09-15 09:00:00	SPY	ETF	444.73	445.39	443.44	445.05	8011196.0
2021-09-15 10:00:00	SPY	ETF	445.06	445.53	443.91	445.03	8567388.0
2021-09-15 11:00:00	SPY	ETF	445.02	445.57	444.745	445.379	5436071.0
2021-09-15 12:00:00	SPY	ETF	445.37	447.1	445.03	446.93	6483595.0
2021-09-15 13:00:00	SPY	ETF	446.94	447.93	446.92	447.3961	5388825.0
2021-09-15 14:00:00	SPY	ETF	447.39	447.69	447.155	447.27	5707453.0
2021-09-15 15:00:00	SPY	ETF	447.28	448.41	447.18	447.86	15398185.0
2021-09-15 16:00:00	SPY	ETF	447.86	448.32	447.68	448.22	2575076.0
2021-09-15 17:00:00	SPY	ETF	448.17	448.25	448.02	448.16	197065.0
2021-09-15 18:00:00	SPY	ETF	448.16	448.33	448.1	448.26	139789.0
2021-09-15 19:00:00	SPY	ETF	448.3	448.3	448.04	448.18	47871.0
2021-09-15 04:00:00	QQQ	ETF	375.85	376.31	375.85	376.24	12811.0
2021-09-15 05:00:00	QQQ	ETF	376.25	376.37	376.1	376.26	15021.0
2021-09-15 06:00:00	QQQ	ETF	376.26	376.32	375.85	375.96	10934.0
2021-09-15 07:00:00	QQQ	ETF	375.99	376.02	375.45	375.72	84532.0
2021-09-15 08:00:00	QQQ	ETF	375.7399	376.0	375.39	375.86	170709.0
2021-09-15 09:00:00	QQQ	ETF	375.89	376.4	373.93	374.54	5321904.0
2021-09-15 10:00:00	QQQ	ETF	374.5528	375.05	373.37	374.76	5783625.0
2021-09-15 11:00:00	QQQ	ETF	374.75	375.01	374.01	374.635	2687805.0
2021-09-15 12:00:00	QQQ	ETF	374.63	376.6745	374.461	376.55	3447376.0
2021-09-15 13:00:00	QQQ	ETF	376.57	377.265	376.45	376.915	2271763.0
2021-09-15 14:00:00	QQQ	ETF	376.91	377.6	376.85	377.48	1853289.0
2021-09-15 15:00:00	QQQ	ETF	377.49	378.41	377.39	378.01	4522415.0
2021-09-15 16:00:00	QQQ	ETF	378.01	378.3	373.9084	378.23	1302227.0
2021-09-15 17:00:00	QQQ	ETF	378.25	378.3	378.05	378.23	327855.0
2021-09-15 18:00:00	QQQ	ETF	378.37	378.4	377.97	378.16	137660.0
2021-09-15 19:00:00	QQQ	ETF	378.13	378.18	378.01	378.12	19498.0
2021-09-15 04:00:00	IWM	ETF	219.85	220.42	219.85	220.37	15026.0
2021-09-15 05:00:00	IWM	ETF	220.31	220.66	220.3	220.66	13166.0
2021-09-15 06:00:00	IWM	ETF	220.66	220.7	220.02	220.1	19962.0
2021-09-15 07:00:00	IWM	ETF	220.15	220.25	219.68	220.06	74052.0
2021-09-15 08:00:00	IWM	ETF	220.12	220.6604	219.41	220.13	198291.0
2021-09-15 09:00:00	IWM	ETF	220.18	221.17	219.46	220.82	3501874.0
2021-09-15 10:00:00	IWM	ETF	220.81	221.52	220.08	220.8	3448506.0
2021-09-15 11:00:00	IWM	ETF	220.79	221.78	220.44	221.67	2271553.0
2021-09-15 12:00:00	IWM	ETF	221.66	221.74	221.08	221.56	1617491.0
2021-09-15 13:00:00	IWM	ETF	221.57	222.24	221.33	221.69	1578885.0
2021-09-15 14:00:00	IWM	ETF	221.68	222.25	221.58	221.935	1674248.0
2021-09-15 15:00:00	IWM	ETF	221.95	222.74	221.87	222.4302	5392092.0
2021-09-15 16:00:00	IWM	ETF	222.44	222.45	221.99	222.08	2910070.0
2021-09-15 17:00:00	IWM	ETF	222.25	222.29	222.03	222.09	56128.0
2021-09-15 18:00:00	IWM	ETF	222.09	222.25	222.03	222.15	256561.0
2021-09-15 19:00:00	IWM	ETF	222.16	222.23	222.03	222.23	61895.0
2021-09-15 04:00:00	DIA	ETF	346.95	346.98	346.95	346.96	1000.0
2021-09-15 05:00:00	DIA	ETF	347.03	347.37	347.03	347.37	790.0

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

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