PREVIEW / etf_1hour / 2021-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-10.parquet
  size:    417 KB
  rows:    14,479

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-10 04:00:00	SPY	ETF	450.38	451.06	449.86	450.92	50445.0
2021-09-10 05:00:00	SPY	ETF	450.75	450.76	450.52	450.52	17773.0
2021-09-10 06:00:00	SPY	ETF	450.53	450.73	450.53	450.73	35111.0
2021-09-10 07:00:00	SPY	ETF	450.74	450.89	450.65	450.82	150178.0
2021-09-10 08:00:00	SPY	ETF	450.6799	451.0	450.0	450.8	241757.0
2021-09-10 09:00:00	SPY	ETF	450.81	451.49	449.49	449.7	6951920.0
2021-09-10 10:00:00	SPY	ETF	449.71	449.71	447.41	448.21	12417570.0
2021-09-10 11:00:00	SPY	ETF	448.2	448.36	447.34	447.915	7216965.0
2021-09-10 12:00:00	SPY	ETF	447.915	449.315	447.72	449.115	4106192.0
2021-09-10 13:00:00	SPY	ETF	449.12	451.0196	448.42	448.635	3538559.0
2021-09-10 14:00:00	SPY	ETF	448.64	448.77	447.83	447.905	3310292.0
2021-09-10 15:00:00	SPY	ETF	447.9	447.92	445.31	445.5002	24424342.0
2021-09-10 16:00:00	SPY	ETF	445.52	446.08	445.37	445.73	5599319.0
2021-09-10 17:00:00	SPY	ETF	445.94	445.94	445.44	445.48	186563.0
2021-09-10 18:00:00	SPY	ETF	445.49	445.5	445.26	445.29	54604.0
2021-09-10 19:00:00	SPY	ETF	445.29	445.55	445.23	445.3399	43632.0
2021-09-10 04:00:00	QQQ	ETF	380.0	380.89	380.0	380.74	34942.0
2021-09-10 05:00:00	QQQ	ETF	380.78	380.78	380.56	380.56	13727.0
2021-09-10 06:00:00	QQQ	ETF	380.55	380.88	380.55	380.86	54621.0
2021-09-10 07:00:00	QQQ	ETF	380.86	381.09	380.83	381.0	109289.0
2021-09-10 08:00:00	QQQ	ETF	380.8299	381.23	380.15	380.92	221031.0
2021-09-10 09:00:00	QQQ	ETF	380.93	381.97	380.855	381.67	3125738.0
2021-09-10 10:00:00	QQQ	ETF	381.68	381.71	379.33	380.19	5610251.0
2021-09-10 11:00:00	QQQ	ETF	380.19	380.29	378.57	378.939	6840832.0
2021-09-10 12:00:00	QQQ	ETF	378.97	380.34	378.8	380.07	2100467.0
2021-09-10 13:00:00	QQQ	ETF	380.09	380.48	379.6	379.73	1900425.0
2021-09-10 14:00:00	QQQ	ETF	379.73	379.84	378.7299	378.895	1939621.0
2021-09-10 15:00:00	QQQ	ETF	378.89	378.92	376.245	376.51	7820352.0
2021-09-10 16:00:00	QQQ	ETF	376.52	376.82	376.49	376.54	865485.0
2021-09-10 17:00:00	QQQ	ETF	376.55	376.78	376.44	376.59	187930.0
2021-09-10 18:00:00	QQQ	ETF	376.59	376.6	376.41	376.42	6989.0
2021-09-10 19:00:00	QQQ	ETF	376.41	376.45	376.2	376.2	16511.0
2021-09-10 04:00:00	IWM	ETF	225.41	225.89	225.4	225.78	82286.0
2021-09-10 05:00:00	IWM	ETF	225.74	225.74	225.46	225.59	70877.0
2021-09-10 06:00:00	IWM	ETF	225.5	225.52	225.31	225.4	25229.0
2021-09-10 07:00:00	IWM	ETF	225.36	225.61	225.16	225.35	74253.0
2021-09-10 08:00:00	IWM	ETF	225.32	225.58	224.33	224.96	125921.0
2021-09-10 09:00:00	IWM	ETF	224.97	225.3	223.85	223.95	2071946.0
2021-09-10 10:00:00	IWM	ETF	223.98	224.055	222.27	222.97	4454346.0
2021-09-10 11:00:00	IWM	ETF	222.97	223.83	222.62	223.72	2651879.0
2021-09-10 12:00:00	IWM	ETF	223.7	224.315	223.515	223.84	1742190.0
2021-09-10 13:00:00	IWM	ETF	223.845	224.205	223.61	223.84	1287379.0
2021-09-10 14:00:00	IWM	ETF	223.84	224.05	223.33	223.385	1227591.0
2021-09-10 15:00:00	IWM	ETF	223.39	223.46	221.52	221.63	4466239.0
2021-09-10 16:00:00	IWM	ETF	221.62	222.04	221.54	221.92	2235296.0
2021-09-10 17:00:00	IWM	ETF	221.92	221.92	221.62	221.85	33286.0
2021-09-10 18:00:00	IWM	ETF	221.85	221.85	221.6	221.78	11361.0
2021-09-10 19:00:00	IWM	ETF	221.78	221.78	221.62	221.62	12345.0
2021-09-10 04:00:00	DIA	ETF	350.99	351.22	350.99	351.22	1000.0
2021-09-10 05:00:00	DIA	ETF	351.13	351.13	350.94	350.95	7100.0

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

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