PREVIEW / etf_1hour / 2019-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-11.parquet
  size:    341 KB
  rows:    11,149

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-11 04:00:00	SPY	ETF	313.5	313.77	313.5	313.7	4381.0
2019-12-11 05:00:00	SPY	ETF	313.8	313.85	313.52	313.7	11288.0
2019-12-11 06:00:00	SPY	ETF	313.76	313.95	313.6	313.95	10880.0
2019-12-11 07:00:00	SPY	ETF	313.99	314.16	313.87	314.13	172970.0
2019-12-11 08:00:00	SPY	ETF	314.11	314.5	313.64	314.27	176661.0
2019-12-11 09:00:00	SPY	ETF	314.25	314.44	313.7	314.44	3431957.0
2019-12-11 10:00:00	SPY	ETF	314.43	314.55	313.83	313.8681	5780783.0
2019-12-11 11:00:00	SPY	ETF	313.85	314.08	313.62	313.75	4284509.0
2019-12-11 12:00:00	SPY	ETF	313.74	313.85	313.61	313.8	3497759.0
2019-12-11 13:00:00	SPY	ETF	313.79	313.91	313.595	313.88	3488546.0
2019-12-11 14:00:00	SPY	ETF	313.87	314.66	313.7	314.63	8988720.0
2019-12-11 15:00:00	SPY	ETF	314.64	314.7	314.09	314.41	11796766.0
2019-12-11 16:00:00	SPY	ETF	314.4	314.65	313.5312	314.63	6568801.0
2019-12-11 17:00:00	SPY	ETF	314.63	314.68	314.5	314.66	319895.0
2019-12-11 18:00:00	SPY	ETF	314.64	314.85	314.6	314.84	63716.0
2019-12-11 19:00:00	SPY	ETF	314.8	314.8	314.57	314.65	58328.0
2019-12-11 04:00:00	QQQ	ETF	204.03	204.12	203.91	204.02	2537.0
2019-12-11 05:00:00	QQQ	ETF	204.11	204.17	203.91	203.95	2600.0
2019-12-11 06:00:00	QQQ	ETF	204.09	204.28	204.0	204.28	17331.0
2019-12-11 07:00:00	QQQ	ETF	204.29	204.46	204.2	204.42	37585.0
2019-12-11 08:00:00	QQQ	ETF	204.33	204.6	203.94	204.54	330394.0
2019-12-11 09:00:00	QQQ	ETF	204.54	204.67	204.04	204.67	1177466.0
2019-12-11 10:00:00	QQQ	ETF	204.67	204.84	204.39	204.42	1159132.0
2019-12-11 11:00:00	QQQ	ETF	204.41	204.62	204.21	204.38	1182185.0
2019-12-11 12:00:00	QQQ	ETF	204.37	204.45	204.225	204.38	710099.0
2019-12-11 13:00:00	QQQ	ETF	204.371	204.52	204.31	204.51	978336.0
2019-12-11 14:00:00	QQQ	ETF	204.5	205.11	204.35	205.1	2361104.0
2019-12-11 15:00:00	QQQ	ETF	205.1	205.19	204.785	205.04	3213349.0
2019-12-11 16:00:00	QQQ	ETF	205.01	205.12	204.94	205.11	3288769.0
2019-12-11 17:00:00	QQQ	ETF	205.06	205.1	204.95	205.07	80075.0
2019-12-11 18:00:00	QQQ	ETF	205.09	205.27	205.04	205.26	163000.0
2019-12-11 19:00:00	QQQ	ETF	205.27	205.27	205.04	205.13	48117.0
2019-12-11 04:00:00	IWM	ETF	162.67	162.67	162.67	162.67	275.0
2019-12-11 05:00:00	IWM	ETF	162.68	162.68	162.68	162.68	800.0
2019-12-11 06:00:00	IWM	ETF	162.6	162.74	162.6	162.74	2350.0
2019-12-11 07:00:00	IWM	ETF	162.76	162.84	162.76	162.84	6000.0
2019-12-11 08:00:00	IWM	ETF	162.75	163.0	162.72	162.91	29064.0
2019-12-11 09:00:00	IWM	ETF	162.95	163.01	162.57	162.86	676610.0
2019-12-11 10:00:00	IWM	ETF	162.87	163.08	162.15	162.165	1286380.0
2019-12-11 11:00:00	IWM	ETF	162.16	162.415	161.95	162.25	932891.0
2019-12-11 12:00:00	IWM	ETF	162.25	162.345	162.19	162.28	632695.0
2019-12-11 13:00:00	IWM	ETF	162.28	162.5	162.22	162.466	621099.0
2019-12-11 14:00:00	IWM	ETF	162.46	162.79	162.38	162.78	1312541.0
2019-12-11 15:00:00	IWM	ETF	162.7809	162.81	162.39	162.57	3730240.0
2019-12-11 16:00:00	IWM	ETF	162.56	162.94	162.52	162.86	3759060.0
2019-12-11 17:00:00	IWM	ETF	162.88	162.92	162.81	162.82	16823.0
2019-12-11 18:00:00	IWM	ETF	162.84	162.96	162.81	162.94	6434.0
2019-12-11 19:00:00	IWM	ETF	162.88	162.9	162.81	162.86	14650.0
2019-12-11 07:00:00	DIA	ETF	279.46	279.46	279.46	279.46	300.0
2019-12-11 08:00:00	DIA	ETF	279.44	279.6399	279.42	279.42	5341.0

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

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