PREVIEW / etf_1hour / 2019-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-17.parquet
  size:    348 KB
  rows:    11,504

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
2019-12-17 04:00:00	SPY	ETF	319.72	319.72	319.48	319.61	11500.0
2019-12-17 05:00:00	SPY	ETF	319.6	319.65	319.16	319.4	5740.0
2019-12-17 06:00:00	SPY	ETF	319.3	319.55	319.17	319.5	20048.0
2019-12-17 07:00:00	SPY	ETF	319.56	319.83	319.53	319.67	38483.0
2019-12-17 08:00:00	SPY	ETF	319.59	320.25	319.5	320.06	302711.0
2019-12-17 09:00:00	SPY	ETF	320.02	320.25	319.53	319.58	4686798.0
2019-12-17 10:00:00	SPY	ETF	319.59	320.12	319.53	319.7	6120335.0
2019-12-17 11:00:00	SPY	ETF	319.71	319.9599	319.6199	319.91	3931009.0
2019-12-17 12:00:00	SPY	ETF	319.905	320.07	319.88	320.02	6615830.0
2019-12-17 13:00:00	SPY	ETF	320.02	320.025	319.51	319.89	3718954.0
2019-12-17 14:00:00	SPY	ETF	319.89	319.9862	319.67	319.84	7938448.0
2019-12-17 15:00:00	SPY	ETF	319.83	319.94	319.48	319.56	13905417.0
2019-12-17 16:00:00	SPY	ETF	319.55	319.6204	319.24	319.36	10036731.0
2019-12-17 17:00:00	SPY	ETF	319.39	319.57	319.19	319.28	2539156.0
2019-12-17 18:00:00	SPY	ETF	319.3	319.49	319.29	319.42	51807.0
2019-12-17 19:00:00	SPY	ETF	319.43	319.48	319.38	319.38	15602.0
2019-12-17 04:00:00	QQQ	ETF	209.41	209.41	209.18	209.33	14943.0
2019-12-17 05:00:00	QQQ	ETF	209.33	209.37	209.1	209.17	17211.0
2019-12-17 06:00:00	QQQ	ETF	209.17	209.22	209.0	209.17	24763.0
2019-12-17 07:00:00	QQQ	ETF	209.19	209.38	209.19	209.25	36870.0
2019-12-17 08:00:00	QQQ	ETF	209.3	209.74	209.1	209.53	104102.0
2019-12-17 09:00:00	QQQ	ETF	209.46	209.71	209.04	209.07	2137448.0
2019-12-17 10:00:00	QQQ	ETF	209.07	209.46	209.04	209.17	1528940.0
2019-12-17 11:00:00	QQQ	ETF	209.18	209.36	209.13	209.24	1015265.0
2019-12-17 12:00:00	QQQ	ETF	209.255	209.3937	209.23	209.35	679585.0
2019-12-17 13:00:00	QQQ	ETF	209.36	209.41	209.15	209.375	837527.0
2019-12-17 14:00:00	QQQ	ETF	209.38	209.44	209.17	209.34	894176.0
2019-12-17 15:00:00	QQQ	ETF	209.33	209.41	209.19	209.29	2843408.0
2019-12-17 16:00:00	QQQ	ETF	209.26	209.39	209.11	209.23	555260.0
2019-12-17 17:00:00	QQQ	ETF	209.26	209.26	209.1	209.1	516465.0
2019-12-17 18:00:00	QQQ	ETF	209.13	209.27	209.12	209.22	32512.0
2019-12-17 19:00:00	QQQ	ETF	209.23	209.29	209.19	209.23	14184.0
2019-12-17 04:00:00	IWM	ETF	163.84	163.84	163.77	163.77	1900.0
2019-12-17 05:00:00	IWM	ETF	163.85	163.85	163.79	163.79	7610.0
2019-12-17 06:00:00	IWM	ETF	163.61	163.8	163.61	163.8	10680.0
2019-12-17 07:00:00	IWM	ETF	163.81	164.0	163.81	164.0	12370.0
2019-12-17 08:00:00	IWM	ETF	163.785	164.26	163.785	164.07	19502.0
2019-12-17 09:00:00	IWM	ETF	164.12	164.23	163.695	163.78	1589241.0
2019-12-17 10:00:00	IWM	ETF	163.78	164.12	163.74	163.855	1500437.0
2019-12-17 11:00:00	IWM	ETF	163.86	164.075	163.783	164.07	1015997.0
2019-12-17 12:00:00	IWM	ETF	164.06	164.37	164.03	164.37	724764.0
2019-12-17 13:00:00	IWM	ETF	164.37	164.43	164.25	164.4	789912.0
2019-12-17 14:00:00	IWM	ETF	164.4	164.53	164.285	164.51	998082.0
2019-12-17 15:00:00	IWM	ETF	164.5	164.68	164.36	164.64	2176007.0
2019-12-17 16:00:00	IWM	ETF	164.7	164.7	163.8333	164.56	515354.0
2019-12-17 17:00:00	IWM	ETF	164.51	164.5999	164.47	164.58	3614.0
2019-12-17 18:00:00	IWM	ETF	164.59	164.6	164.59	164.59	2550.0
2019-12-17 19:00:00	IWM	ETF	164.55	164.56	164.54	164.56	7978.0
2019-12-17 04:00:00	DIA	ETF	282.91	282.91	282.88	282.88	1000.0
2019-12-17 07:00:00	DIA	ETF	282.88	282.88	282.68	282.82	5100.0

> showing 50 of 11,504 rows — these rows as CSV

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