PREVIEW / etf_1hour / 2021-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-29.parquet
  size:    429 KB
  rows:    15,006

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-29 04:00:00	SPY	ETF	373.96	374.79	373.24	373.74	127844.0
2021-01-29 05:00:00	SPY	ETF	373.47	374.26	372.85	374.18	65827.0
2021-01-29 06:00:00	SPY	ETF	374.18	376.1	373.62	375.24	400982.0
2021-01-29 07:00:00	SPY	ETF	375.28	375.89	374.26	374.53	508577.0
2021-01-29 08:00:00	SPY	ETF	374.45	377.07	372.31	376.13	3724452.0
2021-01-29 09:00:00	SPY	ETF	376.12	376.5	373.15	375.18	9670025.0
2021-01-29 10:00:00	SPY	ETF	375.19	376.67	374.44	375.55	8376789.0
2021-01-29 11:00:00	SPY	ETF	375.55	375.8599	371.7711	373.0201	10233180.0
2021-01-29 12:00:00	SPY	ETF	373.02	373.24	368.56	369.26	14550943.0
2021-01-29 13:00:00	SPY	ETF	369.25	371.16	368.27	369.79	11473792.0
2021-01-29 14:00:00	SPY	ETF	369.79	371.71	369.68	370.79	10238000.0
2021-01-29 15:00:00	SPY	ETF	370.78	373.18	369.94	370.19	27282121.0
2021-01-29 16:00:00	SPY	ETF	370.19	371.56	369.29	369.4	9110711.0
2021-01-29 17:00:00	SPY	ETF	369.5	370.07	369.36	369.7001	276999.0
2021-01-29 18:00:00	SPY	ETF	369.75	369.85	369.32	369.7	62655.0
2021-01-29 19:00:00	SPY	ETF	369.79	369.79	369.0	369.45	65031.0
2021-01-29 04:00:00	QQQ	ETF	317.43	317.94	316.38	316.8	102941.0
2021-01-29 05:00:00	QQQ	ETF	316.46	317.96	315.44	317.88	95814.0
2021-01-29 06:00:00	QQQ	ETF	317.83	319.18	317.16	318.49	176846.0
2021-01-29 07:00:00	QQQ	ETF	318.46	319.31	317.81	318.0	407943.0
2021-01-29 08:00:00	QQQ	ETF	318.0	321.32	316.63	320.0998	1207260.0
2021-01-29 09:00:00	QQQ	ETF	320.04	320.22	316.85	318.9	4904068.0
2021-01-29 10:00:00	QQQ	ETF	318.93	320.7193	317.47	319.45	4714002.0
2021-01-29 11:00:00	QQQ	ETF	319.47	319.85	315.98	317.62	4666377.0
2021-01-29 12:00:00	QQQ	ETF	317.53	317.97	312.76	313.4	7334508.0
2021-01-29 13:00:00	QQQ	ETF	313.37	315.68	312.81	314.17	4887499.0
2021-01-29 14:00:00	QQQ	ETF	314.17	315.83	313.75	314.72	3607274.0
2021-01-29 15:00:00	QQQ	ETF	314.74	317.35	314.46	314.73	7399745.0
2021-01-29 16:00:00	QQQ	ETF	314.71	316.15	313.56	313.76	2003528.0
2021-01-29 17:00:00	QQQ	ETF	314.1	314.71	313.77	313.9	87043.0
2021-01-29 18:00:00	QQQ	ETF	313.9	314.0	313.3	313.75	23671.0
2021-01-29 19:00:00	QQQ	ETF	313.83	314.71	313.16	313.69	47648.0
2021-01-29 04:00:00	IWM	ETF	208.05	209.14	207.83	208.25	22697.0
2021-01-29 05:00:00	IWM	ETF	208.0	208.0	207.4	208.0	25427.0
2021-01-29 06:00:00	IWM	ETF	208.05	209.81	207.54	208.88	126358.0
2021-01-29 07:00:00	IWM	ETF	209.07	209.12	208.15	208.25	210157.0
2021-01-29 08:00:00	IWM	ETF	208.89	210.43	205.04	209.56	1417239.0
2021-01-29 09:00:00	IWM	ETF	209.55	210.38	208.09	210.01	4098955.0
2021-01-29 10:00:00	IWM	ETF	210.015	210.99	209.43	210.86	3180389.0
2021-01-29 11:00:00	IWM	ETF	210.86	210.88	207.57	208.93	3272273.0
2021-01-29 12:00:00	IWM	ETF	208.93	209.54	204.84	205.76	4010681.0
2021-01-29 13:00:00	IWM	ETF	205.75	207.14	204.95	205.56	2930314.0
2021-01-29 14:00:00	IWM	ETF	205.57	207.0	204.97	205.28	3141360.0
2021-01-29 15:00:00	IWM	ETF	205.27	207.37	205.23	205.59	6816295.0
2021-01-29 16:00:00	IWM	ETF	205.56	206.33	204.92	205.01	3648485.0
2021-01-29 17:00:00	IWM	ETF	205.01	205.76	204.92	204.92	226099.0
2021-01-29 18:00:00	IWM	ETF	205.01	205.1799	203.25	205.0	8066.0
2021-01-29 19:00:00	IWM	ETF	204.88	204.88	204.72	204.72	856.0
2021-01-29 04:00:00	DIA	ETF	303.59	303.95	303.25	303.55	1770.0
2021-01-29 05:00:00	DIA	ETF	303.17	303.65	303.17	303.65	1455.0

> showing 50 of 15,006 rows — these rows as CSV

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