PREVIEW / etf_1hour / 2019-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-16.parquet
  size:    358 KB
  rows:    11,713

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-16 04:00:00	SPY	ETF	318.41	318.6	318.4	318.54	60710.0
2019-12-16 05:00:00	SPY	ETF	318.55	318.61	318.36	318.46	41466.0
2019-12-16 06:00:00	SPY	ETF	318.48	318.8	318.48	318.61	38754.0
2019-12-16 07:00:00	SPY	ETF	318.61	318.95	318.61	318.92	153370.0
2019-12-16 08:00:00	SPY	ETF	318.95	319.29	318.3	319.26	315633.0
2019-12-16 09:00:00	SPY	ETF	319.22	319.72	319.17	319.4	9181917.0
2019-12-16 10:00:00	SPY	ETF	319.41	320.06	319.39	319.885	12377357.0
2019-12-16 11:00:00	SPY	ETF	319.88	320.05	319.74	320.001	10323507.0
2019-12-16 12:00:00	SPY	ETF	320.005	320.15	319.955	319.98	6767081.0
2019-12-16 13:00:00	SPY	ETF	319.975	320.12	319.85	320.05	5346435.0
2019-12-16 14:00:00	SPY	ETF	320.05	320.14	319.62	319.685	4825333.0
2019-12-16 15:00:00	SPY	ETF	319.68	319.9	319.49	319.51	14469011.0
2019-12-16 16:00:00	SPY	ETF	319.51	319.87	319.44	319.67	13012701.0
2019-12-16 17:00:00	SPY	ETF	319.73	319.73	319.5	319.63	1086602.0
2019-12-16 18:00:00	SPY	ETF	319.61	319.66	319.39	319.39	57673.0
2019-12-16 19:00:00	SPY	ETF	319.4	319.41	319.25	319.34	51859.0
2019-12-16 04:00:00	QQQ	ETF	207.61	208.09	207.61	208.08	29565.0
2019-12-16 05:00:00	QQQ	ETF	208.05	208.06	207.9	207.97	18415.0
2019-12-16 06:00:00	QQQ	ETF	207.99	208.16	207.99	208.08	14523.0
2019-12-16 07:00:00	QQQ	ETF	208.1	208.35	208.07	208.33	88281.0
2019-12-16 08:00:00	QQQ	ETF	208.09	208.52	207.87	208.49	135790.0
2019-12-16 09:00:00	QQQ	ETF	208.5	209.2537	208.48	209.06	3384720.0
2019-12-16 10:00:00	QQQ	ETF	209.07	209.51	209.01	209.38	2287628.0
2019-12-16 11:00:00	QQQ	ETF	209.38	209.46	209.2299	209.3801	1653957.0
2019-12-16 12:00:00	QQQ	ETF	209.3877	209.53	209.35	209.4	1442495.0
2019-12-16 13:00:00	QQQ	ETF	209.4033	209.5	209.29	209.47	901292.0
2019-12-16 14:00:00	QQQ	ETF	209.4653	209.52	209.23	209.28	846821.0
2019-12-16 15:00:00	QQQ	ETF	209.27	209.44	209.14	209.16	3319605.0
2019-12-16 16:00:00	QQQ	ETF	209.15	209.4	209.13	209.32	2263209.0
2019-12-16 17:00:00	QQQ	ETF	209.3	209.37	209.27	209.34	53399.0
2019-12-16 18:00:00	QQQ	ETF	209.28	209.29	209.11	209.13	47322.0
2019-12-16 19:00:00	QQQ	ETF	209.12	209.12	208.97	209.03	36257.0
2019-12-16 04:00:00	IWM	ETF	163.7	163.7	163.42	163.58	6328.0
2019-12-16 05:00:00	IWM	ETF	163.56	163.57	163.54	163.54	1000.0
2019-12-16 06:00:00	IWM	ETF	163.75	163.78	163.73	163.78	9848.0
2019-12-16 07:00:00	IWM	ETF	163.73	163.91	163.73	163.88	16350.0
2019-12-16 08:00:00	IWM	ETF	163.73	164.18	163.33	164.18	487096.0
2019-12-16 09:00:00	IWM	ETF	164.19	164.43	163.33	163.895	2464491.0
2019-12-16 10:00:00	IWM	ETF	163.91	164.82	163.89	164.555	2516454.0
2019-12-16 11:00:00	IWM	ETF	164.55	164.845	164.5	164.645	1408467.0
2019-12-16 12:00:00	IWM	ETF	164.64	164.78	164.59	164.655	797014.0
2019-12-16 13:00:00	IWM	ETF	164.66	164.66	164.49	164.52	802077.0
2019-12-16 14:00:00	IWM	ETF	164.515	164.55	164.115	164.16	1098243.0
2019-12-16 15:00:00	IWM	ETF	164.16	164.185	163.735	163.84	3624433.0
2019-12-16 16:00:00	IWM	ETF	163.84	164.15	163.79	164.01	2498486.0
2019-12-16 17:00:00	IWM	ETF	163.88	164.05	163.88	163.88	261843.0
2019-12-16 18:00:00	IWM	ETF	163.96	164.04	163.88	163.88	5484.0
2019-12-16 19:00:00	IWM	ETF	163.85	163.85	163.76	163.76	6349.0
2019-12-16 04:00:00	DIA	ETF	282.58	282.58	282.58	282.58	100.0
2019-12-16 06:00:00	DIA	ETF	282.83	282.83	282.83	282.83	239.0

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

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