PREVIEW / etf_1hour / 2021-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-29.parquet
  size:    424 KB
  rows:    14,879

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-29 04:00:00	SPY	ETF	436.7	437.06	436.01	436.8	77089.0
2021-09-29 05:00:00	SPY	ETF	436.84	437.07	436.37	436.94	152254.0
2021-09-29 06:00:00	SPY	ETF	436.94	437.14	436.35	436.49	110164.0
2021-09-29 07:00:00	SPY	ETF	436.41	436.6	435.49	436.1	374617.0
2021-09-29 08:00:00	SPY	ETF	436.11	437.1104	435.0	435.51	916833.0
2021-09-29 09:00:00	SPY	ETF	435.5	436.49	434.03	436.23	10637993.0
2021-09-29 10:00:00	SPY	ETF	436.24	437.04	435.5	436.75	9164647.0
2021-09-29 11:00:00	SPY	ETF	436.73	436.81	435.01	435.6909	6610900.0
2021-09-29 12:00:00	SPY	ETF	435.7	435.945	434.25	435.0	5731699.0
2021-09-29 13:00:00	SPY	ETF	435.01	435.39	433.85	434.93	8287554.0
2021-09-29 14:00:00	SPY	ETF	434.93	436.98	434.84	436.61	7525594.0
2021-09-29 15:00:00	SPY	ETF	436.65	436.89	433.9501	434.43	14593844.0
2021-09-29 16:00:00	SPY	ETF	434.4399	435.287	434.33	435.03	5012476.0
2021-09-29 17:00:00	SPY	ETF	435.02	435.24	434.8	435.24	126163.0
2021-09-29 18:00:00	SPY	ETF	435.23	435.46	434.45	435.21	79204.0
2021-09-29 19:00:00	SPY	ETF	435.26	435.97	435.23	435.62	130938.0
2021-09-29 04:00:00	QQQ	ETF	362.35	363.63	362.35	363.11	88531.0
2021-09-29 05:00:00	QQQ	ETF	363.26	363.51	362.77	363.31	45626.0
2021-09-29 06:00:00	QQQ	ETF	363.4	363.66	362.94	363.03	65946.0
2021-09-29 07:00:00	QQQ	ETF	363.0	363.2	361.79	362.46	311859.0
2021-09-29 08:00:00	QQQ	ETF	363.1	363.7	361.42	361.9	569343.0
2021-09-29 09:00:00	QQQ	ETF	361.89	363.3	360.47	362.8	9185196.0
2021-09-29 10:00:00	QQQ	ETF	362.8	363.37	361.28	362.68	7906589.0
2021-09-29 11:00:00	QQQ	ETF	362.67	362.79	359.75	360.705	6321687.0
2021-09-29 12:00:00	QQQ	ETF	360.7	360.93	358.95	359.93	5565450.0
2021-09-29 13:00:00	QQQ	ETF	359.95	360.39	358.635	359.865	5165418.0
2021-09-29 14:00:00	QQQ	ETF	359.85	362.03	359.77	361.775	5059033.0
2021-09-29 15:00:00	QQQ	ETF	361.78	362.005	358.76	359.35	7004447.0
2021-09-29 16:00:00	QQQ	ETF	359.34	360.19	359.27	359.82	1448826.0
2021-09-29 17:00:00	QQQ	ETF	360.06	360.06	359.28	359.8	188836.0
2021-09-29 18:00:00	QQQ	ETF	359.88	360.28	359.68	359.88	60368.0
2021-09-29 19:00:00	QQQ	ETF	359.9	360.71	359.9	360.44	86351.0
2021-09-29 04:00:00	IWM	ETF	222.76	222.89	222.39	222.86	6676.0
2021-09-29 05:00:00	IWM	ETF	222.95	223.17	222.72	223.17	15879.0
2021-09-29 06:00:00	IWM	ETF	223.16	223.33	222.92	222.92	9926.0
2021-09-29 07:00:00	IWM	ETF	222.9	223.05	222.45	222.67	60988.0
2021-09-29 08:00:00	IWM	ETF	222.71	223.1	222.1	222.4	128240.0
2021-09-29 09:00:00	IWM	ETF	222.37	222.66	220.65	222.04	3515154.0
2021-09-29 10:00:00	IWM	ETF	222.05	222.58	221.19	222.09	3442199.0
2021-09-29 11:00:00	IWM	ETF	222.09	222.13	220.74	221.39	2277196.0
2021-09-29 12:00:00	IWM	ETF	221.41	221.54	220.17	220.61	2065673.0
2021-09-29 13:00:00	IWM	ETF	220.62	221.29	220.34	220.98	1697538.0
2021-09-29 14:00:00	IWM	ETF	220.975	222.03	220.93	221.66	1960836.0
2021-09-29 15:00:00	IWM	ETF	221.665	221.9	220.55	220.84	3371224.0
2021-09-29 16:00:00	IWM	ETF	220.82	221.38	220.75	221.34	648621.0
2021-09-29 17:00:00	IWM	ETF	221.39	221.4	220.82	221.33	230776.0
2021-09-29 18:00:00	IWM	ETF	221.35	221.52	220.82	221.45	33171.0
2021-09-29 19:00:00	IWM	ETF	221.45	221.96	221.42	221.75	25627.0
2021-09-29 04:00:00	DIA	ETF	344.96	344.96	344.62	344.75	3659.0
2021-09-29 05:00:00	DIA	ETF	345.05	345.05	344.85	344.85	800.0

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

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