PREVIEW / etf_1hour / 2019-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-18.parquet
  size:    346 KB
  rows:    11,420

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-18 04:00:00	SPY	ETF	319.69	319.87	319.64	319.87	11297.0
2019-12-18 05:00:00	SPY	ETF	319.87	319.89	319.8	319.87	6159.0
2019-12-18 06:00:00	SPY	ETF	319.79	319.79	319.59	319.64	13956.0
2019-12-18 07:00:00	SPY	ETF	319.69	319.82	319.5	319.73	79100.0
2019-12-18 08:00:00	SPY	ETF	319.77	319.88	319.37	319.65	96062.0
2019-12-18 09:00:00	SPY	ETF	319.64	320.2	319.62	319.72	5748684.0
2019-12-18 10:00:00	SPY	ETF	319.73	320.07	319.53	320.0	5716312.0
2019-12-18 11:00:00	SPY	ETF	319.99	320.25	319.79	319.805	4542868.0
2019-12-18 12:00:00	SPY	ETF	319.8099	319.98	319.7604	319.83	2476380.0
2019-12-18 13:00:00	SPY	ETF	319.835	320.015	319.81	320.0	3962659.0
2019-12-18 14:00:00	SPY	ETF	320.01	320.07	319.815	320.035	3607291.0
2019-12-18 15:00:00	SPY	ETF	320.04	320.06	319.53	319.57	13438835.0
2019-12-18 16:00:00	SPY	ETF	319.56	319.89	319.5025	319.85	6414712.0
2019-12-18 17:00:00	SPY	ETF	319.85	319.85	319.71	319.81	57433.0
2019-12-18 18:00:00	SPY	ETF	319.85	319.93	319.79	319.79	72747.0
2019-12-18 19:00:00	SPY	ETF	319.77	320.07	319.75	319.94	53110.0
2019-12-18 04:00:00	QQQ	ETF	209.33	209.48	209.29	209.46	14118.0
2019-12-18 05:00:00	QQQ	ETF	209.49	209.52	209.43	209.47	25250.0
2019-12-18 06:00:00	QQQ	ETF	209.43	209.47	209.32	209.38	6851.0
2019-12-18 07:00:00	QQQ	ETF	209.39	209.5	209.28	209.45	60863.0
2019-12-18 08:00:00	QQQ	ETF	209.44	209.57	209.12	209.38	77973.0
2019-12-18 09:00:00	QQQ	ETF	209.4	209.83	209.39	209.479	1399900.0
2019-12-18 10:00:00	QQQ	ETF	209.47	209.83	209.33	209.78	1614152.0
2019-12-18 11:00:00	QQQ	ETF	209.77	210.13	209.62	209.91	1454076.0
2019-12-18 12:00:00	QQQ	ETF	209.92	210.03	209.8563	209.88	1316270.0
2019-12-18 13:00:00	QQQ	ETF	209.8732	209.96	209.78	209.92	738021.0
2019-12-18 14:00:00	QQQ	ETF	209.92	210.01	209.82	210.0	887677.0
2019-12-18 15:00:00	QQQ	ETF	210.0	210.0	209.43	209.43	3326234.0
2019-12-18 16:00:00	QQQ	ETF	209.42	209.73	209.39	209.73	1653332.0
2019-12-18 17:00:00	QQQ	ETF	209.74	209.76	209.66	209.7	24404.0
2019-12-18 18:00:00	QQQ	ETF	209.75	209.77	209.62	209.62	16399.0
2019-12-18 19:00:00	QQQ	ETF	209.64	209.85	209.61	209.78	37290.0
2019-12-18 04:00:00	IWM	ETF	164.73	164.83	164.73	164.76	59400.0
2019-12-18 05:00:00	IWM	ETF	164.84	164.85	164.8	164.85	3805.0
2019-12-18 06:00:00	IWM	ETF	164.85	164.85	164.77	164.78	8100.0
2019-12-18 07:00:00	IWM	ETF	164.73	164.96	164.73	164.91	12682.0
2019-12-18 08:00:00	IWM	ETF	164.8201	164.97	164.78	164.82	17346.0
2019-12-18 09:00:00	IWM	ETF	164.89	165.12	164.52	164.52	1550868.0
2019-12-18 10:00:00	IWM	ETF	164.52	164.63	164.32	164.5	1362394.0
2019-12-18 11:00:00	IWM	ETF	164.49	164.86	164.435	164.7633	1809369.0
2019-12-18 12:00:00	IWM	ETF	164.78	164.965	164.77	164.9	558024.0
2019-12-18 13:00:00	IWM	ETF	164.91	165.04	164.88	164.9726	713558.0
2019-12-18 14:00:00	IWM	ETF	164.97	165.28	164.95	165.2355	892788.0
2019-12-18 15:00:00	IWM	ETF	165.24	165.245	164.94	165.06	3112769.0
2019-12-18 16:00:00	IWM	ETF	165.05	165.22	164.5936	165.14	1494425.0
2019-12-18 17:00:00	IWM	ETF	165.1	165.15	165.09	165.12	6727.0
2019-12-18 18:00:00	IWM	ETF	165.19	165.19	165.02	165.1	80967.0
2019-12-18 19:00:00	IWM	ETF	165.1	165.25	165.1	165.24	5050.0
2019-12-18 05:00:00	DIA	ETF	283.69	283.69	283.62	283.62	533.0
2019-12-18 07:00:00	DIA	ETF	283.6	283.65	283.6	283.63	3000.0

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

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