PREVIEW / etf_1hour / 2017-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-25.parquet
  size:    283 KB
  rows:    9,083

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-25 04:00:00	SPY	ETF	228.14	228.29	228.14	228.2	38735.0
2017-01-25 05:00:00	SPY	ETF	228.03	228.19	228.0	228.14	24002.0
2017-01-25 06:00:00	SPY	ETF	228.17	228.17	228.07	228.07	98102.0
2017-01-25 07:00:00	SPY	ETF	228.07	228.42	228.06	228.37	345638.0
2017-01-25 08:00:00	SPY	ETF	228.37	228.54	227.6	228.45	640557.0
2017-01-25 09:00:00	SPY	ETF	228.44	228.91	228.42	228.91	8524720.0
2017-01-25 10:00:00	SPY	ETF	228.91	229.17	228.8	229.1057	8540654.0
2017-01-25 11:00:00	SPY	ETF	229.109	229.33	228.82	228.99	7969382.0
2017-01-25 12:00:00	SPY	ETF	228.99	229.15	228.93	229.13	5576803.0
2017-01-25 13:00:00	SPY	ETF	229.13	229.3725	229.11	229.355	7183062.0
2017-01-25 14:00:00	SPY	ETF	229.36	229.49	229.17	229.2	7340409.0
2017-01-25 15:00:00	SPY	ETF	229.19	229.57	229.09	229.49	18504841.0
2017-01-25 16:00:00	SPY	ETF	229.5	229.57	229.1883	229.44	16661574.0
2017-01-25 17:00:00	SPY	ETF	229.43	229.57	229.4	229.45	307796.0
2017-01-25 18:00:00	SPY	ETF	229.47	229.47	229.39	229.4	101339.0
2017-01-25 19:00:00	SPY	ETF	229.4	229.45	229.29	229.42	150383.0
2017-01-25 04:00:00	QQQ	ETF	124.57	124.66	124.57	124.65	600.0
2017-01-25 05:00:00	QQQ	ETF	124.68	124.7	124.68	124.7	9900.0
2017-01-25 06:00:00	QQQ	ETF	124.66	124.72	124.65	124.65	6178.0
2017-01-25 07:00:00	QQQ	ETF	124.67	124.83	124.65	124.8	60167.0
2017-01-25 08:00:00	QQQ	ETF	124.81	124.87	124.18	124.83	77049.0
2017-01-25 09:00:00	QQQ	ETF	124.83	125.03	124.83	125.02	2461342.0
2017-01-25 10:00:00	QQQ	ETF	125.02	125.18	124.9415	125.16	1642637.0
2017-01-25 11:00:00	QQQ	ETF	125.16	125.27	124.98	125.0767	1327888.0
2017-01-25 12:00:00	QQQ	ETF	125.08	125.19	125.05	125.18	932009.0
2017-01-25 13:00:00	QQQ	ETF	125.19	125.4	125.181	125.365	1493090.0
2017-01-25 14:00:00	QQQ	ETF	125.365	125.395	125.24	125.27	1329092.0
2017-01-25 15:00:00	QQQ	ETF	125.2659	125.46	125.19	125.42	3411746.0
2017-01-25 16:00:00	QQQ	ETF	125.42	125.49	125.33	125.48	494361.0
2017-01-25 17:00:00	QQQ	ETF	125.48	125.49	125.46	125.47	4487.0
2017-01-25 18:00:00	QQQ	ETF	125.44	125.46	125.39	125.44	9886.0
2017-01-25 19:00:00	QQQ	ETF	125.4	125.48	125.4	125.46	8541.0
2017-01-25 04:00:00	IWM	ETF	136.52	136.61	136.52	136.52	1734.0
2017-01-25 06:00:00	IWM	ETF	136.5	136.5	136.5	136.5	3000.0
2017-01-25 07:00:00	IWM	ETF	136.5	136.71	136.47	136.71	38626.0
2017-01-25 08:00:00	IWM	ETF	136.7	136.93	135.93	136.82	141206.0
2017-01-25 09:00:00	IWM	ETF	136.82	137.55	136.82	137.33	5625927.0
2017-01-25 10:00:00	IWM	ETF	137.33	137.48	136.98	137.29	3837290.0
2017-01-25 11:00:00	IWM	ETF	137.29	137.52	136.975	137.0999	2476664.0
2017-01-25 12:00:00	IWM	ETF	137.09	137.18	136.965	137.08	2010496.0
2017-01-25 13:00:00	IWM	ETF	137.085	137.4	137.04	137.32	1944577.0
2017-01-25 14:00:00	IWM	ETF	137.315	137.36	137.08	137.08	1723289.0
2017-01-25 15:00:00	IWM	ETF	137.08	137.48	137.02	137.28	5161775.0
2017-01-25 16:00:00	IWM	ETF	137.21	137.46	137.21	137.46	2066426.0
2017-01-25 17:00:00	IWM	ETF	137.44	137.5	137.44	137.5	2546.0
2017-01-25 18:00:00	IWM	ETF	137.42	137.44	137.39	137.44	1552.0
2017-01-25 19:00:00	IWM	ETF	137.42	137.42	137.36	137.42	1950.0
2017-01-25 04:00:00	DIA	ETF	199.45	199.5	199.45	199.47	500.0
2017-01-25 07:00:00	DIA	ETF	199.53	199.57	199.53	199.57	1458.0
2017-01-25 08:00:00	DIA	ETF	199.59	199.86	199.53	199.85	18445.0

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

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