PREVIEW / etf_1hour / 2016-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-19.parquet
  size:    265 KB
  rows:    8,507

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
2016-01-19 04:00:00	SPY	ETF	190.48	191.0	190.0	190.68	97743.0
2016-01-19 05:00:00	SPY	ETF	190.73	191.06	190.65	190.92	69800.0
2016-01-19 06:00:00	SPY	ETF	190.94	191.29	190.9	191.23	194242.0
2016-01-19 07:00:00	SPY	ETF	191.23	191.23	190.61	190.74	727254.0
2016-01-19 08:00:00	SPY	ETF	190.74	191.14	187.3	190.6	4342298.0
2016-01-19 09:00:00	SPY	ETF	190.6	190.63	187.8617	189.05	23550604.0
2016-01-19 10:00:00	SPY	ETF	189.05	189.99	188.71	188.71	22986438.0
2016-01-19 11:00:00	SPY	ETF	188.7101	189.47	188.15	188.9	25913362.0
2016-01-19 12:00:00	SPY	ETF	188.9	188.96	187.87	188.2276	20133368.0
2016-01-19 13:00:00	SPY	ETF	188.22	188.59	187.69	187.83	14524471.0
2016-01-19 14:00:00	SPY	ETF	187.835	187.96	186.2	186.69	25214664.0
2016-01-19 15:00:00	SPY	ETF	186.69	188.74	186.51	188.02	34862815.0
2016-01-19 16:00:00	SPY	ETF	188.02	188.25	187.4804	187.73	10066586.0
2016-01-19 17:00:00	SPY	ETF	187.76	188.06	187.51	187.67	1209598.0
2016-01-19 18:00:00	SPY	ETF	187.68	188.34	187.63	188.2	419928.0
2016-01-19 19:00:00	SPY	ETF	188.1	188.11	186.91	187.28	313374.0
2016-01-19 04:00:00	QQQ	ETF	102.33	102.73	102.31	102.7	8147.0
2016-01-19 05:00:00	QQQ	ETF	102.64	102.77	102.6	102.65	4100.0
2016-01-19 06:00:00	QQQ	ETF	102.7	102.86	102.7	102.85	27800.0
2016-01-19 07:00:00	QQQ	ETF	102.8	102.84	102.54	102.62	35793.0
2016-01-19 08:00:00	QQQ	ETF	102.59	102.8001	102.34	102.48	442837.0
2016-01-19 09:00:00	QQQ	ETF	102.49	102.49	101.4	101.74	7821765.0
2016-01-19 10:00:00	QQQ	ETF	101.73	102.26	101.53	101.53	8374142.0
2016-01-19 11:00:00	QQQ	ETF	101.53	101.78	100.98	101.425	7821716.0
2016-01-19 12:00:00	QQQ	ETF	101.42	101.46	100.84	101.11	4314644.0
2016-01-19 13:00:00	QQQ	ETF	101.11	101.41	100.777	100.86	3321086.0
2016-01-19 14:00:00	QQQ	ETF	100.87	100.9299	99.88	100.2	6869532.0
2016-01-19 15:00:00	QQQ	ETF	100.2	101.5	100.09	101.05	9267966.0
2016-01-19 16:00:00	QQQ	ETF	101.07	101.4	100.87	101.09	1128259.0
2016-01-19 17:00:00	QQQ	ETF	101.12	101.2	100.89	101.07	39412.0
2016-01-19 18:00:00	QQQ	ETF	101.09	101.44	101.05	101.34	33587.0
2016-01-19 19:00:00	QQQ	ETF	101.2	101.2	100.63	100.92	39906.0
2016-01-19 04:00:00	IWM	ETF	101.21	101.53	101.21	101.36	7328.0
2016-01-19 05:00:00	IWM	ETF	101.52	101.61	101.44	101.52	1400.0
2016-01-19 06:00:00	IWM	ETF	101.58	101.7	101.58	101.65	47199.0
2016-01-19 07:00:00	IWM	ETF	101.65	101.65	101.39	101.48	98647.0
2016-01-19 08:00:00	IWM	ETF	101.42	101.52	101.32	101.45	123744.0
2016-01-19 09:00:00	IWM	ETF	101.46	101.46	99.66	100.2757	8762685.0
2016-01-19 10:00:00	IWM	ETF	100.2799	100.73	99.64	99.65	6693950.0
2016-01-19 11:00:00	IWM	ETF	99.65	100.0	99.34	99.79	5081956.0
2016-01-19 12:00:00	IWM	ETF	99.79	99.85	99.04	99.26	4808435.0
2016-01-19 13:00:00	IWM	ETF	99.26	99.59	98.63	98.74	4607819.0
2016-01-19 14:00:00	IWM	ETF	98.74	98.84	97.74	98.07	7225158.0
2016-01-19 15:00:00	IWM	ETF	98.08	99.4	97.985	98.8	10298402.0
2016-01-19 16:00:00	IWM	ETF	98.79	98.96	98.57	98.66	1534792.0
2016-01-19 17:00:00	IWM	ETF	98.63	98.9	98.62	98.9	1845.0
2016-01-19 18:00:00	IWM	ETF	98.77	98.9	98.6	98.9	2889.0
2016-01-19 19:00:00	IWM	ETF	98.77	98.77	98.5	98.6	1980.0
2016-01-19 04:00:00	DIA	ETF	161.8	162.06	161.8	162.04	1300.0
2016-01-19 05:00:00	DIA	ETF	162.13	162.13	162.13	162.13	250.0

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

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