PREVIEW / etf_1hour / 2021-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-12.parquet
  size:    417 KB
  rows:    14,228

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-12 04:00:00	SPY	ETF	379.29	380.2	379.2	379.82	36930.0
2021-01-12 05:00:00	SPY	ETF	379.94	379.94	379.66	379.7	10533.0
2021-01-12 06:00:00	SPY	ETF	379.7	379.83	379.43	379.67	15613.0
2021-01-12 07:00:00	SPY	ETF	379.58	379.97	379.49	379.68	109895.0
2021-01-12 08:00:00	SPY	ETF	379.69	379.93	378.2	378.66	318957.0
2021-01-12 09:00:00	SPY	ETF	378.55	379.29	377.75	378.82	5257069.0
2021-01-12 10:00:00	SPY	ETF	378.82	379.73	378.28	379.1393	5808846.0
2021-01-12 11:00:00	SPY	ETF	379.14	379.86	377.85	378.29	4652265.0
2021-01-12 12:00:00	SPY	ETF	378.28	378.33	376.36	378.01	7606258.0
2021-01-12 13:00:00	SPY	ETF	378.02	379.16	377.77	378.8801	4421568.0
2021-01-12 14:00:00	SPY	ETF	378.895	379.46	378.15	378.74	5444458.0
2021-01-12 15:00:00	SPY	ETF	378.745	379.5	378.58	378.81	12507726.0
2021-01-12 16:00:00	SPY	ETF	378.78	379.1	378.62	378.81	4910437.0
2021-01-12 17:00:00	SPY	ETF	378.66	378.98	378.63	378.78	435188.0
2021-01-12 18:00:00	SPY	ETF	378.78	379.14	378.59	379.05	70071.0
2021-01-12 19:00:00	SPY	ETF	379.07	379.35	378.95	379.01	44193.0
2021-01-12 04:00:00	QQQ	ETF	315.19	315.77	315.18	315.63	24788.0
2021-01-12 05:00:00	QQQ	ETF	315.66	315.7	315.27	315.55	17949.0
2021-01-12 06:00:00	QQQ	ETF	315.51	315.64	315.27	315.38	29431.0
2021-01-12 07:00:00	QQQ	ETF	315.38	315.63	315.32	315.51	134395.0
2021-01-12 08:00:00	QQQ	ETF	315.52	315.6298	313.66	314.11	362333.0
2021-01-12 09:00:00	QQQ	ETF	314.05	315.58	313.05	314.19	3377320.0
2021-01-12 10:00:00	QQQ	ETF	314.19	314.87	313.5828	314.08	3301478.0
2021-01-12 11:00:00	QQQ	ETF	314.08	315.08	313.28	313.67	2213540.0
2021-01-12 12:00:00	QQQ	ETF	313.662	313.7874	311.2	313.1	5190784.0
2021-01-12 13:00:00	QQQ	ETF	313.102	314.3301	312.925	314.02	2000873.0
2021-01-12 14:00:00	QQQ	ETF	314.05	314.64	313.29	313.84	2256301.0
2021-01-12 15:00:00	QQQ	ETF	313.85	314.66	313.0	313.98	3533049.0
2021-01-12 16:00:00	QQQ	ETF	313.96	314.11	313.82	313.96	1346005.0
2021-01-12 17:00:00	QQQ	ETF	313.86	314.1	313.83	313.99	34876.0
2021-01-12 18:00:00	QQQ	ETF	314.0	314.36	313.74	314.26	52701.0
2021-01-12 19:00:00	QQQ	ETF	314.29	314.4	314.08	314.19	51388.0
2021-01-12 04:00:00	IWM	ETF	208.24	208.6	207.85	208.6	5261.0
2021-01-12 05:00:00	IWM	ETF	208.54	208.65	208.54	208.6	2585.0
2021-01-12 06:00:00	IWM	ETF	208.56	208.78	208.39	208.54	7699.0
2021-01-12 07:00:00	IWM	ETF	208.46	208.7	208.4	208.59	20978.0
2021-01-12 08:00:00	IWM	ETF	208.5	208.69	207.59	208.09	74502.0
2021-01-12 09:00:00	IWM	ETF	207.93	209.92	207.93	209.87	2446644.0
2021-01-12 10:00:00	IWM	ETF	209.89	210.33	209.25	210.03	2478765.0
2021-01-12 11:00:00	IWM	ETF	210.04	210.7	209.94	210.27	1810750.0
2021-01-12 12:00:00	IWM	ETF	210.27	210.57	209.29	210.299	2824483.0
2021-01-12 13:00:00	IWM	ETF	210.2989	210.62	209.87	210.51	1751375.0
2021-01-12 14:00:00	IWM	ETF	210.51	210.87	209.45	210.8	1849248.0
2021-01-12 15:00:00	IWM	ETF	210.8	211.39	210.62	211.27	4540154.0
2021-01-12 16:00:00	IWM	ETF	211.26	211.26	209.6266	210.9	1261315.0
2021-01-12 17:00:00	IWM	ETF	210.91	211.28	210.91	211.1	102372.0
2021-01-12 18:00:00	IWM	ETF	211.1	211.26	210.91	211.1	34830.0
2021-01-12 19:00:00	IWM	ETF	211.11	211.33	211.08	211.08	13892.0
2021-01-12 04:00:00	DIA	ETF	310.8	310.92	310.8	310.92	375.0
2021-01-12 06:00:00	DIA	ETF	310.81	310.81	310.78	310.78	300.0

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

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