PREVIEW / etf_1hour / 2020-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-28.parquet
  size:    406 KB
  rows:    14,061

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-28 04:00:00	SPY	ETF	371.16	371.32	371.0	371.29	17057.0
2020-12-28 05:00:00	SPY	ETF	371.32	371.36	371.17	371.33	11056.0
2020-12-28 06:00:00	SPY	ETF	371.4	372.11	371.4	371.69	24107.0
2020-12-28 07:00:00	SPY	ETF	371.52	371.61	371.28	371.52	158968.0
2020-12-28 08:00:00	SPY	ETF	371.51	371.81	371.13	371.73	264356.0
2020-12-28 09:00:00	SPY	ETF	371.68	371.89	371.07	371.38	3976304.0
2020-12-28 10:00:00	SPY	ETF	371.38	372.309	371.11	372.1	5063986.0
2020-12-28 11:00:00	SPY	ETF	372.11	372.13	371.76	371.845	5460284.0
2020-12-28 12:00:00	SPY	ETF	371.83	372.14	371.81	372.02	2993420.0
2020-12-28 13:00:00	SPY	ETF	372.02	372.3	371.9601	372.2399	2289434.0
2020-12-28 14:00:00	SPY	ETF	372.23	372.59	372.17	372.46	2533046.0
2020-12-28 15:00:00	SPY	ETF	372.45	372.53	371.87	372.14	9541003.0
2020-12-28 16:00:00	SPY	ETF	372.13	372.41	371.92	372.29	5155945.0
2020-12-28 17:00:00	SPY	ETF	372.28	372.45	372.17	372.35	54476.0
2020-12-28 18:00:00	SPY	ETF	372.44	372.87	372.35	372.87	63390.0
2020-12-28 19:00:00	SPY	ETF	372.87	373.35	372.85	373.14	116166.0
2020-12-28 04:00:00	QQQ	ETF	311.41	311.44	311.12	311.4	23500.0
2020-12-28 05:00:00	QQQ	ETF	311.37	311.5	311.29	311.49	19044.0
2020-12-28 06:00:00	QQQ	ETF	311.54	311.8	311.53	311.55	32425.0
2020-12-28 07:00:00	QQQ	ETF	311.52	312.0	311.49	311.97	89909.0
2020-12-28 08:00:00	QQQ	ETF	311.97	312.46	311.31	312.4	138803.0
2020-12-28 09:00:00	QQQ	ETF	312.42	312.5	311.39	311.765	2959676.0
2020-12-28 10:00:00	QQQ	ETF	311.768	312.14	310.36	312.06	3995254.0
2020-12-28 11:00:00	QQQ	ETF	312.07	312.45	311.925	312.29	2086559.0
2020-12-28 12:00:00	QQQ	ETF	312.29	312.75	312.0601	312.73	1763638.0
2020-12-28 13:00:00	QQQ	ETF	312.73	312.93	312.595	312.74	1666763.0
2020-12-28 14:00:00	QQQ	ETF	312.74	313.11	312.66	313.035	1238480.0
2020-12-28 15:00:00	QQQ	ETF	313.0201	313.17	312.42	312.65	2964167.0
2020-12-28 16:00:00	QQQ	ETF	312.63	312.86	311.03	312.82	1179967.0
2020-12-28 17:00:00	QQQ	ETF	312.97	312.97	312.7	312.84	10213.0
2020-12-28 18:00:00	QQQ	ETF	312.85	313.09	312.79	313.08	37416.0
2020-12-28 19:00:00	QQQ	ETF	313.1	313.36	313.1	313.27	49527.0
2020-12-28 04:00:00	IWM	ETF	201.3	201.44	201.2	201.39	48289.0
2020-12-28 05:00:00	IWM	ETF	201.4	201.6	201.31	201.57	5977.0
2020-12-28 06:00:00	IWM	ETF	201.54	201.9	201.34	201.87	15409.0
2020-12-28 07:00:00	IWM	ETF	201.74	201.91	201.44	201.55	66650.0
2020-12-28 08:00:00	IWM	ETF	201.57	201.85	201.08	201.61	43654.0
2020-12-28 09:00:00	IWM	ETF	201.54	201.6	199.01	200.63	2581624.0
2020-12-28 10:00:00	IWM	ETF	200.62	200.76	199.4	199.79	3424182.0
2020-12-28 11:00:00	IWM	ETF	199.785	200.07	199.2	199.28	2255917.0
2020-12-28 12:00:00	IWM	ETF	199.27	199.82	199.19	199.37	2710592.0
2020-12-28 13:00:00	IWM	ETF	199.37	199.75	199.05	199.19	2391679.0
2020-12-28 14:00:00	IWM	ETF	199.18	199.76	199.11	199.45	2432034.0
2020-12-28 15:00:00	IWM	ETF	199.4518	199.65	198.13	198.24	4536421.0
2020-12-28 16:00:00	IWM	ETF	198.24	198.43	198.03	198.28	1423076.0
2020-12-28 17:00:00	IWM	ETF	198.27	198.36	198.1	198.32	47703.0
2020-12-28 18:00:00	IWM	ETF	198.36	198.87	198.36	198.7	30317.0
2020-12-28 19:00:00	IWM	ETF	198.74	198.96	198.72	198.77	26624.0
2020-12-28 04:00:00	DIA	ETF	303.0	303.36	303.0	303.35	2600.0
2020-12-28 05:00:00	DIA	ETF	303.43	303.5	303.35	303.5	1400.0

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

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