PREVIEW / etf_1hour / 2018-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-09.parquet
  size:    306 KB
  rows:    10,062

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-09 04:00:00	SPY	ETF	274.15	274.15	274.04	274.09	3910.0
2018-01-09 05:00:00	SPY	ETF	274.11	274.15	274.07	274.13	5300.0
2018-01-09 06:00:00	SPY	ETF	274.06	274.1	273.94	274.08	89610.0
2018-01-09 07:00:00	SPY	ETF	274.13	274.2	274.09	274.19	313911.0
2018-01-09 08:00:00	SPY	ETF	274.19	274.51	274.11	274.46	299256.0
2018-01-09 09:00:00	SPY	ETF	274.45	274.64	274.09	274.24	7459234.0
2018-01-09 10:00:00	SPY	ETF	274.2301	274.67	274.11	274.38	8407472.0
2018-01-09 11:00:00	SPY	ETF	274.37	275.13	274.37	274.94	7311166.0
2018-01-09 12:00:00	SPY	ETF	274.94	275.085	274.78	274.96	3824915.0
2018-01-09 13:00:00	SPY	ETF	274.965	275.23	274.965	275.2098	4675511.0
2018-01-09 14:00:00	SPY	ETF	275.21	275.25	274.79	274.965	4992169.0
2018-01-09 15:00:00	SPY	ETF	274.96	275.02	274.33	274.53	13027805.0
2018-01-09 16:00:00	SPY	ETF	274.52	275.17	274.22	274.25	5698252.0
2018-01-09 17:00:00	SPY	ETF	274.28	274.29	274.21	274.21	43878.0
2018-01-09 18:00:00	SPY	ETF	274.2	274.39	274.19	274.36	82257.0
2018-01-09 19:00:00	SPY	ETF	274.36	274.41	274.22	274.25	30707.0
2018-01-09 04:00:00	QQQ	ETF	162.8	162.8	162.68	162.71	20600.0
2018-01-09 05:00:00	QQQ	ETF	162.77	162.8	162.69	162.8	20200.0
2018-01-09 06:00:00	QQQ	ETF	162.76	162.76	162.63	162.7	6610.0
2018-01-09 07:00:00	QQQ	ETF	162.73	162.8	162.69	162.8	54793.0
2018-01-09 08:00:00	QQQ	ETF	162.81	162.98	162.7	162.93	173952.0
2018-01-09 09:00:00	QQQ	ETF	162.95	162.99	162.07	162.22	5850891.0
2018-01-09 10:00:00	QQQ	ETF	162.22	162.59	162.1	162.44	2892985.0
2018-01-09 11:00:00	QQQ	ETF	162.45	162.89	162.45	162.715	2765777.0
2018-01-09 12:00:00	QQQ	ETF	162.72	162.87	162.5115	162.849	1146750.0
2018-01-09 13:00:00	QQQ	ETF	162.85	163.04	162.83	162.88	1469743.0
2018-01-09 14:00:00	QQQ	ETF	162.88	162.9	162.7	162.81	1533132.0
2018-01-09 15:00:00	QQQ	ETF	162.81	162.85	162.49	162.59	3784213.0
2018-01-09 16:00:00	QQQ	ETF	162.58	162.6	162.35	162.38	1142239.0
2018-01-09 17:00:00	QQQ	ETF	162.42	162.44	162.36	162.39	38950.0
2018-01-09 18:00:00	QQQ	ETF	162.38	162.52	162.34	162.5	41240.0
2018-01-09 19:00:00	QQQ	ETF	162.46	162.48	162.33	162.35	12939.0
2018-01-09 04:00:00	IWM	ETF	154.91	154.91	154.91	154.91	500.0
2018-01-09 05:00:00	IWM	ETF	154.96	154.99	154.92	154.92	3250.0
2018-01-09 06:00:00	IWM	ETF	154.87	154.87	154.8	154.8	3000.0
2018-01-09 07:00:00	IWM	ETF	154.86	155.01	154.86	155.01	23802.0
2018-01-09 08:00:00	IWM	ETF	155.01	155.23	154.94	155.16	60852.0
2018-01-09 09:00:00	IWM	ETF	155.14	155.5	155.13	155.22	2163952.0
2018-01-09 10:00:00	IWM	ETF	155.23	155.31	154.73	154.89	2158719.0
2018-01-09 11:00:00	IWM	ETF	154.89	155.2	154.87	155.13	1297904.0
2018-01-09 12:00:00	IWM	ETF	155.13	155.37	155.06	155.3385	667887.0
2018-01-09 13:00:00	IWM	ETF	155.3499	155.5	155.2211	155.49	1070559.0
2018-01-09 14:00:00	IWM	ETF	155.47	155.49	155.17	155.23	1262282.0
2018-01-09 15:00:00	IWM	ETF	155.23	155.28	154.79	154.84	2580950.0
2018-01-09 16:00:00	IWM	ETF	154.84	155.0402	154.65	154.67	1678531.0
2018-01-09 17:00:00	IWM	ETF	154.63	154.63	154.63	154.63	134.0
2018-01-09 18:00:00	IWM	ETF	154.7	154.79	154.7	154.75	1903.0
2018-01-09 19:00:00	IWM	ETF	154.78	154.78	154.67	154.68	4058.0
2018-01-09 04:00:00	DIA	ETF	248.75	248.75	248.75	248.75	116.0
2018-01-09 07:00:00	DIA	ETF	253.11	253.11	253.0	253.0	2330.0

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

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