PREVIEW / etf_1hour / 2019-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-10.parquet
  size:    340 KB
  rows:    11,208

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-10 04:00:00	SPY	ETF	312.77	312.77	312.43	312.57	10104.0
2019-12-10 05:00:00	SPY	ETF	312.56	312.98	312.56	312.82	36174.0
2019-12-10 06:00:00	SPY	ETF	312.82	312.82	311.92	312.74	50012.0
2019-12-10 07:00:00	SPY	ETF	312.74	312.84	312.52	312.6	111808.0
2019-12-10 08:00:00	SPY	ETF	312.63	314.45	312.49	314.03	1742836.0
2019-12-10 09:00:00	SPY	ETF	314.04	314.1	312.81	313.5	7574053.0
2019-12-10 10:00:00	SPY	ETF	313.5	314.44	313.43	314.31	6754759.0
2019-12-10 11:00:00	SPY	ETF	314.31	314.55	313.58	313.995	5613422.0
2019-12-10 12:00:00	SPY	ETF	313.99	314.0384	313.55	313.94	4695371.0
2019-12-10 13:00:00	SPY	ETF	313.94	314.14	313.78	313.835	2688600.0
2019-12-10 14:00:00	SPY	ETF	313.84	314.17	313.78	313.91	4078658.0
2019-12-10 15:00:00	SPY	ETF	313.92	314.05	313.03	313.55	9890991.0
2019-12-10 16:00:00	SPY	ETF	313.54	313.95	313.5298	313.94	7093033.0
2019-12-10 17:00:00	SPY	ETF	313.95	313.99	313.84	313.85	86111.0
2019-12-10 18:00:00	SPY	ETF	313.81	314.01	313.6	313.6	406140.0
2019-12-10 19:00:00	SPY	ETF	313.67	313.72	313.3	313.49	89037.0
2019-12-10 04:00:00	QQQ	ETF	203.11	203.19	202.98	203.09	26601.0
2019-12-10 05:00:00	QQQ	ETF	203.15	203.36	203.12	203.16	24277.0
2019-12-10 06:00:00	QQQ	ETF	203.16	203.16	202.47	203.04	41244.0
2019-12-10 07:00:00	QQQ	ETF	203.08	203.12	202.87	202.94	110724.0
2019-12-10 08:00:00	QQQ	ETF	203.02	204.52	202.84	204.26	863594.0
2019-12-10 09:00:00	QQQ	ETF	204.25	204.33	203.44	204.02	2657135.0
2019-12-10 10:00:00	QQQ	ETF	204.02	204.79	203.94	204.67	1883444.0
2019-12-10 11:00:00	QQQ	ETF	204.68	204.88	204.09	204.4	2004054.0
2019-12-10 12:00:00	QQQ	ETF	204.393	204.393	204.11	204.34	1112156.0
2019-12-10 13:00:00	QQQ	ETF	204.34	204.53	204.19	204.202	966480.0
2019-12-10 14:00:00	QQQ	ETF	204.21	204.39	204.0963	204.22	835008.0
2019-12-10 15:00:00	QQQ	ETF	204.22	204.35	203.53	203.9	2515425.0
2019-12-10 16:00:00	QQQ	ETF	203.91	204.15	203.87	204.14	1369541.0
2019-12-10 17:00:00	QQQ	ETF	204.17	204.19	204.1	204.1	22231.0
2019-12-10 18:00:00	QQQ	ETF	204.09	204.2	203.91	203.93	24960.0
2019-12-10 19:00:00	QQQ	ETF	203.94	204.02	203.68	203.77	33219.0
2019-12-10 04:00:00	IWM	ETF	161.79	161.79	161.68	161.68	877.0
2019-12-10 05:00:00	IWM	ETF	161.68	161.83	161.68	161.83	1707.0
2019-12-10 06:00:00	IWM	ETF	161.73	161.74	161.5	161.71	8500.0
2019-12-10 07:00:00	IWM	ETF	161.74	161.75	161.65	161.68	2900.0
2019-12-10 08:00:00	IWM	ETF	161.67	162.8	161.67	162.51	241362.0
2019-12-10 09:00:00	IWM	ETF	162.52	162.55	161.94	162.44	1188869.0
2019-12-10 10:00:00	IWM	ETF	162.45	162.89	162.33	162.83	1644389.0
2019-12-10 11:00:00	IWM	ETF	162.84	162.96	162.54	162.62	1091866.0
2019-12-10 12:00:00	IWM	ETF	162.62	162.73	162.47	162.605	787688.0
2019-12-10 13:00:00	IWM	ETF	162.6	162.71	162.52	162.5839	698179.0
2019-12-10 14:00:00	IWM	ETF	162.5895	162.67	162.52	162.55	871953.0
2019-12-10 15:00:00	IWM	ETF	162.55	162.62	162.145	162.6	2203553.0
2019-12-10 16:00:00	IWM	ETF	162.61	162.75	162.3425	162.75	1058335.0
2019-12-10 17:00:00	IWM	ETF	162.74	162.77	162.67	162.77	3872.0
2019-12-10 18:00:00	IWM	ETF	162.7	162.83	162.61	162.61	11791.0
2019-12-10 19:00:00	IWM	ETF	162.67	162.71	162.44	162.5	12800.0
2019-12-10 04:00:00	DIA	ETF	278.7	278.7	278.7	278.7	100.0
2019-12-10 06:00:00	DIA	ETF	277.96	278.57	277.96	278.57	4100.0

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

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