PREVIEW / etf_1hour / 2017-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-03.parquet
  size:    285 KB
  rows:    9,293

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-03 04:00:00	SPY	ETF	224.8	224.87	224.3	224.86	46057.0
2017-01-03 05:00:00	SPY	ETF	224.87	224.97	224.84	224.93	68986.0
2017-01-03 06:00:00	SPY	ETF	224.96	225.34	224.94	225.26	71917.0
2017-01-03 07:00:00	SPY	ETF	225.23	225.38	225.08	225.16	455497.0
2017-01-03 08:00:00	SPY	ETF	225.21	225.32	223.53	225.0	530931.0
2017-01-03 09:00:00	SPY	ETF	225.01	225.265	224.71	225.0	12022537.0
2017-01-03 10:00:00	SPY	ETF	225.0	225.83	224.6	224.66	18565964.0
2017-01-03 11:00:00	SPY	ETF	224.66	224.76	223.8837	224.36	9868888.0
2017-01-03 12:00:00	SPY	ETF	224.36	224.42	223.93	224.23	7260703.0
2017-01-03 13:00:00	SPY	ETF	224.23	224.9437	223.96	224.0199	5028172.0
2017-01-03 14:00:00	SPY	ETF	224.01	224.39	224.01	224.34	5296825.0
2017-01-03 15:00:00	SPY	ETF	224.35	225.19	224.24	225.19	18794613.0
2017-01-03 16:00:00	SPY	ETF	225.2	225.28	225.13	225.2	11307940.0
2017-01-03 17:00:00	SPY	ETF	225.2	225.24	225.18	225.24	188059.0
2017-01-03 18:00:00	SPY	ETF	225.24	225.25	225.11	225.19	124260.0
2017-01-03 19:00:00	SPY	ETF	225.18	225.34	225.12	225.28	88049.0
2017-01-03 04:00:00	QQQ	ETF	119.28	119.45	119.03	119.27	4048.0
2017-01-03 05:00:00	QQQ	ETF	119.25	119.3	119.25	119.3	13200.0
2017-01-03 06:00:00	QQQ	ETF	119.25	119.42	119.25	119.42	11250.0
2017-01-03 07:00:00	QQQ	ETF	119.41	119.54	119.4	119.44	116938.0
2017-01-03 08:00:00	QQQ	ETF	119.42	119.48	118.48	119.4	68677.0
2017-01-03 09:00:00	QQQ	ETF	119.35	119.53	119.01	119.45	3350693.0
2017-01-03 10:00:00	QQQ	ETF	119.445	119.99	119.19	119.24	4967746.0
2017-01-03 11:00:00	QQQ	ETF	119.24	119.4	118.89	119.13	2455866.0
2017-01-03 12:00:00	QQQ	ETF	119.14	119.16	118.9	119.08	2027186.0
2017-01-03 13:00:00	QQQ	ETF	119.08	119.2	118.9	118.92	1273962.0
2017-01-03 14:00:00	QQQ	ETF	118.915	119.07	118.8925	119.045	1456341.0
2017-01-03 15:00:00	QQQ	ETF	119.05	119.53	118.9339	119.53	4103706.0
2017-01-03 16:00:00	QQQ	ETF	119.53	119.6	119.44	119.51	924867.0
2017-01-03 17:00:00	QQQ	ETF	119.52	119.55	119.46	119.5	20563.0
2017-01-03 18:00:00	QQQ	ETF	119.54	119.54	119.44	119.48	9244.0
2017-01-03 19:00:00	QQQ	ETF	119.48	119.57	119.46	119.57	6900.0
2017-01-03 04:00:00	IWM	ETF	136.2	136.55	136.2	136.47	7208.0
2017-01-03 05:00:00	IWM	ETF	136.54	136.54	136.54	136.54	103.0
2017-01-03 06:00:00	IWM	ETF	136.5	136.74	136.5	136.74	17269.0
2017-01-03 07:00:00	IWM	ETF	136.65	136.69	136.54	136.62	6700.0
2017-01-03 08:00:00	IWM	ETF	136.6	136.63	134.85	136.56	168295.0
2017-01-03 09:00:00	IWM	ETF	136.58	136.64	135.58	135.8775	3462401.0
2017-01-03 10:00:00	IWM	ETF	135.85	136.8295	135.0	135.06	6588148.0
2017-01-03 11:00:00	IWM	ETF	135.06	135.4	134.505	135.02	4012411.0
2017-01-03 12:00:00	IWM	ETF	135.03	135.18	134.55	134.78	2065961.0
2017-01-03 13:00:00	IWM	ETF	134.78	134.9	134.5	134.78	1989673.0
2017-01-03 14:00:00	IWM	ETF	134.79	135.08	134.64	135.03	1731297.0
2017-01-03 15:00:00	IWM	ETF	135.02	135.57	135.02	135.55	4099242.0
2017-01-03 16:00:00	IWM	ETF	135.55	135.8	135.3885	135.74	653666.0
2017-01-03 17:00:00	IWM	ETF	135.72	135.78	135.72	135.78	300.0
2017-01-03 18:00:00	IWM	ETF	135.7	135.7	135.62	135.64	1913.0
2017-01-03 19:00:00	IWM	ETF	135.67	135.71	135.67	135.71	7434.0
2017-01-03 04:00:00	DIA	ETF	198.06	198.81	198.03	198.6	4713.0
2017-01-03 06:00:00	DIA	ETF	198.67	198.88	198.67	198.84	650.0

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

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