PREVIEW / etf_1hour / 2018-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-05.parquet
  size:    311 KB
  rows:    10,128

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
2018-01-05 04:00:00	SPY	ETF	272.02	272.29	272.0	272.28	48937.0
2018-01-05 05:00:00	SPY	ETF	272.22	272.46	272.22	272.45	27430.0
2018-01-05 06:00:00	SPY	ETF	272.42	272.45	272.33	272.44	39600.0
2018-01-05 07:00:00	SPY	ETF	272.43	272.55	272.38	272.47	172754.0
2018-01-05 08:00:00	SPY	ETF	271.61	272.75	271.61	272.57	1009252.0
2018-01-05 09:00:00	SPY	ETF	272.55	272.6	271.95	272.305	6855580.0
2018-01-05 10:00:00	SPY	ETF	272.3	272.52	272.14	272.42	7788345.0
2018-01-05 11:00:00	SPY	ETF	272.42	272.73	272.34	272.62	5106778.0
2018-01-05 12:00:00	SPY	ETF	272.615	272.7	272.3901	272.499	5700350.0
2018-01-05 13:00:00	SPY	ETF	272.49	272.73	272.49	272.67	5837954.0
2018-01-05 14:00:00	SPY	ETF	272.68	272.995	272.61	272.855	5600716.0
2018-01-05 15:00:00	SPY	ETF	272.855	273.56	272.83	273.39	20230827.0
2018-01-05 16:00:00	SPY	ETF	273.39	273.59	272.2325	273.51	16709276.0
2018-01-05 17:00:00	SPY	ETF	273.5	273.85	273.42	273.65	1288564.0
2018-01-05 18:00:00	SPY	ETF	273.65	273.65	273.42	273.49	1175836.0
2018-01-05 19:00:00	SPY	ETF	273.53	273.6	273.43	273.6	49134.0
2018-01-05 04:00:00	QQQ	ETF	160.78	160.89	160.77	160.89	8480.0
2018-01-05 05:00:00	QQQ	ETF	160.86	161.12	160.86	161.09	23847.0
2018-01-05 06:00:00	QQQ	ETF	161.1	161.12	161.04	161.11	15910.0
2018-01-05 07:00:00	QQQ	ETF	161.08	161.16	161.04	161.1	67467.0
2018-01-05 08:00:00	QQQ	ETF	161.085	161.35	161.05	161.14	228120.0
2018-01-05 09:00:00	QQQ	ETF	161.11	161.19	160.77	161.01	3320841.0
2018-01-05 10:00:00	QQQ	ETF	161.0	161.5	160.88	161.44	2594965.0
2018-01-05 11:00:00	QQQ	ETF	161.455	161.7	161.3601	161.7	3088273.0
2018-01-05 12:00:00	QQQ	ETF	161.6925	161.73	161.56	161.63	1884458.0
2018-01-05 13:00:00	QQQ	ETF	161.635	161.78	161.58	161.72	1807176.0
2018-01-05 14:00:00	QQQ	ETF	161.72	161.76	161.59	161.64	1599903.0
2018-01-05 15:00:00	QQQ	ETF	161.63	162.03	161.585	161.88	4108607.0
2018-01-05 16:00:00	QQQ	ETF	161.88	162.16	160.8482	162.0	1745904.0
2018-01-05 17:00:00	QQQ	ETF	162.04	162.15	162.04	162.05	9799.0
2018-01-05 18:00:00	QQQ	ETF	162.05	162.05	162.02	162.05	5628.0
2018-01-05 19:00:00	QQQ	ETF	162.05	162.15	162.05	162.08	11495.0
2018-01-05 04:00:00	IWM	ETF	154.62	154.73	154.62	154.73	7258.0
2018-01-05 05:00:00	IWM	ETF	154.87	154.92	154.87	154.92	3300.0
2018-01-05 06:00:00	IWM	ETF	154.88	154.96	154.86	154.94	15383.0
2018-01-05 07:00:00	IWM	ETF	154.94	154.98	154.85	154.86	27758.0
2018-01-05 08:00:00	IWM	ETF	154.47	154.97	154.47	154.85	36971.0
2018-01-05 09:00:00	IWM	ETF	154.81	154.98	154.29	154.42	2201726.0
2018-01-05 10:00:00	IWM	ETF	154.42	154.82	154.32	154.59	1885688.0
2018-01-05 11:00:00	IWM	ETF	154.59	154.74	154.43	154.47	1460785.0
2018-01-05 12:00:00	IWM	ETF	154.47	154.51	153.94	154.17	2262585.0
2018-01-05 13:00:00	IWM	ETF	154.16	154.39	154.02	154.3199	1339914.0
2018-01-05 14:00:00	IWM	ETF	154.32	154.53	154.31	154.45	1707776.0
2018-01-05 15:00:00	IWM	ETF	154.45	154.89	154.39	154.8	3719565.0
2018-01-05 16:00:00	IWM	ETF	154.79	154.99	154.5288	154.93	1676414.0
2018-01-05 17:00:00	IWM	ETF	154.92	154.99	154.87	154.95	14717.0
2018-01-05 18:00:00	IWM	ETF	154.93	154.93	154.85	154.85	1704.0
2018-01-05 19:00:00	IWM	ETF	154.88	154.88	154.85	154.85	1204.0
2018-01-05 06:00:00	DIA	ETF	251.28	251.52	251.28	251.52	1200.0
2018-01-05 07:00:00	DIA	ETF	251.48	251.56	251.46	251.46	3741.0

> showing 50 of 10,128 rows — these rows as CSV

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