PREVIEW / etf_1hour / 2021-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-24.parquet
  size:    409 KB
  rows:    14,371

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-24 04:00:00	SPY	ETF	442.69	442.69	441.01	442.14	69492.0
2021-09-24 05:00:00	SPY	ETF	442.07	442.13	441.18	441.24	56471.0
2021-09-24 06:00:00	SPY	ETF	441.21	442.15	441.15	441.51	111346.0
2021-09-24 07:00:00	SPY	ETF	441.5	441.78	440.95	441.02	357380.0
2021-09-24 08:00:00	SPY	ETF	441.3799	443.512	440.52	440.79	564315.0
2021-09-24 09:00:00	SPY	ETF	440.78	443.64	440.59	443.62	7065398.0
2021-09-24 10:00:00	SPY	ETF	443.63	443.91	442.21	442.66	7622189.0
2021-09-24 11:00:00	SPY	ETF	442.67	443.39	442.14	443.21	5804114.0
2021-09-24 12:00:00	SPY	ETF	443.21	443.67	442.95	443.4501	3247736.0
2021-09-24 13:00:00	SPY	ETF	443.47	443.56	442.79	442.8079	3136642.0
2021-09-24 14:00:00	SPY	ETF	442.81	443.97	442.79	443.96	3274864.0
2021-09-24 15:00:00	SPY	ETF	443.96	444.67	443.36	443.92	12354561.0
2021-09-24 16:00:00	SPY	ETF	443.93	444.15	443.8482	443.98	3395639.0
2021-09-24 17:00:00	SPY	ETF	443.89	444.27	443.89	444.2699	965567.0
2021-09-24 18:00:00	SPY	ETF	444.25	444.3	443.9	444.09	41666.0
2021-09-24 19:00:00	SPY	ETF	444.0	444.24	444.0	444.21	28368.0
2021-09-24 04:00:00	QQQ	ETF	372.23	372.23	370.75	371.62	67029.0
2021-09-24 05:00:00	QQQ	ETF	371.71	371.71	370.76	370.92	25705.0
2021-09-24 06:00:00	QQQ	ETF	370.88	371.59	370.88	370.89	144635.0
2021-09-24 07:00:00	QQQ	ETF	371.0	371.27	370.47	370.54	225771.0
2021-09-24 08:00:00	QQQ	ETF	371.15	372.95	369.95	370.24	358004.0
2021-09-24 09:00:00	QQQ	ETF	370.19	371.78	370.08	371.66	5343035.0
2021-09-24 10:00:00	QQQ	ETF	371.67	372.03	370.66	370.955	4492640.0
2021-09-24 11:00:00	QQQ	ETF	370.97	371.93	370.69	371.835	2965713.0
2021-09-24 12:00:00	QQQ	ETF	371.8392	372.75	371.6	372.59	1982818.0
2021-09-24 13:00:00	QQQ	ETF	372.6	372.85	372.0	372.01	1863999.0
2021-09-24 14:00:00	QQQ	ETF	372.015	373.01	371.96	372.99	2052488.0
2021-09-24 15:00:00	QQQ	ETF	373.0	373.76	372.4301	373.33	5392431.0
2021-09-24 16:00:00	QQQ	ETF	373.33	373.47	373.2	373.42	1952877.0
2021-09-24 17:00:00	QQQ	ETF	373.36	373.56	373.33	373.42	27098.0
2021-09-24 18:00:00	QQQ	ETF	373.49	373.54	373.36	373.44	4522.0
2021-09-24 19:00:00	QQQ	ETF	373.44	373.65	373.44	373.6399	13188.0
2021-09-24 04:00:00	IWM	ETF	224.48	224.48	223.0	223.5	313131.0
2021-09-24 05:00:00	IWM	ETF	223.58	223.58	223.09	223.1	8546.0
2021-09-24 06:00:00	IWM	ETF	222.94	223.5	222.94	223.12	15622.0
2021-09-24 07:00:00	IWM	ETF	223.24	223.45	222.8	222.89	73684.0
2021-09-24 08:00:00	IWM	ETF	223.23	224.15	222.54	222.7	157972.0
2021-09-24 09:00:00	IWM	ETF	222.65	223.49	221.84	223.29	3263842.0
2021-09-24 10:00:00	IWM	ETF	223.29	224.0583	223.01	223.84	4065063.0
2021-09-24 11:00:00	IWM	ETF	223.84	224.23	223.18	224.22	1692401.0
2021-09-24 12:00:00	IWM	ETF	224.2296	224.355	223.91	223.99	1349850.0
2021-09-24 13:00:00	IWM	ETF	223.99	224.04	223.21	223.2684	1032826.0
2021-09-24 14:00:00	IWM	ETF	223.26	223.735	223.02	223.715	1297310.0
2021-09-24 15:00:00	IWM	ETF	223.72	224.09	223.04	223.06	5270981.0
2021-09-24 16:00:00	IWM	ETF	223.05	223.34	223.05	223.17	1080541.0
2021-09-24 17:00:00	IWM	ETF	223.39	223.39	223.05	223.39	82186.0
2021-09-24 18:00:00	IWM	ETF	223.37	223.48	223.2	223.2	6939.0
2021-09-24 19:00:00	IWM	ETF	223.38	223.5	223.23	223.5	11583.0
2021-09-24 04:00:00	DIA	ETF	346.78	347.03	346.3	347.03	3835.0
2021-09-24 05:00:00	DIA	ETF	346.8	346.97	346.37	346.37	1284.0

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

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