PREVIEW / etf_1hour / 2020-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-24.parquet
  size:    251 KB
  rows:    8,237

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
2020-12-24 04:00:00	SPY	ETF	368.36	368.58	368.36	368.51	7503.0
2020-12-24 05:00:00	SPY	ETF	368.64	368.64	368.56	368.59	5191.0
2020-12-24 06:00:00	SPY	ETF	368.56	368.57	368.35	368.46	17369.0
2020-12-24 07:00:00	SPY	ETF	368.44	368.44	367.93	368.19	41696.0
2020-12-24 08:00:00	SPY	ETF	368.29	368.38	367.97	368.16	142227.0
2020-12-24 09:00:00	SPY	ETF	368.15	368.56	367.96	368.4	2749575.0
2020-12-24 10:00:00	SPY	ETF	368.41	368.72	368.15	368.19	3326410.0
2020-12-24 11:00:00	SPY	ETF	368.19	368.54	367.625	367.87	5032585.0
2020-12-24 12:00:00	SPY	ETF	367.88	369.01	367.45	368.9899	9376283.0
2020-12-24 13:00:00	SPY	ETF	368.97	369.51	368.6256	369.03	2632608.0
2020-12-24 14:00:00	SPY	ETF	369.03	369.1	368.96	369.04	39183.0
2020-12-24 15:00:00	SPY	ETF	369.04	369.04	368.9	368.97	8092.0
2020-12-24 16:00:00	SPY	ETF	368.93	369.23	368.93	368.98	355503.0
2020-12-24 04:00:00	QQQ	ETF	308.64	308.75	308.61	308.65	6242.0
2020-12-24 05:00:00	QQQ	ETF	308.66	308.72	308.53	308.53	2400.0
2020-12-24 06:00:00	QQQ	ETF	308.57	308.77	308.57	308.68	15260.0
2020-12-24 07:00:00	QQQ	ETF	308.67	308.69	308.44	308.55	54117.0
2020-12-24 08:00:00	QQQ	ETF	308.59	308.66	308.44	308.5	31659.0
2020-12-24 09:00:00	QQQ	ETF	308.42	309.86	308.39	309.525	2312113.0
2020-12-24 10:00:00	QQQ	ETF	309.525	310.02	308.931	308.9401	2480010.0
2020-12-24 11:00:00	QQQ	ETF	308.94	309.31	308.59	308.88	1671143.0
2020-12-24 12:00:00	QQQ	ETF	308.88	309.6	308.56	309.53	3039904.0
2020-12-24 13:00:00	QQQ	ETF	309.52	309.61	309.33	309.505	812978.0
2020-12-24 14:00:00	QQQ	ETF	309.48	309.56	309.22	309.3	23473.0
2020-12-24 15:00:00	QQQ	ETF	309.3899	309.46	309.2001	309.38	9452.0
2020-12-24 16:00:00	QQQ	ETF	309.35	309.39	309.3	309.3	1827.0
2020-12-24 04:00:00	IWM	ETF	199.96	200.34	199.96	200.32	15724.0
2020-12-24 05:00:00	IWM	ETF	200.3	200.3	200.2	200.28	500.0
2020-12-24 06:00:00	IWM	ETF	200.18	200.22	200.03	200.22	5600.0
2020-12-24 07:00:00	IWM	ETF	200.16	200.16	199.81	199.95	45668.0
2020-12-24 08:00:00	IWM	ETF	199.8899	200.32	199.78	199.8902	26412.0
2020-12-24 09:00:00	IWM	ETF	199.87	199.99	198.7	199.5	1502913.0
2020-12-24 10:00:00	IWM	ETF	199.49	199.5	198.84	199.11	1463842.0
2020-12-24 11:00:00	IWM	ETF	199.11	199.18	198.06	198.55	1694477.0
2020-12-24 12:00:00	IWM	ETF	198.55	199.11	198.23	198.99	2224410.0
2020-12-24 13:00:00	IWM	ETF	199.01	199.04	198.22	198.96	567555.0
2020-12-24 14:00:00	IWM	ETF	198.96	199.22	198.955	199.16	115542.0
2020-12-24 15:00:00	IWM	ETF	199.07	199.1	199.01	199.1	5401.0
2020-12-24 16:00:00	IWM	ETF	199.13	199.17	199.04	199.13	2746.0
2020-12-24 05:00:00	DIA	ETF	302.13	302.13	301.99	301.99	1400.0
2020-12-24 06:00:00	DIA	ETF	301.9	301.95	301.9	301.9	3520.0
2020-12-24 07:00:00	DIA	ETF	301.86	301.86	301.58	301.76	7224.0
2020-12-24 08:00:00	DIA	ETF	301.9	302.13	301.63	301.679	2527.0
2020-12-24 09:00:00	DIA	ETF	301.74	301.91	301.35	301.79	178169.0
2020-12-24 10:00:00	DIA	ETF	301.81	301.83	301.41	301.75	186065.0
2020-12-24 11:00:00	DIA	ETF	301.67	301.92	301.06	301.24	246355.0
2020-12-24 12:00:00	DIA	ETF	301.24	302.1	300.93	302.09	362232.0
2020-12-24 13:00:00	DIA	ETF	302.02	302.09	301.9	302.05	16603.0
2020-12-24 14:00:00	DIA	ETF	301.81	301.93	301.81	301.93	2298.0
2020-12-24 16:00:00	DIA	ETF	301.79	301.79	301.79	301.79	700.0

> showing 50 of 8,237 rows — these rows as CSV

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