PREVIEW / etf_1hour / 2021-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-11.parquet
  size:    429 KB
  rows:    14,691

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-11 04:00:00	SPY	ETF	379.47	379.6	378.84	378.84	49272.0
2021-01-11 05:00:00	SPY	ETF	378.8	379.53	378.79	379.48	27839.0
2021-01-11 06:00:00	SPY	ETF	379.53	379.63	379.02	379.42	18183.0
2021-01-11 07:00:00	SPY	ETF	379.47	379.57	378.72	379.25	301143.0
2021-01-11 08:00:00	SPY	ETF	379.19	379.81	377.76	377.91	700380.0
2021-01-11 09:00:00	SPY	ETF	377.89	379.3	377.25	379.09	8703445.0
2021-01-11 10:00:00	SPY	ETF	379.1	379.89	378.84	379.5232	5702450.0
2021-01-11 11:00:00	SPY	ETF	379.52	379.97	378.58	379.8169	4796909.0
2021-01-11 12:00:00	SPY	ETF	379.82	380.58	379.71	380.24	3360000.0
2021-01-11 13:00:00	SPY	ETF	380.249	380.48	378.78	379.24	4215113.0
2021-01-11 14:00:00	SPY	ETF	379.24	379.6	378.3101	379.52	5251409.0
2021-01-11 15:00:00	SPY	ETF	379.53	379.64	378.12	378.74	12933218.0
2021-01-11 16:00:00	SPY	ETF	378.77	379.4	378.49	378.75	3739805.0
2021-01-11 17:00:00	SPY	ETF	378.69	379.0	378.68	378.94	149222.0
2021-01-11 18:00:00	SPY	ETF	379.03	379.4	378.71	379.27	114844.0
2021-01-11 19:00:00	SPY	ETF	379.18	379.95	379.0	379.74	101823.0
2021-01-11 04:00:00	QQQ	ETF	318.29	318.29	317.65	317.65	57995.0
2021-01-11 05:00:00	QQQ	ETF	317.58	318.07	317.4	317.98	46573.0
2021-01-11 06:00:00	QQQ	ETF	318.03	318.19	317.77	317.95	28401.0
2021-01-11 07:00:00	QQQ	ETF	317.97	317.97	316.95	317.58	173069.0
2021-01-11 08:00:00	QQQ	ETF	317.5	318.21	316.15	316.35	411444.0
2021-01-11 09:00:00	QQQ	ETF	316.36	316.48	314.245	315.87	5151119.0
2021-01-11 10:00:00	QQQ	ETF	315.88	316.96	315.475	316.27	4020144.0
2021-01-11 11:00:00	QQQ	ETF	316.27	316.58	315.205	316.48	1920573.0
2021-01-11 12:00:00	QQQ	ETF	316.47	317.19	316.31	316.7399	1291661.0
2021-01-11 13:00:00	QQQ	ETF	316.75	317.065	315.47	315.88	1808138.0
2021-01-11 14:00:00	QQQ	ETF	315.87	315.88	314.63	315.42	2842048.0
2021-01-11 15:00:00	QQQ	ETF	315.43	315.45	313.75	314.31	6397380.0
2021-01-11 16:00:00	QQQ	ETF	314.3	314.93	314.19	314.52	1280118.0
2021-01-11 17:00:00	QQQ	ETF	314.64	314.85	314.52	314.82	32916.0
2021-01-11 18:00:00	QQQ	ETF	314.75	315.09	314.43	314.95	85523.0
2021-01-11 19:00:00	QQQ	ETF	314.92	315.47	314.79	315.35	68943.0
2021-01-11 04:00:00	IWM	ETF	205.88	206.1	205.4	205.41	19545.0
2021-01-11 05:00:00	IWM	ETF	205.44	206.3	205.44	206.24	8047.0
2021-01-11 06:00:00	IWM	ETF	206.1	206.25	205.8	206.07	12018.0
2021-01-11 07:00:00	IWM	ETF	206.13	206.3	205.61	205.768	165933.0
2021-01-11 08:00:00	IWM	ETF	205.76	206.2696	204.95	204.95	229371.0
2021-01-11 09:00:00	IWM	ETF	205.0	207.05	204.33	206.8	3265342.0
2021-01-11 10:00:00	IWM	ETF	206.77	207.69	206.7	207.28	2455663.0
2021-01-11 11:00:00	IWM	ETF	207.26	207.405	206.01	207.33	1546115.0
2021-01-11 12:00:00	IWM	ETF	207.37	208.12	207.06	207.79	1182081.0
2021-01-11 13:00:00	IWM	ETF	207.78	208.09	207.09	207.49	1231472.0
2021-01-11 14:00:00	IWM	ETF	207.48	207.74	206.865	207.48	1662851.0
2021-01-11 15:00:00	IWM	ETF	207.49	207.79	206.81	207.51	3515126.0
2021-01-11 16:00:00	IWM	ETF	207.54	208.0	207.43	207.61	1053558.0
2021-01-11 17:00:00	IWM	ETF	207.56	207.78	207.54	207.6	9086.0
2021-01-11 18:00:00	IWM	ETF	207.73	208.18	207.54	208.07	28112.0
2021-01-11 19:00:00	IWM	ETF	208.02	208.94	207.91	208.7	40440.0
2021-01-11 04:00:00	DIA	ETF	309.6	309.6	309.33	309.46	3800.0
2021-01-11 05:00:00	DIA	ETF	309.05	309.42	309.05	309.37	2400.0

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

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