PREVIEW / etf_1hour / 2021-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-27.parquet
  size:    411 KB
  rows:    14,262

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-27 04:00:00	SPY	ETF	447.6	447.82	447.5	447.66	21384.0
2021-08-27 05:00:00	SPY	ETF	447.54	447.83	447.5	447.82	18632.0
2021-08-27 06:00:00	SPY	ETF	447.74	447.83	447.54	447.68	57222.0
2021-08-27 07:00:00	SPY	ETF	447.62	447.68	447.05	447.31	224086.0
2021-08-27 08:00:00	SPY	ETF	447.5899	447.71	446.594	447.57	282840.0
2021-08-27 09:00:00	SPY	ETF	447.57	448.0196	447.06	447.79	4792913.0
2021-08-27 10:00:00	SPY	ETF	447.79	449.86	447.11	449.63	12311795.0
2021-08-27 11:00:00	SPY	ETF	449.64	449.98	449.235	449.88	4278721.0
2021-08-27 12:00:00	SPY	ETF	449.89	450.185	449.68	450.18	3458724.0
2021-08-27 13:00:00	SPY	ETF	450.175	450.46	450.13	450.35	3836220.0
2021-08-27 14:00:00	SPY	ETF	450.35	450.355	449.99	450.18	3515300.0
2021-08-27 15:00:00	SPY	ETF	450.18	450.65	450.02	450.18	14200132.0
2021-08-27 16:00:00	SPY	ETF	450.19	450.44	450.0	450.41	5242884.0
2021-08-27 17:00:00	SPY	ETF	450.38	450.39	450.17	450.28	43758.0
2021-08-27 18:00:00	SPY	ETF	450.28	450.41	450.25	450.38	23093.0
2021-08-27 19:00:00	SPY	ETF	450.38	450.46	450.37	450.39	19123.0
2021-08-27 04:00:00	QQQ	ETF	373.05	373.75	373.05	373.65	18413.0
2021-08-27 05:00:00	QQQ	ETF	373.58	373.73	373.47	373.71	13482.0
2021-08-27 06:00:00	QQQ	ETF	373.69	373.8	373.6	373.69	11298.0
2021-08-27 07:00:00	QQQ	ETF	373.69	373.73	373.28	373.42	48588.0
2021-08-27 08:00:00	QQQ	ETF	373.7496	373.83	372.699	373.72	106181.0
2021-08-27 09:00:00	QQQ	ETF	373.73	373.8289	372.66	373.21	2915547.0
2021-08-27 10:00:00	QQQ	ETF	373.22	376.15	372.57	375.42	7211025.0
2021-08-27 11:00:00	QQQ	ETF	375.44	375.89	375.005	375.7999	2113320.0
2021-08-27 12:00:00	QQQ	ETF	375.805	375.97	375.5405	375.86	1232120.0
2021-08-27 13:00:00	QQQ	ETF	375.87	376.39	375.84	376.28	1586180.0
2021-08-27 14:00:00	QQQ	ETF	376.29	376.33	375.92	376.27	1434695.0
2021-08-27 15:00:00	QQQ	ETF	376.27	376.56	376.02	376.09	4639030.0
2021-08-27 16:00:00	QQQ	ETF	376.07	376.28	375.86	376.13	763009.0
2021-08-27 17:00:00	QQQ	ETF	375.93	376.15	375.93	376.1	17051.0
2021-08-27 18:00:00	QQQ	ETF	376.1	376.12	376.05	376.07	5927.0
2021-08-27 19:00:00	QQQ	ETF	376.15	376.19	376.07	376.07	7263.0
2021-08-27 04:00:00	IWM	ETF	221.18	221.26	220.96	221.06	3725.0
2021-08-27 05:00:00	IWM	ETF	220.97	221.11	220.9	221.01	25606.0
2021-08-27 06:00:00	IWM	ETF	221.07	221.11	220.85	220.9	10661.0
2021-08-27 07:00:00	IWM	ETF	220.86	220.99	220.61	220.77	95667.0
2021-08-27 08:00:00	IWM	ETF	220.95	221.1	220.56	220.81	144450.0
2021-08-27 09:00:00	IWM	ETF	220.81	222.77	220.57	222.43	2557782.0
2021-08-27 10:00:00	IWM	ETF	222.45	225.33	222.05	225.2	5936559.0
2021-08-27 11:00:00	IWM	ETF	225.21	226.11	225.1	226.02	5270923.0
2021-08-27 12:00:00	IWM	ETF	226.03	226.49	226.03	226.16	2701367.0
2021-08-27 13:00:00	IWM	ETF	226.17	226.7	226.03	226.6	2419694.0
2021-08-27 14:00:00	IWM	ETF	226.61	226.78	226.345	226.75	1593339.0
2021-08-27 15:00:00	IWM	ETF	226.74	227.025	226.12	226.43	4503423.0
2021-08-27 16:00:00	IWM	ETF	226.41	226.77	226.34	226.75	1493541.0
2021-08-27 17:00:00	IWM	ETF	226.8	226.97	226.41	226.73	371022.0
2021-08-27 18:00:00	IWM	ETF	226.65	226.65	226.61	226.63	1622.0
2021-08-27 19:00:00	IWM	ETF	226.63	226.82	225.39	226.71	12510.0
2021-08-27 04:00:00	DIA	ETF	353.24	353.28	353.12	353.13	2000.0
2021-08-27 05:00:00	DIA	ETF	353.11	353.11	353.11	353.11	200.0

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

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