PREVIEW / etf_1hour / 2019-12-09

all etf 1-hour files

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

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-09 04:00:00	SPY	ETF	314.56	314.63	314.3	314.59	7689.0
2019-12-09 05:00:00	SPY	ETF	314.53	314.75	314.51	314.75	6622.0
2019-12-09 06:00:00	SPY	ETF	314.7	314.7	314.4	314.41	6684.0
2019-12-09 07:00:00	SPY	ETF	314.44	314.71	314.44	314.6	40088.0
2019-12-09 08:00:00	SPY	ETF	314.6	314.7	314.38	314.53	96206.0
2019-12-09 09:00:00	SPY	ETF	314.49	315.12	314.38	314.95	3210585.0
2019-12-09 10:00:00	SPY	ETF	314.96	315.18	314.86	315.0198	3565392.0
2019-12-09 11:00:00	SPY	ETF	315.02	315.02	314.56	314.59	3520905.0
2019-12-09 12:00:00	SPY	ETF	314.59	314.71	314.325	314.525	3237334.0
2019-12-09 13:00:00	SPY	ETF	314.525	314.575	314.31	314.4339	3116942.0
2019-12-09 14:00:00	SPY	ETF	314.4367	314.46	313.94	314.3	5179862.0
2019-12-09 15:00:00	SPY	ETF	314.31	314.45	313.8	313.87	7585188.0
2019-12-09 16:00:00	SPY	ETF	313.88	313.9	313.39	313.53	4173660.0
2019-12-09 17:00:00	SPY	ETF	313.5	313.58	313.44	313.55	95656.0
2019-12-09 18:00:00	SPY	ETF	313.55	313.79	313.55	313.64	77334.0
2019-12-09 19:00:00	SPY	ETF	313.75	313.84	313.58	313.65	33532.0
2019-12-09 04:00:00	QQQ	ETF	204.74	204.74	204.55	204.7	10423.0
2019-12-09 05:00:00	QQQ	ETF	204.74	204.86	204.65	204.83	17204.0
2019-12-09 06:00:00	QQQ	ETF	204.84	204.85	204.59	204.67	16860.0
2019-12-09 07:00:00	QQQ	ETF	204.67	204.85	204.66	204.77	21975.0
2019-12-09 08:00:00	QQQ	ETF	204.77	204.8	204.57	204.63	68107.0
2019-12-09 09:00:00	QQQ	ETF	204.64	205.5937	204.51	205.39	1691011.0
2019-12-09 10:00:00	QQQ	ETF	205.395	205.52	205.1231	205.24	1277458.0
2019-12-09 11:00:00	QQQ	ETF	205.245	205.25	204.72	204.8	1161612.0
2019-12-09 12:00:00	QQQ	ETF	204.81	204.9	204.55	204.69	1195989.0
2019-12-09 13:00:00	QQQ	ETF	204.69	204.78	204.58	204.65	524012.0
2019-12-09 14:00:00	QQQ	ETF	204.655	204.68	204.24	204.46	1008842.0
2019-12-09 15:00:00	QQQ	ETF	204.47	204.58	203.98	204.04	2318817.0
2019-12-09 16:00:00	QQQ	ETF	204.04	204.08	203.63	203.73	1202168.0
2019-12-09 17:00:00	QQQ	ETF	203.65	203.77	203.65	203.7	16170.0
2019-12-09 18:00:00	QQQ	ETF	203.75	203.95	203.74	203.94	35639.0
2019-12-09 19:00:00	QQQ	ETF	203.93	203.96	203.8	203.83	17195.0
2019-12-09 04:00:00	IWM	ETF	162.5	162.6	162.5	162.6	4670.0
2019-12-09 05:00:00	IWM	ETF	162.66	162.67	162.62	162.63	12666.0
2019-12-09 06:00:00	IWM	ETF	162.7	162.7	162.61	162.65	7000.0
2019-12-09 07:00:00	IWM	ETF	162.58	162.74	162.58	162.71	7500.0
2019-12-09 08:00:00	IWM	ETF	162.71	162.74	162.64	162.66	37054.0
2019-12-09 09:00:00	IWM	ETF	162.6	163.07	162.6	162.87	1287815.0
2019-12-09 10:00:00	IWM	ETF	162.86	163.155	162.86	163.05	1005624.0
2019-12-09 11:00:00	IWM	ETF	163.07	163.08	162.725	162.73	809435.0
2019-12-09 12:00:00	IWM	ETF	162.74	162.98	162.68	162.8	793472.0
2019-12-09 13:00:00	IWM	ETF	162.805	162.82	162.63	162.77	440802.0
2019-12-09 14:00:00	IWM	ETF	162.77	162.775	162.48	162.691	804858.0
2019-12-09 15:00:00	IWM	ETF	162.7099	162.75	162.39	162.48	2158601.0
2019-12-09 16:00:00	IWM	ETF	162.51	162.51	162.25	162.28	1182097.0
2019-12-09 17:00:00	IWM	ETF	162.36	162.51	162.26	162.51	34509.0
2019-12-09 18:00:00	IWM	ETF	162.4	162.43	162.35	162.43	3200.0
2019-12-09 19:00:00	IWM	ETF	162.46	162.5	162.46	162.5	1200.0
2019-12-09 04:00:00	DIA	ETF	280.49	280.49	280.21	280.36	10300.0
2019-12-09 05:00:00	DIA	ETF	280.59	280.59	280.58	280.58	211.0

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

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