PREVIEW / etf_1hour / 2021-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-29.parquet
  size:    451 KB
  rows:    16,135

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-11-29 04:00:00	SPY	ETF	461.01	463.05	457.03	461.59	170307.0
2021-11-29 05:00:00	SPY	ETF	461.65	463.19	461.65	463.07	178859.0
2021-11-29 06:00:00	SPY	ETF	463.08	463.4	462.67	462.67	144387.0
2021-11-29 07:00:00	SPY	ETF	462.71	462.96	462.06	462.89	430091.0
2021-11-29 08:00:00	SPY	ETF	462.88	464.2	462.1	463.97	865423.0
2021-11-29 09:00:00	SPY	ETF	463.99	464.6	462.47	463.52	9776040.0
2021-11-29 10:00:00	SPY	ETF	463.51	463.82	461.73	462.57	9051502.0
2021-11-29 11:00:00	SPY	ETF	462.6	464.52	462.26	464.48	6713338.0
2021-11-29 12:00:00	SPY	ETF	464.49	466.31	464.47	466.13	5891359.0
2021-11-29 13:00:00	SPY	ETF	466.14	466.56	465.61	466.24	4110981.0
2021-11-29 14:00:00	SPY	ETF	466.25	466.29	465.42	465.6901	3835590.0
2021-11-29 15:00:00	SPY	ETF	465.69	466.37	464.34	464.63	15385668.0
2021-11-29 16:00:00	SPY	ETF	464.63	465.5864	464.51	465.14	6593796.0
2021-11-29 17:00:00	SPY	ETF	465.15	465.38	465.0	465.38	511192.0
2021-11-29 18:00:00	SPY	ETF	465.32	466.06	464.6	465.85	563999.0
2021-11-29 19:00:00	SPY	ETF	465.84	466.24	465.69	466.12	72710.0
2021-11-29 04:00:00	QQQ	ETF	392.83	395.53	392.83	394.23	95926.0
2021-11-29 05:00:00	QQQ	ETF	394.3	395.35	394.3	395.35	92036.0
2021-11-29 06:00:00	QQQ	ETF	395.2	395.53	394.87	395.01	67124.0
2021-11-29 07:00:00	QQQ	ETF	394.84	395.12	394.35	395.12	112024.0
2021-11-29 08:00:00	QQQ	ETF	394.7999	396.0	394.2996	395.83	574877.0
2021-11-29 09:00:00	QQQ	ETF	395.84	397.52	395.14	397.33	7638726.0
2021-11-29 10:00:00	QQQ	ETF	397.33	397.72	395.61	396.8	6978823.0
2021-11-29 11:00:00	QQQ	ETF	396.8	398.76	396.4401	398.66	4888896.0
2021-11-29 12:00:00	QQQ	ETF	398.7	399.98	398.54	399.77	3715731.0
2021-11-29 13:00:00	QQQ	ETF	399.77	400.29	399.372	400.1399	3206586.0
2021-11-29 14:00:00	QQQ	ETF	400.15	400.24	399.25	399.888	2860829.0
2021-11-29 15:00:00	QQQ	ETF	399.87	400.73	399.35	399.62	7366852.0
2021-11-29 16:00:00	QQQ	ETF	399.63	400.17	398.5293	400.15	6914688.0
2021-11-29 17:00:00	QQQ	ETF	400.08	400.19	399.85	400.19	54079.0
2021-11-29 18:00:00	QQQ	ETF	400.18	400.8	399.69	400.5	136434.0
2021-11-29 19:00:00	QQQ	ETF	400.55	400.74	400.3	400.62	78402.0
2021-11-29 04:00:00	IWM	ETF	224.04	224.87	223.53	223.56	77013.0
2021-11-29 05:00:00	IWM	ETF	223.56	225.12	223.56	224.96	72362.0
2021-11-29 06:00:00	IWM	ETF	225.04	225.65	225.04	225.18	107360.0
2021-11-29 07:00:00	IWM	ETF	225.17	225.62	224.47	225.59	248545.0
2021-11-29 08:00:00	IWM	ETF	223.7196	226.68	223.7196	226.17	475773.0
2021-11-29 09:00:00	IWM	ETF	226.14	226.79	223.95	224.46	5163803.0
2021-11-29 10:00:00	IWM	ETF	224.45	224.76	221.24	222.23	7335892.0
2021-11-29 11:00:00	IWM	ETF	222.23	223.12	221.77	222.97	3628343.0
2021-11-29 12:00:00	IWM	ETF	222.96	225.31	222.93	225.2	3759469.0
2021-11-29 13:00:00	IWM	ETF	225.21	225.5799	223.85	224.4	2890339.0
2021-11-29 14:00:00	IWM	ETF	224.4025	224.435	223.1	223.46	2744211.0
2021-11-29 15:00:00	IWM	ETF	223.46	223.95	222.07	222.7	6051334.0
2021-11-29 16:00:00	IWM	ETF	222.71	223.2	222.54	223.05	1957813.0
2021-11-29 17:00:00	IWM	ETF	223.06	223.08	222.92	223.08	18676.0
2021-11-29 18:00:00	IWM	ETF	223.09	223.81	222.71	223.8	204637.0
2021-11-29 19:00:00	IWM	ETF	223.76	224.15	223.66	224.04	40004.0
2021-11-29 04:00:00	DIA	ETF	340.0	351.09	340.0	350.31	12912.0
2021-11-29 05:00:00	DIA	ETF	350.38	351.53	350.38	351.48	3514.0

> showing 50 of 16,135 rows — these rows as CSV

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