PREVIEW / etf_1hour / 2021-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-25.parquet
  size:    409 KB
  rows:    14,149

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-08-25 04:00:00	SPY	ETF	447.98	448.42	447.84	448.18	5528.0
2021-08-25 05:00:00	SPY	ETF	448.12	448.28	448.09	448.14	5845.0
2021-08-25 06:00:00	SPY	ETF	448.15	448.15	448.0	448.14	7945.0
2021-08-25 07:00:00	SPY	ETF	448.12	448.13	447.48	447.85	60299.0
2021-08-25 08:00:00	SPY	ETF	447.84	448.305	447.53	448.17	117619.0
2021-08-25 09:00:00	SPY	ETF	448.17	448.34	447.77	448.3	3338043.0
2021-08-25 10:00:00	SPY	ETF	448.315	448.54	448.07	448.42	3366365.0
2021-08-25 11:00:00	SPY	ETF	448.42	449.215	448.38	449.085	2980838.0
2021-08-25 12:00:00	SPY	ETF	449.08	449.37	449.035	449.2699	1969837.0
2021-08-25 13:00:00	SPY	ETF	449.26	449.2721	449.03	449.06	2074450.0
2021-08-25 14:00:00	SPY	ETF	449.07	449.295	448.87	449.109	3274348.0
2021-08-25 15:00:00	SPY	ETF	449.1	449.457	448.78	448.88	11421425.0
2021-08-25 16:00:00	SPY	ETF	448.88	449.07	448.81	449.0	2710721.0
2021-08-25 17:00:00	SPY	ETF	449.0	449.05	448.85	449.05	261745.0
2021-08-25 18:00:00	SPY	ETF	449.06	449.06	448.9	448.97	46611.0
2021-08-25 19:00:00	SPY	ETF	448.95	449.01	448.88	448.9	33077.0
2021-08-25 04:00:00	QQQ	ETF	374.85	375.12	374.59	374.93	19878.0
2021-08-25 05:00:00	QQQ	ETF	374.9	374.97	374.7	374.7	10951.0
2021-08-25 06:00:00	QQQ	ETF	374.75	374.83	374.41	374.47	32531.0
2021-08-25 07:00:00	QQQ	ETF	374.47	374.47	373.846	374.25	137839.0
2021-08-25 08:00:00	QQQ	ETF	374.34	374.75	373.85	374.63	148327.0
2021-08-25 09:00:00	QQQ	ETF	374.62	375.39	374.51	374.91	2670974.0
2021-08-25 10:00:00	QQQ	ETF	374.93	375.13	373.855	374.14	3617242.0
2021-08-25 11:00:00	QQQ	ETF	374.15	374.65	374.1	374.345	1613210.0
2021-08-25 12:00:00	QQQ	ETF	374.35	374.77	373.98	374.735	1519497.0
2021-08-25 13:00:00	QQQ	ETF	374.75	374.75	374.17	374.31	1067640.0
2021-08-25 14:00:00	QQQ	ETF	374.32	374.73	374.195	374.5801	1633126.0
2021-08-25 15:00:00	QQQ	ETF	374.58	375.07	374.4	374.57	3429707.0
2021-08-25 16:00:00	QQQ	ETF	374.58	374.8	374.5147	374.65	663285.0
2021-08-25 17:00:00	QQQ	ETF	374.73	374.73	374.63	374.73	3162.0
2021-08-25 18:00:00	QQQ	ETF	374.7	374.7	374.55	374.67	15931.0
2021-08-25 19:00:00	QQQ	ETF	374.66	374.66	374.54	374.56	29322.0
2021-08-25 04:00:00	IWM	ETF	221.52	222.0	221.46	221.65	11384.0
2021-08-25 05:00:00	IWM	ETF	221.6	221.94	221.6	221.93	3721.0
2021-08-25 06:00:00	IWM	ETF	222.0	222.11	221.9	222.04	3407.0
2021-08-25 07:00:00	IWM	ETF	222.0	222.02	221.4	221.73	34168.0
2021-08-25 08:00:00	IWM	ETF	222.03	222.03	221.34	221.96	45489.0
2021-08-25 09:00:00	IWM	ETF	221.94	222.43	220.85	222.4077	1910736.0
2021-08-25 10:00:00	IWM	ETF	222.41	223.05	221.93	222.91	2187935.0
2021-08-25 11:00:00	IWM	ETF	222.91	223.53	222.65	223.52	1893370.0
2021-08-25 12:00:00	IWM	ETF	223.51	223.72	223.32	223.5086	1316695.0
2021-08-25 13:00:00	IWM	ETF	223.51	223.9699	223.35	223.42	1340973.0
2021-08-25 14:00:00	IWM	ETF	223.42	223.91	223.37	223.64	1359646.0
2021-08-25 15:00:00	IWM	ETF	223.6417	223.645	222.5	222.59	5024905.0
2021-08-25 16:00:00	IWM	ETF	222.6	222.67	222.5	222.64	1271126.0
2021-08-25 17:00:00	IWM	ETF	222.62	222.69	222.54	222.68	40985.0
2021-08-25 18:00:00	IWM	ETF	222.56	222.68	222.54	222.56	7986.0
2021-08-25 19:00:00	IWM	ETF	222.59	222.61	222.49	222.49	17070.0
2021-08-25 04:00:00	DIA	ETF	353.58	353.97	353.58	353.82	1422.0
2021-08-25 06:00:00	DIA	ETF	353.89	353.89	353.89	353.89	100.0

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

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