PREVIEW / etf_1hour / 2021-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-20.parquet
  size:    423 KB
  rows:    14,468

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-01-20 04:00:00	SPY	ETF	379.63	379.86	379.48	379.86	20137.0
2021-01-20 05:00:00	SPY	ETF	379.83	380.35	379.8	380.3	19157.0
2021-01-20 06:00:00	SPY	ETF	380.25	380.33	379.9	379.98	21978.0
2021-01-20 07:00:00	SPY	ETF	379.94	380.09	379.8	380.04	198550.0
2021-01-20 08:00:00	SPY	ETF	380.0	380.65	379.13	380.64	331708.0
2021-01-20 09:00:00	SPY	ETF	380.66	381.6	380.66	381.3328	4332952.0
2021-01-20 10:00:00	SPY	ETF	381.34	383.082	381.34	382.7718	7249085.0
2021-01-20 11:00:00	SPY	ETF	382.77	383.08	382.18	382.92	4028413.0
2021-01-20 12:00:00	SPY	ETF	382.92	383.76	382.92	383.65	3091819.0
2021-01-20 13:00:00	SPY	ETF	383.65	384.26	383.615	383.84	3591042.0
2021-01-20 14:00:00	SPY	ETF	383.85	384.42	383.41	384.1469	3637014.0
2021-01-20 15:00:00	SPY	ETF	384.145	384.79	383.82	383.86	10306373.0
2021-01-20 16:00:00	SPY	ETF	383.84	384.1	383.55	383.62	3808310.0
2021-01-20 17:00:00	SPY	ETF	383.55	383.89	383.55	383.75	94666.0
2021-01-20 18:00:00	SPY	ETF	383.75	384.49	383.7	384.32	144357.0
2021-01-20 19:00:00	SPY	ETF	384.29	384.63	384.0	384.57	85763.0
2021-01-20 04:00:00	QQQ	ETF	318.45	318.8	318.2	318.8	30541.0
2021-01-20 05:00:00	QQQ	ETF	318.71	319.2	318.68	319.2	19581.0
2021-01-20 06:00:00	QQQ	ETF	319.12	319.15	318.81	319.04	37255.0
2021-01-20 07:00:00	QQQ	ETF	319.01	319.41	318.82	319.41	190661.0
2021-01-20 08:00:00	QQQ	ETF	318.9999	319.76	316.41	319.74	418075.0
2021-01-20 09:00:00	QQQ	ETF	319.73	321.541	319.73	320.79	4079157.0
2021-01-20 10:00:00	QQQ	ETF	320.81	322.85	320.8	322.58	4277107.0
2021-01-20 11:00:00	QQQ	ETF	322.57	323.0	321.8	322.85	2985021.0
2021-01-20 12:00:00	QQQ	ETF	322.86	323.4799	322.69	323.305	1891272.0
2021-01-20 13:00:00	QQQ	ETF	323.3	323.95	323.245	323.625	1868276.0
2021-01-20 14:00:00	QQQ	ETF	323.62	324.498	323.2998	324.33	1739525.0
2021-01-20 15:00:00	QQQ	ETF	324.35	324.74	323.71	323.73	5115889.0
2021-01-20 16:00:00	QQQ	ETF	323.73	324.32	323.55	323.81	937220.0
2021-01-20 17:00:00	QQQ	ETF	323.78	324.05	323.78	323.98	199165.0
2021-01-20 18:00:00	QQQ	ETF	323.92	324.57	323.9	324.41	71262.0
2021-01-20 19:00:00	QQQ	ETF	324.41	325.32	324.26	325.22	73431.0
2021-01-20 04:00:00	IWM	ETF	213.27	213.27	212.8	212.99	7098.0
2021-01-20 05:00:00	IWM	ETF	213.11	213.11	212.94	213.11	8018.0
2021-01-20 06:00:00	IWM	ETF	213.21	213.21	212.74	212.99	6358.0
2021-01-20 07:00:00	IWM	ETF	212.99	213.21	212.91	213.19	87652.0
2021-01-20 08:00:00	IWM	ETF	212.9101	214.18	212.68	214.18	84496.0
2021-01-20 09:00:00	IWM	ETF	214.152	215.12	214.07	215.04	2008933.0
2021-01-20 10:00:00	IWM	ETF	215.05	215.98	214.66	214.825	3220923.0
2021-01-20 11:00:00	IWM	ETF	214.82	214.82	213.33	214.13	2838293.0
2021-01-20 12:00:00	IWM	ETF	214.145	214.41	213.07	214.1	2161872.0
2021-01-20 13:00:00	IWM	ETF	214.09	214.34	213.42	213.88	1866390.0
2021-01-20 14:00:00	IWM	ETF	213.88	214.42	213.47	214.32	2026266.0
2021-01-20 15:00:00	IWM	ETF	214.3	214.69	213.93	214.39	2760232.0
2021-01-20 16:00:00	IWM	ETF	214.39	214.4735	213.79	213.8	1306244.0
2021-01-20 17:00:00	IWM	ETF	213.97	214.27	213.8	213.82	17036.0
2021-01-20 18:00:00	IWM	ETF	213.88	214.51	213.88	214.41	23208.0
2021-01-20 19:00:00	IWM	ETF	214.25	214.53	214.19	214.47	20938.0
2021-01-20 04:00:00	DIA	ETF	309.51	309.78	309.51	309.78	1100.0
2021-01-20 05:00:00	DIA	ETF	310.06	310.12	310.06	310.12	400.0

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

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