PREVIEW / etf_1hour / 2017-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-18.parquet
  size:    272 KB
  rows:    8,779

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-01-18 04:00:00	SPY	ETF	226.43	226.62	226.43	226.55	34656.0
2017-01-18 05:00:00	SPY	ETF	226.58	226.64	226.5	226.64	9538.0
2017-01-18 06:00:00	SPY	ETF	226.6	226.6	226.37	226.4	33871.0
2017-01-18 07:00:00	SPY	ETF	226.34	226.63	226.34	226.63	102092.0
2017-01-18 08:00:00	SPY	ETF	226.34	226.86	226.31	226.71	435413.0
2017-01-18 09:00:00	SPY	ETF	226.7	226.71	225.9	226.43	8456591.0
2017-01-18 10:00:00	SPY	ETF	226.43	226.65	226.25	226.46	7553055.0
2017-01-18 11:00:00	SPY	ETF	226.4639	226.62	226.18	226.25	5363162.0
2017-01-18 12:00:00	SPY	ETF	226.25	226.53	226.2	226.23	4183996.0
2017-01-18 13:00:00	SPY	ETF	226.23	226.46	226.21	226.315	3642929.0
2017-01-18 14:00:00	SPY	ETF	226.32	226.55	226.3	226.5	3669299.0
2017-01-18 15:00:00	SPY	ETF	226.5	226.8	226.4	226.74	13886719.0
2017-01-18 16:00:00	SPY	ETF	226.73	226.82	226.3721	226.61	6295410.0
2017-01-18 17:00:00	SPY	ETF	226.63	226.75	226.58	226.62	194704.0
2017-01-18 18:00:00	SPY	ETF	226.63	226.79	226.63	226.75	74708.0
2017-01-18 19:00:00	SPY	ETF	226.76	226.87	226.76	226.8	52689.0
2017-01-18 05:00:00	QQQ	ETF	122.99	122.99	122.99	122.99	200.0
2017-01-18 06:00:00	QQQ	ETF	123.03	123.03	122.89	122.9	6000.0
2017-01-18 07:00:00	QQQ	ETF	122.88	123.01	122.88	123.01	23266.0
2017-01-18 08:00:00	QQQ	ETF	123.01	123.11	122.98	123.05	192459.0
2017-01-18 09:00:00	QQQ	ETF	123.04	123.1	122.74	123.08	2906201.0
2017-01-18 10:00:00	QQQ	ETF	123.07	123.16	122.79	122.94	1635220.0
2017-01-18 11:00:00	QQQ	ETF	122.94	122.98	122.66	122.71	1317094.0
2017-01-18 12:00:00	QQQ	ETF	122.7	122.91	122.695	122.73	549998.0
2017-01-18 13:00:00	QQQ	ETF	122.72	122.88	122.7	122.7811	828186.0
2017-01-18 14:00:00	QQQ	ETF	122.785	122.92	122.76	122.87	715283.0
2017-01-18 15:00:00	QQQ	ETF	122.87	123.1	122.8201	123.05	2264607.0
2017-01-18 16:00:00	QQQ	ETF	123.05	123.16	123.0	123.12	888478.0
2017-01-18 17:00:00	QQQ	ETF	123.1	123.19	123.09	123.15	1470.0
2017-01-18 18:00:00	QQQ	ETF	123.15	123.18	123.12	123.18	14040.0
2017-01-18 19:00:00	QQQ	ETF	123.17	123.24	123.17	123.21	8900.0
2017-01-18 05:00:00	IWM	ETF	134.79	134.79	134.79	134.79	503.0
2017-01-18 07:00:00	IWM	ETF	134.54	134.62	134.54	134.59	51950.0
2017-01-18 08:00:00	IWM	ETF	134.3087	135.0	134.3087	134.88	60923.0
2017-01-18 09:00:00	IWM	ETF	134.83	134.93	133.95	134.59	2669427.0
2017-01-18 10:00:00	IWM	ETF	134.59	134.86	134.32	134.57	2359013.0
2017-01-18 11:00:00	IWM	ETF	134.58	134.84	134.43	134.45	1513853.0
2017-01-18 12:00:00	IWM	ETF	134.45	134.76	134.26	134.26	1753717.0
2017-01-18 13:00:00	IWM	ETF	134.25	134.46	134.2101	134.33	1535377.0
2017-01-18 14:00:00	IWM	ETF	134.34	134.5	134.23	134.42	1526114.0
2017-01-18 15:00:00	IWM	ETF	134.42	134.935	134.345	134.83	5535630.0
2017-01-18 16:00:00	IWM	ETF	134.85	134.94	134.81	134.89	1239231.0
2017-01-18 17:00:00	IWM	ETF	134.85	134.89	134.85	134.88	1300.0
2017-01-18 18:00:00	IWM	ETF	134.88	134.88	134.88	134.88	200.0
2017-01-18 19:00:00	IWM	ETF	134.93	134.94	134.93	134.94	3300.0
2017-01-18 04:00:00	DIA	ETF	198.19	198.25	198.19	198.25	550.0
2017-01-18 07:00:00	DIA	ETF	198.1	198.1	197.9	197.9	200.0
2017-01-18 09:00:00	DIA	ETF	198.39	198.39	197.3	197.86	690451.0
2017-01-18 10:00:00	DIA	ETF	197.88	198.23	197.8	198.07	587443.0
2017-01-18 11:00:00	DIA	ETF	198.08	198.16	197.62	197.67	329373.0

> showing 50 of 8,779 rows — these rows as CSV

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