PREVIEW / etf_1hour / 2021-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-08.parquet
  size:    424 KB
  rows:    14,638

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-08 04:00:00	SPY	ETF	380.2	380.23	379.47	380.16	40315.0
2021-01-08 05:00:00	SPY	ETF	380.19	380.45	379.96	380.08	15497.0
2021-01-08 06:00:00	SPY	ETF	380.05	380.59	379.9	380.18	25718.0
2021-01-08 07:00:00	SPY	ETF	380.16	380.59	380.1	380.22	109953.0
2021-01-08 08:00:00	SPY	ETF	380.22	380.9	379.7	380.05	569829.0
2021-01-08 09:00:00	SPY	ETF	380.09	381.215	380.05	380.51	5625591.0
2021-01-08 10:00:00	SPY	ETF	380.54	381.04	378.84	380.55	8021343.0
2021-01-08 11:00:00	SPY	ETF	380.55	380.84	379.55	380.24	6454073.0
2021-01-08 12:00:00	SPY	ETF	380.24	380.67	379.59	379.77	3511385.0
2021-01-08 13:00:00	SPY	ETF	379.75	379.9	377.1	378.24	9272775.0
2021-01-08 14:00:00	SPY	ETF	378.24	380.08	378.17	379.99	9528284.0
2021-01-08 15:00:00	SPY	ETF	379.99	381.49	379.94	381.24	17873779.0
2021-01-08 16:00:00	SPY	ETF	381.24	381.96	381.2035	381.7	7473287.0
2021-01-08 17:00:00	SPY	ETF	381.75	381.91	381.68	381.71	108596.0
2021-01-08 18:00:00	SPY	ETF	381.68	381.95	381.6	381.6	29120.0
2021-01-08 19:00:00	SPY	ETF	381.8	381.8	381.6	381.6	24135.0
2021-01-08 04:00:00	QQQ	ETF	316.11	316.33	315.69	316.22	47912.0
2021-01-08 05:00:00	QQQ	ETF	316.4	316.43	316.15	316.25	28772.0
2021-01-08 06:00:00	QQQ	ETF	316.22	316.63	316.15	316.36	44970.0
2021-01-08 07:00:00	QQQ	ETF	316.32	316.96	316.29	316.71	201484.0
2021-01-08 08:00:00	QQQ	ETF	316.7	317.19	315.95	316.7504	284423.0
2021-01-08 09:00:00	QQQ	ETF	316.8	318.12	316.53	317.27	4441096.0
2021-01-08 10:00:00	QQQ	ETF	317.35	318.19	315.73	317.63	4201217.0
2021-01-08 11:00:00	QQQ	ETF	317.68	318.27	316.85	317.66	2569880.0
2021-01-08 12:00:00	QQQ	ETF	317.69	318.45	317.08	317.66	1786618.0
2021-01-08 13:00:00	QQQ	ETF	317.66	317.86	315.0814	316.58	3916683.0
2021-01-08 14:00:00	QQQ	ETF	316.56	318.02	316.515	317.9	2877248.0
2021-01-08 15:00:00	QQQ	ETF	317.91	319.39	317.7501	319.09	5674292.0
2021-01-08 16:00:00	QQQ	ETF	319.07	319.83	319.01	319.81	1107538.0
2021-01-08 17:00:00	QQQ	ETF	319.68	319.7699	319.38	319.38	35600.0
2021-01-08 18:00:00	QQQ	ETF	319.38	319.59	319.35	319.45	15776.0
2021-01-08 19:00:00	QQQ	ETF	319.44	319.46	319.24	319.24	17226.0
2021-01-08 04:00:00	IWM	ETF	208.89	208.89	207.94	208.49	13170.0
2021-01-08 05:00:00	IWM	ETF	208.7	209.11	208.68	209.0	22700.0
2021-01-08 06:00:00	IWM	ETF	208.97	209.21	208.75	208.96	3991.0
2021-01-08 07:00:00	IWM	ETF	208.89	209.23	208.69	208.75	51367.0
2021-01-08 08:00:00	IWM	ETF	208.76	209.49	208.45	208.72	160056.0
2021-01-08 09:00:00	IWM	ETF	208.81	209.49	208.15	209.32	2463308.0
2021-01-08 10:00:00	IWM	ETF	209.34	209.77	207.59	208.88	3072466.0
2021-01-08 11:00:00	IWM	ETF	208.895	209.09	207.65	208.15	2152419.0
2021-01-08 12:00:00	IWM	ETF	208.15	208.41	207.27	207.36	1709919.0
2021-01-08 13:00:00	IWM	ETF	207.37	207.48	204.6581	205.2	3853184.0
2021-01-08 14:00:00	IWM	ETF	205.18	207.01	205.14	206.61	4078780.0
2021-01-08 15:00:00	IWM	ETF	206.6	207.925	206.58	207.69	5314442.0
2021-01-08 16:00:00	IWM	ETF	207.72	208.02	206.9694	207.98	1274451.0
2021-01-08 17:00:00	IWM	ETF	207.98	208.09	207.81	207.82	83665.0
2021-01-08 18:00:00	IWM	ETF	207.98	208.07	207.9	208.05	1364.0
2021-01-08 19:00:00	IWM	ETF	207.98	208.15	207.84	208.15	11161.0
2021-01-08 04:00:00	DIA	ETF	310.98	311.51	310.98	311.37	400.0
2021-01-08 05:00:00	DIA	ETF	311.49	311.49	311.29	311.29	400.0

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

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