PREVIEW / etf_1hour / 2016-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-05.parquet
  size:    250 KB
  rows:    7,921

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-05 04:00:00	SPY	ETF	191.16	191.94	191.13	191.88	17075.0
2016-02-05 05:00:00	SPY	ETF	191.75	192.01	191.63	191.66	25765.0
2016-02-05 06:00:00	SPY	ETF	191.69	191.73	191.25	191.49	30026.0
2016-02-05 07:00:00	SPY	ETF	191.42	191.66	191.35	191.52	188663.0
2016-02-05 08:00:00	SPY	ETF	191.51	191.65	190.15	190.48	3909875.0
2016-02-05 09:00:00	SPY	ETF	190.48	191.62	189.7	190.08	16275196.0
2016-02-05 10:00:00	SPY	ETF	190.09	190.58	188.86	188.93	25167823.0
2016-02-05 11:00:00	SPY	ETF	188.96	189.15	187.9905	188.75	24827986.0
2016-02-05 12:00:00	SPY	ETF	188.75	191.6696	188.28	188.5845	17192757.0
2016-02-05 13:00:00	SPY	ETF	188.58	188.98	187.87	188.18	16336008.0
2016-02-05 14:00:00	SPY	ETF	188.18	188.36	187.45	187.65	20859670.0
2016-02-05 15:00:00	SPY	ETF	187.66	188.05	187.2	187.95	40883031.0
2016-02-05 16:00:00	SPY	ETF	187.94	188.3579	187.77	188.01	12442559.0
2016-02-05 17:00:00	SPY	ETF	188.06	188.06	187.72	187.74	1146368.0
2016-02-05 18:00:00	SPY	ETF	187.74	187.98	187.74	187.8	66648.0
2016-02-05 19:00:00	SPY	ETF	187.77	187.96	187.74	187.88	68956.0
2016-02-05 20:00:00	SPY	ETF	187.9893	187.9893	187.9893	187.9893	217500.0
2016-02-05 04:00:00	QQQ	ETF	101.48	101.82	101.48	101.82	760.0
2016-02-05 05:00:00	QQQ	ETF	101.75	101.77	101.69	101.74	1700.0
2016-02-05 06:00:00	QQQ	ETF	101.73	101.76	101.45	101.58	20800.0
2016-02-05 07:00:00	QQQ	ETF	101.57	101.71	101.51	101.6	26611.0
2016-02-05 08:00:00	QQQ	ETF	101.62	101.62	100.52	101.0	924335.0
2016-02-05 09:00:00	QQQ	ETF	101.01	101.64	100.04	100.15	6988181.0
2016-02-05 10:00:00	QQQ	ETF	100.16	100.43	99.19	99.23	9878203.0
2016-02-05 11:00:00	QQQ	ETF	99.24	99.35	98.4	98.925	9347453.0
2016-02-05 12:00:00	QQQ	ETF	98.92	99.12	98.54	98.76	5110659.0
2016-02-05 13:00:00	QQQ	ETF	98.76	98.89	98.1	98.27	6224663.0
2016-02-05 14:00:00	QQQ	ETF	98.28	98.4	97.79	98.03	6548206.0
2016-02-05 15:00:00	QQQ	ETF	98.04	98.33	97.72	98.13	12183866.0
2016-02-05 16:00:00	QQQ	ETF	98.12	98.35	98.08	98.16	1740035.0
2016-02-05 17:00:00	QQQ	ETF	98.19	98.2	98.08	98.08	12851.0
2016-02-05 18:00:00	QQQ	ETF	98.08	98.12	98.0	98.0	9782.0
2016-02-05 19:00:00	QQQ	ETF	97.99	98.09	97.99	98.09	16683.0
2016-02-05 05:00:00	IWM	ETF	100.82	100.82	100.82	100.82	400.0
2016-02-05 07:00:00	IWM	ETF	100.6	100.7	100.6	100.6	6948.0
2016-02-05 08:00:00	IWM	ETF	100.67	100.69	99.92	99.92	1703155.0
2016-02-05 09:00:00	IWM	ETF	99.94	100.61	99.57	99.735	5340254.0
2016-02-05 10:00:00	IWM	ETF	99.74	100.065	98.99	99.02	6166187.0
2016-02-05 11:00:00	IWM	ETF	99.03	99.135	98.39	98.94	6597274.0
2016-02-05 12:00:00	IWM	ETF	98.93	99.255	98.72	98.9675	4054998.0
2016-02-05 13:00:00	IWM	ETF	98.97	99.11	98.46	98.58	3543234.0
2016-02-05 14:00:00	IWM	ETF	98.584	98.75	98.2	98.53	5398733.0
2016-02-05 15:00:00	IWM	ETF	98.53	98.66	97.96	97.99	10615780.0
2016-02-05 16:00:00	IWM	ETF	97.98	98.4333	97.97	98.24	1933967.0
2016-02-05 17:00:00	IWM	ETF	97.9324	98.3	97.9324	98.1	1233097.0
2016-02-05 18:00:00	IWM	ETF	98.1	98.1	98.01	98.01	1500.0
2016-02-05 19:00:00	IWM	ETF	98.0	98.19	98.0	98.1	603.0
2016-02-05 06:00:00	DIA	ETF	164.15	164.15	164.15	164.15	247.0
2016-02-05 07:00:00	DIA	ETF	164.25	164.25	164.25	164.25	100.0
2016-02-05 08:00:00	DIA	ETF	164.31	164.31	163.3	163.83	28298.0

> showing 50 of 7,921 rows — these rows as CSV

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