PREVIEW / etf_1hour / 2021-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-14.parquet
  size:    420 KB
  rows:    14,402

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-14 04:00:00	SPY	ETF	380.81	380.92	380.67	380.83	24502.0
2021-01-14 05:00:00	SPY	ETF	380.76	380.76	380.04	380.3	22953.0
2021-01-14 06:00:00	SPY	ETF	380.38	380.46	380.0	380.46	24327.0
2021-01-14 07:00:00	SPY	ETF	380.44	380.55	380.26	380.48	197716.0
2021-01-14 08:00:00	SPY	ETF	380.47	380.57	380.05	380.45	513637.0
2021-01-14 09:00:00	SPY	ETF	380.48	380.93	380.22	380.835	3841838.0
2021-01-14 10:00:00	SPY	ETF	380.83	381.13	380.36	380.77	4451351.0
2021-01-14 11:00:00	SPY	ETF	380.76	380.87	380.18	380.38	4035195.0
2021-01-14 12:00:00	SPY	ETF	380.37	380.76	379.84	380.63	4058639.0
2021-01-14 13:00:00	SPY	ETF	380.63	380.73	380.07	380.24	2853058.0
2021-01-14 14:00:00	SPY	ETF	380.24	380.52	379.65	379.9031	3235466.0
2021-01-14 15:00:00	SPY	ETF	379.905	380.08	378.1	378.45	18604245.0
2021-01-14 16:00:00	SPY	ETF	378.49	378.85	378.26	378.46	6498115.0
2021-01-14 17:00:00	SPY	ETF	378.37	378.87	378.37	378.87	372152.0
2021-01-14 18:00:00	SPY	ETF	378.86	379.22	378.74	379.02	111207.0
2021-01-14 19:00:00	SPY	ETF	378.91	379.05	378.0	378.25	218434.0
2021-01-14 04:00:00	QQQ	ETF	316.08	316.33	315.65	315.65	32255.0
2021-01-14 05:00:00	QQQ	ETF	315.65	315.65	314.97	315.43	22146.0
2021-01-14 06:00:00	QQQ	ETF	315.49	315.89	315.02	315.88	48440.0
2021-01-14 07:00:00	QQQ	ETF	315.92	316.33	315.79	316.2	136140.0
2021-01-14 08:00:00	QQQ	ETF	315.69	316.53	315.5696	316.41	212563.0
2021-01-14 09:00:00	QQQ	ETF	316.4402	317.2	316.07	316.67	2366520.0
2021-01-14 10:00:00	QQQ	ETF	316.66	317.53	316.36	317.15	2429132.0
2021-01-14 11:00:00	QQQ	ETF	317.15	317.38	316.05	316.252	2141646.0
2021-01-14 12:00:00	QQQ	ETF	316.2674	316.42	315.2	316.3698	2285653.0
2021-01-14 13:00:00	QQQ	ETF	316.33	316.37	315.43	315.46	1470636.0
2021-01-14 14:00:00	QQQ	ETF	315.46	315.93	315.26	315.55	1362264.0
2021-01-14 15:00:00	QQQ	ETF	315.555	315.69	313.8616	314.25	4952746.0
2021-01-14 16:00:00	QQQ	ETF	314.28	314.51	314.06	314.29	731105.0
2021-01-14 17:00:00	QQQ	ETF	314.26	314.79	314.2	314.65	49672.0
2021-01-14 18:00:00	QQQ	ETF	314.64	314.98	314.63	314.76	83187.0
2021-01-14 19:00:00	QQQ	ETF	314.72	314.85	314.05	314.27	139022.0
2021-01-14 04:00:00	IWM	ETF	211.51	211.77	211.25	211.65	25030.0
2021-01-14 05:00:00	IWM	ETF	211.68	211.74	211.34	211.34	8452.0
2021-01-14 06:00:00	IWM	ETF	211.38	211.44	211.19	211.4	20450.0
2021-01-14 07:00:00	IWM	ETF	211.49	211.49	211.08	211.11	81421.0
2021-01-14 08:00:00	IWM	ETF	211.12	211.3804	210.73	210.98	60627.0
2021-01-14 09:00:00	IWM	ETF	210.93	212.82	210.77	212.7301	2316837.0
2021-01-14 10:00:00	IWM	ETF	212.72	213.94	212.65	213.16	3374061.0
2021-01-14 11:00:00	IWM	ETF	213.16	214.28	213.05	214.23	2362614.0
2021-01-14 12:00:00	IWM	ETF	214.23	214.47	213.0	213.78	3033566.0
2021-01-14 13:00:00	IWM	ETF	213.77	214.55	213.74	214.42	1870741.0
2021-01-14 14:00:00	IWM	ETF	214.42	215.0	214.3406	214.735	2072668.0
2021-01-14 15:00:00	IWM	ETF	214.75	214.91	213.43	213.91	4969191.0
2021-01-14 16:00:00	IWM	ETF	213.94	214.33	212.3811	213.92	2385270.0
2021-01-14 17:00:00	IWM	ETF	213.84	214.4	213.84	214.4	44050.0
2021-01-14 18:00:00	IWM	ETF	214.26	214.59	213.94	214.2	85682.0
2021-01-14 19:00:00	IWM	ETF	214.18	214.24	213.26	213.53	87912.0
2021-01-14 04:00:00	DIA	ETF	309.82	311.81	309.82	311.79	1073.0
2021-01-14 05:00:00	DIA	ETF	311.85	311.85	311.85	311.85	190.0

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

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