PREVIEW / etf_1hour / 2019-12-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	312.65	312.8	312.65	312.76	3637.0
2019-12-06 05:00:00	SPY	ETF	312.81	312.81	312.67	312.7	4853.0
2019-12-06 06:00:00	SPY	ETF	312.64	312.89	312.64	312.83	36480.0
2019-12-06 07:00:00	SPY	ETF	312.83	312.85	312.53	312.62	45238.0
2019-12-06 08:00:00	SPY	ETF	312.75	314.14	312.37	313.95	1806787.0
2019-12-06 09:00:00	SPY	ETF	313.96	314.72	313.91	314.64	5315848.0
2019-12-06 10:00:00	SPY	ETF	314.63	315.06	314.42	314.92	8142912.0
2019-12-06 11:00:00	SPY	ETF	314.92	315.28	314.86	315.11	6357832.0
2019-12-06 12:00:00	SPY	ETF	315.11	315.29	315.03	315.22	4047069.0
2019-12-06 13:00:00	SPY	ETF	315.215	315.31	315.06	315.07	3605924.0
2019-12-06 14:00:00	SPY	ETF	315.065	315.16	314.91	314.955	3908428.0
2019-12-06 15:00:00	SPY	ETF	314.9501	315.2599	314.67	314.82	8639027.0
2019-12-06 16:00:00	SPY	ETF	314.82	314.91	314.73	314.87	5857914.0
2019-12-06 17:00:00	SPY	ETF	314.88	315.04	314.82	314.96	55098.0
2019-12-06 18:00:00	SPY	ETF	315.0	315.05	314.99	315.0	5669.0
2019-12-06 19:00:00	SPY	ETF	315.01	315.08	314.96	315.01	23104.0
2019-12-06 04:00:00	QQQ	ETF	203.35	203.56	203.33	203.55	10332.0
2019-12-06 05:00:00	QQQ	ETF	203.38	203.47	203.36	203.4	5664.0
2019-12-06 06:00:00	QQQ	ETF	203.38	203.53	203.38	203.53	7723.0
2019-12-06 07:00:00	QQQ	ETF	203.52	203.53	203.27	203.34	71148.0
2019-12-06 08:00:00	QQQ	ETF	203.35	204.45	203.12	204.33	659786.0
2019-12-06 09:00:00	QQQ	ETF	204.34	204.74	204.1501	204.58	2573358.0
2019-12-06 10:00:00	QQQ	ETF	204.58	204.78	204.33	204.64	2683684.0
2019-12-06 11:00:00	QQQ	ETF	204.66	204.83	204.61	204.71	1036780.0
2019-12-06 12:00:00	QQQ	ETF	204.7105	204.98	204.69	204.92	1046152.0
2019-12-06 13:00:00	QQQ	ETF	204.92	205.07	204.91	204.95	720140.0
2019-12-06 14:00:00	QQQ	ETF	204.94	205.042	204.89	204.94	819783.0
2019-12-06 15:00:00	QQQ	ETF	204.93	205.145	204.81	204.92	2845155.0
2019-12-06 16:00:00	QQQ	ETF	204.91	205.01	204.82	205.0	1421556.0
2019-12-06 17:00:00	QQQ	ETF	205.02	205.04	204.91	205.02	6331.0
2019-12-06 18:00:00	QQQ	ETF	205.01	205.04	204.97	205.04	2561.0
2019-12-06 19:00:00	QQQ	ETF	205.1	205.1	204.91	205.09	3019.0
2019-12-06 05:00:00	IWM	ETF	161.43	161.45	161.4	161.4	1265.0
2019-12-06 06:00:00	IWM	ETF	161.4	161.53	161.4	161.49	8890.0
2019-12-06 07:00:00	IWM	ETF	161.5	161.5	161.35	161.43	21975.0
2019-12-06 08:00:00	IWM	ETF	161.39	162.6	161.24	162.44	347145.0
2019-12-06 09:00:00	IWM	ETF	162.5	163.1	162.42	163.03	2038124.0
2019-12-06 10:00:00	IWM	ETF	163.03	163.41	162.9	163.2037	2716730.0
2019-12-06 11:00:00	IWM	ETF	163.2	163.325	163.04	163.16	1284570.0
2019-12-06 12:00:00	IWM	ETF	163.16	163.16	162.96	163.01	1132891.0
2019-12-06 13:00:00	IWM	ETF	163.0101	163.06	162.77	162.775	778637.0
2019-12-06 14:00:00	IWM	ETF	162.7766	163.01	162.72	162.955	640593.0
2019-12-06 15:00:00	IWM	ETF	162.9586	163.06	162.71	162.82	2414554.0
2019-12-06 16:00:00	IWM	ETF	162.82	163.03	160.862	162.97	2041234.0
2019-12-06 17:00:00	IWM	ETF	163.0	163.02	162.91	163.02	3942.0
2019-12-06 19:00:00	IWM	ETF	162.94	162.94	162.94	162.94	200.0
2019-12-06 05:00:00	DIA	ETF	278.0	278.0	278.0	278.0	140.0
2019-12-06 07:00:00	DIA	ETF	278.081	278.081	277.86	277.86	5500.0
2019-12-06 08:00:00	DIA	ETF	277.88	279.21	277.64	279.1	40916.0
2019-12-06 09:00:00	DIA	ETF	279.1	280.2	279.05	280.2	527651.0

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

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