PREVIEW / etf_1hour / 2016-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-17.parquet
  size:    253 KB
  rows:    8,089

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-02-17 04:00:00	SPY	ETF	189.72	190.5	189.59	190.33	23595.0
2016-02-17 05:00:00	SPY	ETF	190.4	190.96	190.33	190.7	84286.0
2016-02-17 06:00:00	SPY	ETF	190.7	190.85	190.63	190.8	143105.0
2016-02-17 07:00:00	SPY	ETF	190.77	191.13	190.66	191.11	628306.0
2016-02-17 08:00:00	SPY	ETF	191.1	191.13	190.73	190.96	955541.0
2016-02-17 09:00:00	SPY	ETF	190.96	191.765	190.94	191.47	19518541.0
2016-02-17 10:00:00	SPY	ETF	191.48	192.64	191.47	192.5499	21118501.0
2016-02-17 11:00:00	SPY	ETF	192.54	192.68	192.27	192.48	15917798.0
2016-02-17 12:00:00	SPY	ETF	192.49	193.02	192.42	192.845	11117028.0
2016-02-17 13:00:00	SPY	ETF	192.86	193.01	192.53	192.59	10554096.0
2016-02-17 14:00:00	SPY	ETF	192.59	193.32	192.47	192.72	16749404.0
2016-02-17 15:00:00	SPY	ETF	192.73	193.0	192.51	192.87	29289562.0
2016-02-17 16:00:00	SPY	ETF	192.88	193.34	192.3	193.34	7696834.0
2016-02-17 17:00:00	SPY	ETF	193.27	193.36	192.87	193.26	220395.0
2016-02-17 18:00:00	SPY	ETF	193.26	193.3	193.13	193.26	212210.0
2016-02-17 19:00:00	SPY	ETF	193.3	193.35	193.13	193.13	393988.0
2016-02-17 04:00:00	QQQ	ETF	100.13	100.35	100.13	100.35	2727.0
2016-02-17 05:00:00	QQQ	ETF	100.5	100.74	100.5	100.63	5595.0
2016-02-17 06:00:00	QQQ	ETF	100.61	100.68	100.6	100.61	1470.0
2016-02-17 07:00:00	QQQ	ETF	100.66	101.13	100.66	101.13	52990.0
2016-02-17 08:00:00	QQQ	ETF	101.1	101.13	100.75	100.96	129914.0
2016-02-17 09:00:00	QQQ	ETF	100.97	101.2	100.7	101.15	6414972.0
2016-02-17 10:00:00	QQQ	ETF	101.15	101.94	101.12	101.89	7983577.0
2016-02-17 11:00:00	QQQ	ETF	101.885	101.99	101.68	101.879	3759722.0
2016-02-17 12:00:00	QQQ	ETF	101.88	102.46	101.83	102.28	4161660.0
2016-02-17 13:00:00	QQQ	ETF	102.29	102.51	102.15	102.2	3032634.0
2016-02-17 14:00:00	QQQ	ETF	102.2	102.64	102.12	102.32	4491120.0
2016-02-17 15:00:00	QQQ	ETF	102.33	102.525	102.15	102.48	6681783.0
2016-02-17 16:00:00	QQQ	ETF	102.47	102.81	102.35	102.81	1331098.0
2016-02-17 17:00:00	QQQ	ETF	102.81	102.82	102.7	102.7	16220.0
2016-02-17 18:00:00	QQQ	ETF	102.67	102.75	102.67	102.74	26833.0
2016-02-17 19:00:00	QQQ	ETF	102.77	102.77	102.4972	102.68	818320.0
2016-02-17 04:00:00	IWM	ETF	99.2	99.2	99.2	99.2	100.0
2016-02-17 05:00:00	IWM	ETF	99.25	99.53	99.22	99.53	3826.0
2016-02-17 06:00:00	IWM	ETF	99.44	99.53	99.44	99.52	3893.0
2016-02-17 07:00:00	IWM	ETF	99.6	99.68	99.52	99.68	185616.0
2016-02-17 08:00:00	IWM	ETF	99.67	99.68	99.39	99.51	243059.0
2016-02-17 09:00:00	IWM	ETF	99.55	100.2	98.88	100.155	6013392.0
2016-02-17 10:00:00	IWM	ETF	100.16	101.09	100.155	100.981	6622667.0
2016-02-17 11:00:00	IWM	ETF	100.98	101.09	100.45	100.63	5149999.0
2016-02-17 12:00:00	IWM	ETF	100.63	100.89	100.46	100.58	3913884.0
2016-02-17 13:00:00	IWM	ETF	100.59	100.71	100.33	100.54	2416884.0
2016-02-17 14:00:00	IWM	ETF	100.55	100.96	100.24	100.325	4593314.0
2016-02-17 15:00:00	IWM	ETF	100.33	100.61	100.26	100.44	6874468.0
2016-02-17 16:00:00	IWM	ETF	100.43	100.83	100.35	100.83	1559020.0
2016-02-17 17:00:00	IWM	ETF	100.86	100.94	100.84	100.84	17469.0
2016-02-17 18:00:00	IWM	ETF	100.82	100.82	100.71	100.73	4000.0
2016-02-17 19:00:00	IWM	ETF	100.542	100.75	100.542	100.72	831300.0
2016-02-17 04:00:00	DIA	ETF	162.77	162.77	162.77	162.77	100.0
2016-02-17 07:00:00	DIA	ETF	163.11	163.16	163.03	163.03	1300.0

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

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