PREVIEW / etf_1hour / 2017-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-05.parquet
  size:    290 KB
  rows:    9,482

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
2017-09-05 04:00:00	SPY	ETF	247.3	247.42	247.29	247.29	1193.0
2017-09-05 05:00:00	SPY	ETF	247.31	247.37	247.16	247.17	19517.0
2017-09-05 06:00:00	SPY	ETF	247.16	247.16	246.94	247.03	89573.0
2017-09-05 07:00:00	SPY	ETF	247.05	247.32	247.03	247.3	127906.0
2017-09-05 08:00:00	SPY	ETF	247.31	247.84	247.06	247.22	770303.0
2017-09-05 09:00:00	SPY	ETF	247.22	247.52	246.93	247.3699	7081831.0
2017-09-05 10:00:00	SPY	ETF	247.37	247.48	246.61	246.83	8896291.0
2017-09-05 11:00:00	SPY	ETF	246.83	246.885	246.46	246.77	5999167.0
2017-09-05 12:00:00	SPY	ETF	246.75	246.75	245.28	245.55	15710843.0
2017-09-05 13:00:00	SPY	ETF	245.555	245.77	244.95	245.745	13393873.0
2017-09-05 14:00:00	SPY	ETF	245.74	246.15	245.61	245.82	9466652.0
2017-09-05 15:00:00	SPY	ETF	245.83	246.25	245.57	246.1	18132021.0
2017-09-05 16:00:00	SPY	ETF	246.1	247.1015	246.06	246.39	8237919.0
2017-09-05 17:00:00	SPY	ETF	246.39	246.44	246.126	246.38	1142164.0
2017-09-05 18:00:00	SPY	ETF	246.38	246.38	246.13	246.18	147529.0
2017-09-05 19:00:00	SPY	ETF	246.22	246.27	246.15	246.22	36003.0
2017-09-05 04:00:00	QQQ	ETF	145.75	145.83	145.75	145.83	10800.0
2017-09-05 05:00:00	QQQ	ETF	145.73	145.73	145.73	145.73	4600.0
2017-09-05 06:00:00	QQQ	ETF	145.71	145.77	145.57	145.58	1599.0
2017-09-05 07:00:00	QQQ	ETF	145.68	145.79	145.68	145.77	35864.0
2017-09-05 08:00:00	QQQ	ETF	145.76	145.79	145.62	145.64	91221.0
2017-09-05 09:00:00	QQQ	ETF	145.64	145.82	145.08	145.73	3751498.0
2017-09-05 10:00:00	QQQ	ETF	145.74	145.88	145.16	145.35	4285740.0
2017-09-05 11:00:00	QQQ	ETF	145.36	145.36	144.89	145.08	2559592.0
2017-09-05 12:00:00	QQQ	ETF	145.08	145.08	143.75	144.07	6026673.0
2017-09-05 13:00:00	QQQ	ETF	144.0634	144.37	143.6	144.36	5798124.0
2017-09-05 14:00:00	QQQ	ETF	144.35	144.62	144.19	144.45	4058532.0
2017-09-05 15:00:00	QQQ	ETF	144.45	144.77	144.34	144.67	5755802.0
2017-09-05 16:00:00	QQQ	ETF	144.68	144.91	144.0298	144.85	1784304.0
2017-09-05 17:00:00	QQQ	ETF	144.82	144.94	144.82	144.82	4132.0
2017-09-05 18:00:00	QQQ	ETF	144.87	144.87	144.65	144.7	28749.0
2017-09-05 19:00:00	QQQ	ETF	144.72	144.77	144.68	144.69	11610.0
2017-09-05 04:00:00	IWM	ETF	140.5	141.06	140.5	141.06	6500.0
2017-09-05 05:00:00	IWM	ETF	140.8	141.1	140.79	140.79	5660.0
2017-09-05 06:00:00	IWM	ETF	140.72	140.72	140.41	140.41	6089.0
2017-09-05 07:00:00	IWM	ETF	140.44	140.55	140.43	140.52	6325.0
2017-09-05 08:00:00	IWM	ETF	140.64	140.64	140.49	140.56	33348.0
2017-09-05 09:00:00	IWM	ETF	140.6	140.89	140.24	140.76	2250485.0
2017-09-05 10:00:00	IWM	ETF	140.75	140.77	140.03	140.13	2842445.0
2017-09-05 11:00:00	IWM	ETF	140.12	140.22	139.82	139.99	1634303.0
2017-09-05 12:00:00	IWM	ETF	139.99	139.99	138.78	139.02	3149176.0
2017-09-05 13:00:00	IWM	ETF	139.01	139.1	138.58	139.07	1920238.0
2017-09-05 14:00:00	IWM	ETF	139.06	139.43	138.91	139.08	2126166.0
2017-09-05 15:00:00	IWM	ETF	139.07	139.4	138.95	139.18	3746488.0
2017-09-05 16:00:00	IWM	ETF	139.18	140.5089	139.16	139.25	878324.0
2017-09-05 17:00:00	IWM	ETF	139.23	139.25	139.17	139.17	12925.0
2017-09-05 18:00:00	IWM	ETF	139.17	139.17	139.17	139.17	230.0
2017-09-05 19:00:00	IWM	ETF	139.28	139.38	139.28	139.35	11803.0
2017-09-05 07:00:00	DIA	ETF	219.35	219.35	219.05	219.2	1618.0
2017-09-05 08:00:00	DIA	ETF	219.92	219.92	219.25	219.25	700.0

> showing 50 of 9,482 rows — these rows as CSV

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