PREVIEW / etf_1hour / 2016-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-07.parquet
  size:    252 KB
  rows:    8,095

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-03-07 04:00:00	SPY	ETF	199.85	200.16	199.45	199.45	26056.0
2016-03-07 05:00:00	SPY	ETF	199.45	199.5	199.19	199.2	20584.0
2016-03-07 06:00:00	SPY	ETF	199.28	199.43	199.27	199.29	33304.0
2016-03-07 07:00:00	SPY	ETF	199.29	199.55	199.28	199.49	230806.0
2016-03-07 08:00:00	SPY	ETF	199.38	199.78	199.08	199.24	1021146.0
2016-03-07 09:00:00	SPY	ETF	199.23	199.86	199.23	199.47	10763816.0
2016-03-07 10:00:00	SPY	ETF	199.47	200.44	199.33	200.07	14191634.0
2016-03-07 11:00:00	SPY	ETF	200.07	200.98	199.93	200.65	12038327.0
2016-03-07 12:00:00	SPY	ETF	200.64	200.86	200.44	200.75	7607773.0
2016-03-07 13:00:00	SPY	ETF	200.7425	201.07	200.18	200.3776	8489560.0
2016-03-07 14:00:00	SPY	ETF	200.38	200.53	199.49	199.82	11248749.0
2016-03-07 15:00:00	SPY	ETF	199.8101	200.66	199.48	200.59	19715486.0
2016-03-07 16:00:00	SPY	ETF	200.61	200.8	200.3191	200.62	12881400.0
2016-03-07 17:00:00	SPY	ETF	200.6	200.65	200.36	200.58	392289.0
2016-03-07 18:00:00	SPY	ETF	200.56	200.63	200.4	200.59	125383.0
2016-03-07 19:00:00	SPY	ETF	200.62	200.62	200.25	200.26	258044.0
2016-03-07 04:00:00	QQQ	ETF	105.27	105.35	105.24	105.24	1176.0
2016-03-07 05:00:00	QQQ	ETF	105.15	105.15	105.02	105.04	2504.0
2016-03-07 06:00:00	QQQ	ETF	105.1	105.1	105.04	105.08	7798.0
2016-03-07 07:00:00	QQQ	ETF	105.03	105.22	105.02	105.22	29360.0
2016-03-07 08:00:00	QQQ	ETF	105.24	105.24	105.0	105.04	47870.0
2016-03-07 09:00:00	QQQ	ETF	105.08	105.3025	104.76	104.79	3158996.0
2016-03-07 10:00:00	QQQ	ETF	104.77	105.15	104.66	105.02	3619157.0
2016-03-07 11:00:00	QQQ	ETF	105.02	105.74	104.9	105.48	3365668.0
2016-03-07 12:00:00	QQQ	ETF	105.48	105.6	105.35	105.46	1763439.0
2016-03-07 13:00:00	QQQ	ETF	105.47	105.6411	104.84	104.88	2537695.0
2016-03-07 14:00:00	QQQ	ETF	104.881	104.99	104.34	104.49	3894052.0
2016-03-07 15:00:00	QQQ	ETF	104.48	105.199	104.27	105.03	5079454.0
2016-03-07 16:00:00	QQQ	ETF	105.05	105.16	105.0	105.1	693829.0
2016-03-07 17:00:00	QQQ	ETF	105.02	105.12	105.02	105.1	5196.0
2016-03-07 18:00:00	QQQ	ETF	105.05	105.05	104.94	104.99	19747.0
2016-03-07 19:00:00	QQQ	ETF	104.99	105.07	104.8	104.8	15950.0
2016-03-07 05:00:00	IWM	ETF	107.23	107.23	107.23	107.23	200.0
2016-03-07 06:00:00	IWM	ETF	107.31	107.31	107.31	107.31	2500.0
2016-03-07 07:00:00	IWM	ETF	107.31	107.31	107.18	107.19	12100.0
2016-03-07 08:00:00	IWM	ETF	107.24	107.31	107.08	107.14	45724.0
2016-03-07 09:00:00	IWM	ETF	107.16	107.87	107.13	107.64	4035907.0
2016-03-07 10:00:00	IWM	ETF	107.64	108.5	107.58	108.22	6811715.0
2016-03-07 11:00:00	IWM	ETF	108.23	108.99	108.17	108.7867	3784330.0
2016-03-07 12:00:00	IWM	ETF	108.79	108.85	108.67	108.78	2002328.0
2016-03-07 13:00:00	IWM	ETF	108.78	108.93	108.35	108.475	2532811.0
2016-03-07 14:00:00	IWM	ETF	108.47	108.59	107.96	108.21	3269116.0
2016-03-07 15:00:00	IWM	ETF	108.2	108.91	108.02	108.91	6943972.0
2016-03-07 16:00:00	IWM	ETF	108.9	109.1	108.7538	109.06	4080365.0
2016-03-07 17:00:00	IWM	ETF	109.07	109.08	108.95	109.08	12386.0
2016-03-07 18:00:00	IWM	ETF	108.97	108.99	108.91	108.99	42883.0
2016-03-07 19:00:00	IWM	ETF	108.96	108.96	108.89	108.91	9302.0
2016-03-07 08:00:00	DIA	ETF	169.47	169.53	169.25	169.29	780.0
2016-03-07 09:00:00	DIA	ETF	169.39	169.84	169.3	169.7	236228.0
2016-03-07 10:00:00	DIA	ETF	169.67	170.47	169.59	170.15	588912.0

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

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