PREVIEW / etf_1hour / 2021-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-16.parquet
  size:    412 KB
  rows:    14,178

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-07-16 04:00:00	SPY	ETF	434.8	435.06	434.47	435.05	10758.0
2021-07-16 05:00:00	SPY	ETF	435.13	435.37	435.0	435.25	12948.0
2021-07-16 06:00:00	SPY	ETF	435.33	435.35	434.72	435.23	65437.0
2021-07-16 07:00:00	SPY	ETF	435.31	435.54	435.15	435.35	103543.0
2021-07-16 08:00:00	SPY	ETF	435.36	435.99	434.2	435.84	264394.0
2021-07-16 09:00:00	SPY	ETF	435.85	436.42	434.92	435.18	5727875.0
2021-07-16 10:00:00	SPY	ETF	435.19	435.27	433.14	433.8001	11635857.0
2021-07-16 11:00:00	SPY	ETF	433.82	433.95	432.93	433.6519	6027414.0
2021-07-16 12:00:00	SPY	ETF	433.65	434.23	433.5119	433.685	5773318.0
2021-07-16 13:00:00	SPY	ETF	433.69	434.065	433.04	433.165	3978178.0
2021-07-16 14:00:00	SPY	ETF	433.17	433.19	432.04	432.2158	7205520.0
2021-07-16 15:00:00	SPY	ETF	432.22	432.34	430.92	431.4	15754567.0
2021-07-16 16:00:00	SPY	ETF	431.4	434.6767	430.92	431.33	3518282.0
2021-07-16 17:00:00	SPY	ETF	431.33	431.38	431.11	431.2	70536.0
2021-07-16 18:00:00	SPY	ETF	431.29	431.4	431.15	431.38	49302.0
2021-07-16 19:00:00	SPY	ETF	431.38	431.39	431.2	431.28	39231.0
2021-07-16 04:00:00	QQQ	ETF	360.82	360.88	360.17	360.66	15543.0
2021-07-16 05:00:00	QQQ	ETF	360.48	360.95	360.47	360.89	20802.0
2021-07-16 06:00:00	QQQ	ETF	360.97	361.13	360.51	361.13	36475.0
2021-07-16 07:00:00	QQQ	ETF	361.11	361.29	360.87	361.0	130755.0
2021-07-16 08:00:00	QQQ	ETF	361.05	361.81	359.81	361.62	337906.0
2021-07-16 09:00:00	QQQ	ETF	361.63	362.41	360.78	361.11	5112202.0
2021-07-16 10:00:00	QQQ	ETF	361.1	361.2	359.2	359.78	5841256.0
2021-07-16 11:00:00	QQQ	ETF	359.81	359.98	358.17	358.9	4479332.0
2021-07-16 12:00:00	QQQ	ETF	358.92	359.985	358.85	359.7	2256607.0
2021-07-16 13:00:00	QQQ	ETF	359.705	360.29	359.165	359.2509	2720180.0
2021-07-16 14:00:00	QQQ	ETF	359.26	359.32	358.32	358.42	3692216.0
2021-07-16 15:00:00	QQQ	ETF	358.43	358.6	357.24	357.6	7673606.0
2021-07-16 16:00:00	QQQ	ETF	357.6	357.75	357.26	357.53	1865944.0
2021-07-16 17:00:00	QQQ	ETF	357.52	357.6	357.27	357.35	90819.0
2021-07-16 18:00:00	QQQ	ETF	357.35	357.37	357.15	357.25	16489.0
2021-07-16 19:00:00	QQQ	ETF	357.18	357.29	357.0	357.29	31287.0
2021-07-16 04:00:00	IWM	ETF	218.2	218.67	217.87	218.67	8479.0
2021-07-16 05:00:00	IWM	ETF	218.65	219.0	218.38	218.38	14869.0
2021-07-16 06:00:00	IWM	ETF	218.57	218.66	218.19	218.57	9050.0
2021-07-16 07:00:00	IWM	ETF	218.54	218.73	218.27	218.28	35455.0
2021-07-16 08:00:00	IWM	ETF	218.6098	220.035	218.2	219.7	259555.0
2021-07-16 09:00:00	IWM	ETF	219.73	220.05	218.35	218.62	3658639.0
2021-07-16 10:00:00	IWM	ETF	218.62	218.715	216.56	217.7	5387701.0
2021-07-16 11:00:00	IWM	ETF	217.7	218.62	216.98	218.38	3165650.0
2021-07-16 12:00:00	IWM	ETF	218.39	218.4	217.02	217.34	1946548.0
2021-07-16 13:00:00	IWM	ETF	217.34	217.4	215.93	216.0411	2430884.0
2021-07-16 14:00:00	IWM	ETF	216.05	216.32	215.45	215.48	3001419.0
2021-07-16 15:00:00	IWM	ETF	215.48	215.5	214.47	214.93	6273582.0
2021-07-16 16:00:00	IWM	ETF	214.95	215.04	214.5	214.89	2083210.0
2021-07-16 17:00:00	IWM	ETF	214.97	214.97	214.8	214.94	327248.0
2021-07-16 18:00:00	IWM	ETF	214.95	214.95	214.86	214.86	543.0
2021-07-16 19:00:00	IWM	ETF	214.9	215.19	214.85	214.95	9305.0
2021-07-16 04:00:00	DIA	ETF	349.84	350.26	349.73	350.26	900.0
2021-07-16 05:00:00	DIA	ETF	350.22	350.22	350.22	350.22	100.0

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

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