PREVIEW / etf_1hour / 2021-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-04.parquet
  size:    433 KB
  rows:    15,540

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-04 04:00:00	SPY	ETF	465.13	465.77	465.08	465.15	22402.0
2021-11-04 05:00:00	SPY	ETF	465.22	465.32	465.01	465.15	11284.0
2021-11-04 06:00:00	SPY	ETF	465.14	465.46	465.06	465.45	8827.0
2021-11-04 07:00:00	SPY	ETF	465.42	465.56	465.24	465.27	60614.0
2021-11-04 08:00:00	SPY	ETF	465.4299	465.75	464.74	465.36	270811.0
2021-11-04 09:00:00	SPY	ETF	465.37	466.56	464.99	466.35	5406714.0
2021-11-04 10:00:00	SPY	ETF	466.355	467.0	466.22	466.5	5120074.0
2021-11-04 11:00:00	SPY	ETF	466.5	466.5	465.17	466.23	5239263.0
2021-11-04 12:00:00	SPY	ETF	466.24	466.49	465.693	465.925	2725098.0
2021-11-04 13:00:00	SPY	ETF	465.93	466.405	465.5	466.3	2700872.0
2021-11-04 14:00:00	SPY	ETF	466.3	466.355	465.6	465.79	3168173.0
2021-11-04 15:00:00	SPY	ETF	465.76	466.91	465.54	466.88	9771377.0
2021-11-04 16:00:00	SPY	ETF	466.88	467.12	466.57	466.78	2782678.0
2021-11-04 17:00:00	SPY	ETF	466.84	466.91	466.7	466.76	261284.0
2021-11-04 18:00:00	SPY	ETF	466.71	467.09	466.57	466.98	57169.0
2021-11-04 19:00:00	SPY	ETF	466.98	467.22	466.85	467.19	68505.0
2021-11-04 04:00:00	QQQ	ETF	394.26	395.3	394.25	394.69	82256.0
2021-11-04 05:00:00	QQQ	ETF	394.74	394.89	394.6	394.83	19777.0
2021-11-04 06:00:00	QQQ	ETF	394.77	395.07	394.7	395.0	30345.0
2021-11-04 07:00:00	QQQ	ETF	395.04	395.04	394.56	394.72	113880.0
2021-11-04 08:00:00	QQQ	ETF	395.0	395.02	393.494	394.63	581139.0
2021-11-04 09:00:00	QQQ	ETF	394.62	396.22	393.92	396.06	4183070.0
2021-11-04 10:00:00	QQQ	ETF	396.09	398.135	395.84	397.7	5232430.0
2021-11-04 11:00:00	QQQ	ETF	397.72	397.74	395.985	397.27	4780318.0
2021-11-04 12:00:00	QQQ	ETF	397.285	397.98	397.08	397.47	2581135.0
2021-11-04 13:00:00	QQQ	ETF	397.49	398.67	396.99	398.55	2321331.0
2021-11-04 14:00:00	QQQ	ETF	398.56	399.2	397.74	398.07	2947840.0
2021-11-04 15:00:00	QQQ	ETF	398.06	398.495	397.21	398.26	6234789.0
2021-11-04 16:00:00	QQQ	ETF	398.24	398.45	397.93	398.26	1342848.0
2021-11-04 17:00:00	QQQ	ETF	398.17	398.27	398.06	398.22	32108.0
2021-11-04 18:00:00	QQQ	ETF	398.19	398.6	398.0	398.32	84060.0
2021-11-04 19:00:00	QQQ	ETF	398.35	398.38	398.05	398.33	45625.0
2021-11-04 04:00:00	IWM	ETF	239.17	239.3	238.66	238.97	13846.0
2021-11-04 05:00:00	IWM	ETF	239.01	239.19	238.81	238.89	13774.0
2021-11-04 06:00:00	IWM	ETF	238.74	238.94	238.71	238.82	10813.0
2021-11-04 07:00:00	IWM	ETF	238.84	239.14	238.82	238.99	37285.0
2021-11-04 08:00:00	IWM	ETF	238.8296	239.65	238.8296	239.34	91244.0
2021-11-04 09:00:00	IWM	ETF	239.35	240.83	239.23	240.03	3182664.0
2021-11-04 10:00:00	IWM	ETF	240.02	240.935	239.35	239.68	3465520.0
2021-11-04 11:00:00	IWM	ETF	239.67	239.67	237.56	238.7	4075503.0
2021-11-04 12:00:00	IWM	ETF	238.71	238.89	238.26	238.47	1403233.0
2021-11-04 13:00:00	IWM	ETF	238.47	239.01	238.25	238.72	1349887.0
2021-11-04 14:00:00	IWM	ETF	238.735	238.76	237.87	238.04	1624077.0
2021-11-04 15:00:00	IWM	ETF	238.045	238.625	237.769	238.51	3592361.0
2021-11-04 16:00:00	IWM	ETF	238.55	238.87	238.44	238.7	2930928.0
2021-11-04 17:00:00	IWM	ETF	238.8	238.87	238.55	238.79	29802.0
2021-11-04 18:00:00	IWM	ETF	238.7	239.02	238.55	238.95	44120.0
2021-11-04 19:00:00	IWM	ETF	238.93	239.11	238.84	239.08	17867.0
2021-11-04 04:00:00	DIA	ETF	361.68	361.68	361.57	361.58	1720.0
2021-11-04 05:00:00	DIA	ETF	361.42	361.42	361.26	361.35	576.0

> showing 50 of 15,540 rows — these rows as CSV

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