PREVIEW / etf_1hour / 2020-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-23.parquet
  size:    398 KB
  rows:    13,630

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-11-23 04:00:00	SPY	ETF	357.74	357.94	357.29	357.76	43000.0
2020-11-23 05:00:00	SPY	ETF	357.67	357.73	357.45	357.49	8025.0
2020-11-23 06:00:00	SPY	ETF	357.58	357.59	357.13	357.27	77958.0
2020-11-23 07:00:00	SPY	ETF	357.3	357.78	356.88	357.6	248481.0
2020-11-23 08:00:00	SPY	ETF	357.25	357.82	355.92	356.95	593600.0
2020-11-23 09:00:00	SPY	ETF	356.93	358.82	356.64	358.15	4813299.0
2020-11-23 10:00:00	SPY	ETF	358.14	358.26	355.89	357.091	7339226.0
2020-11-23 11:00:00	SPY	ETF	357.09	357.22	354.865	355.78	7633469.0
2020-11-23 12:00:00	SPY	ETF	355.775	356.66	355.19	356.65	8078293.0
2020-11-23 13:00:00	SPY	ETF	356.655	357.02	356.4	356.76	4046887.0
2020-11-23 14:00:00	SPY	ETF	356.77	357.63	356.22	357.62	4980743.0
2020-11-23 15:00:00	SPY	ETF	357.62	358.37	356.9802	357.47	13394861.0
2020-11-23 16:00:00	SPY	ETF	357.5	357.6	357.26	357.53	10004040.0
2020-11-23 17:00:00	SPY	ETF	357.36	357.8	357.36	357.75	49188.0
2020-11-23 18:00:00	SPY	ETF	357.75	359.64	357.6	359.1	420144.0
2020-11-23 19:00:00	SPY	ETF	359.14	359.41	357.46	359.16	208501.0
2020-11-23 04:00:00	QQQ	ETF	291.65	291.9	291.51	291.68	29543.0
2020-11-23 05:00:00	QQQ	ETF	291.61	291.65	291.43	291.51	19183.0
2020-11-23 06:00:00	QQQ	ETF	291.43	291.5	291.27	291.45	84197.0
2020-11-23 07:00:00	QQQ	ETF	291.45	291.64	291.12	291.56	73465.0
2020-11-23 08:00:00	QQQ	ETF	291.38	291.84	290.7	291.37	320008.0
2020-11-23 09:00:00	QQQ	ETF	291.342	292.75	291.24	292.06	2509639.0
2020-11-23 10:00:00	QQQ	ETF	292.07	292.25	289.59	290.52	4018696.0
2020-11-23 11:00:00	QQQ	ETF	290.52	290.6	288.07	289.0	3944375.0
2020-11-23 12:00:00	QQQ	ETF	288.96	290.1302	288.48	290.11	1543613.0
2020-11-23 13:00:00	QQQ	ETF	290.12	290.61	289.93	290.1199	1376890.0
2020-11-23 14:00:00	QQQ	ETF	290.14	290.87	289.57	290.72	1677673.0
2020-11-23 15:00:00	QQQ	ETF	290.73	291.35	289.97	290.37	3295714.0
2020-11-23 16:00:00	QQQ	ETF	290.36	290.73	290.26	290.7	1876716.0
2020-11-23 17:00:00	QQQ	ETF	290.7	290.7	290.54	290.6	19000.0
2020-11-23 18:00:00	QQQ	ETF	290.6	291.91	290.6	291.578	215087.0
2020-11-23 19:00:00	QQQ	ETF	291.52	291.71	291.37	291.54	96076.0
2020-11-23 04:00:00	IWM	ETF	179.4	179.5	178.92	179.2	29959.0
2020-11-23 05:00:00	IWM	ETF	179.2	179.34	179.18	179.21	3911.0
2020-11-23 06:00:00	IWM	ETF	179.29	179.29	178.96	179.06	32084.0
2020-11-23 07:00:00	IWM	ETF	179.06	179.29	178.56	179.16	135123.0
2020-11-23 08:00:00	IWM	ETF	179.21	179.31	178.3	178.98	287673.0
2020-11-23 09:00:00	IWM	ETF	179.0	179.98	178.85	179.33	2521978.0
2020-11-23 10:00:00	IWM	ETF	179.34	180.29	178.73	180.21	2685767.0
2020-11-23 11:00:00	IWM	ETF	180.215	180.62	179.71	180.565	2177165.0
2020-11-23 12:00:00	IWM	ETF	180.58	180.78	180.15	180.71	1256018.0
2020-11-23 13:00:00	IWM	ETF	180.71	181.1	180.5999	181.06	1984288.0
2020-11-23 14:00:00	IWM	ETF	181.06	181.68	180.745	181.65	1710919.0
2020-11-23 15:00:00	IWM	ETF	181.66	181.99	180.7	180.82	5335664.0
2020-11-23 16:00:00	IWM	ETF	180.81	181.14	180.8	181.09	721319.0
2020-11-23 17:00:00	IWM	ETF	180.82	181.34	180.82	181.3	339090.0
2020-11-23 18:00:00	IWM	ETF	181.3	182.46	180.82	182.06	152420.0
2020-11-23 19:00:00	IWM	ETF	181.99	182.33	181.96	182.3	29474.0
2020-11-23 04:00:00	DIA	ETF	294.59	294.8	294.54	294.54	6500.0
2020-11-23 05:00:00	DIA	ETF	294.65	294.72	294.65	294.72	550.0

> showing 50 of 13,630 rows — these rows as CSV

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