PREVIEW / etf_1hour / 2011-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-18.parquet
  size:    177 KB
  rows:    5,463

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
2011-01-18 04:00:00	SPY	ETF	129.39	129.5	129.39	129.5	1800.0
2011-01-18 05:00:00	SPY	ETF	129.54	129.57	129.5	129.53	26800.0
2011-01-18 06:00:00	SPY	ETF	129.64	129.71	129.62	129.67	12600.0
2011-01-18 07:00:00	SPY	ETF	129.62	129.68	129.36	129.47	384940.0
2011-01-18 08:00:00	SPY	ETF	129.45	129.72	128.7	129.19	1529438.0
2011-01-18 09:00:00	SPY	ETF	129.18	129.44	129.04	129.17	17775646.0
2011-01-18 10:00:00	SPY	ETF	129.17	129.48	129.03	129.2	21358811.0
2011-01-18 11:00:00	SPY	ETF	129.2	129.46	129.19	129.35	10277953.0
2011-01-18 12:00:00	SPY	ETF	129.35	129.39	129.26	129.35	8492454.0
2011-01-18 13:00:00	SPY	ETF	129.35	129.53	129.35	129.43	10614358.0
2011-01-18 14:00:00	SPY	ETF	129.42	129.56	129.38	129.515	9771538.0
2011-01-18 15:00:00	SPY	ETF	129.52	129.64	129.36	129.53	18051313.0
2011-01-18 16:00:00	SPY	ETF	129.54	130.01	129.2721	129.75	9781861.0
2011-01-18 17:00:00	SPY	ETF	129.75	129.82	129.5188	129.77	766932.0
2011-01-18 18:00:00	SPY	ETF	129.75	129.79	129.53	129.73	112558.0
2011-01-18 19:00:00	SPY	ETF	129.7	129.82	129.68	129.78	61123.0
2011-01-18 04:00:00	QQQ	ETF	56.62	56.65	56.57	56.62	3520.0
2011-01-18 05:00:00	QQQ	ETF	56.66	56.71	56.66	56.71	1300.0
2011-01-18 06:00:00	QQQ	ETF	56.69	56.76	56.69	56.75	8500.0
2011-01-18 07:00:00	QQQ	ETF	56.75	56.75	56.58	56.67	370643.0
2011-01-18 08:00:00	QQQ	ETF	56.67	56.67	56.52	56.54	698744.0
2011-01-18 09:00:00	QQQ	ETF	56.54	56.96	56.4983	56.77	15195716.0
2011-01-18 10:00:00	QQQ	ETF	56.77	56.94	56.72	56.8	7881248.0
2011-01-18 11:00:00	QQQ	ETF	56.8	57.01	56.79	56.971	5992288.0
2011-01-18 12:00:00	QQQ	ETF	56.975	57.05	56.9	57.01	5765092.0
2011-01-18 13:00:00	QQQ	ETF	57.01	57.16	57.01	57.08	4275168.0
2011-01-18 14:00:00	QQQ	ETF	57.07	57.14	57.02	57.13	3876295.0
2011-01-18 15:00:00	QQQ	ETF	57.14	57.23	57.06	57.16	7420742.0
2011-01-18 16:00:00	QQQ	ETF	57.17	57.79	57.085	57.35	7224825.0
2011-01-18 17:00:00	QQQ	ETF	57.36	57.44	57.25	57.3	1408288.0
2011-01-18 18:00:00	QQQ	ETF	57.28	57.31	57.26	57.27	234861.0
2011-01-18 19:00:00	QQQ	ETF	57.26	57.34	57.26	57.34	57545.0
2011-01-18 07:00:00	IWM	ETF	80.56	80.56	80.41	80.53	21959.0
2011-01-18 08:00:00	IWM	ETF	80.48	80.48	80.27	80.29	289300.0
2011-01-18 09:00:00	IWM	ETF	80.29	80.57	80.21	80.28	4469865.0
2011-01-18 10:00:00	IWM	ETF	80.29	80.33	79.87	79.955	11779660.0
2011-01-18 11:00:00	IWM	ETF	79.955	80.23	79.91	80.168	3168694.0
2011-01-18 12:00:00	IWM	ETF	80.17	80.24	80.04	80.18	2093198.0
2011-01-18 13:00:00	IWM	ETF	80.19	80.36	80.185	80.272	1536208.0
2011-01-18 14:00:00	IWM	ETF	80.28	80.45	80.24	80.4101	2859906.0
2011-01-18 15:00:00	IWM	ETF	80.42	80.63	80.24	80.62	5719245.0
2011-01-18 16:00:00	IWM	ETF	80.62	81.0	80.2296	80.79	1705664.0
2011-01-18 17:00:00	IWM	ETF	80.6097	80.83	80.6097	80.8	560247.0
2011-01-18 18:00:00	IWM	ETF	80.78	80.83	80.7	80.7	16385.0
2011-01-18 19:00:00	IWM	ETF	80.77	80.77	80.73	80.73	1872.0
2011-01-18 04:00:00	DIA	ETF	117.96	117.96	117.96	117.96	2000.0
2011-01-18 05:00:00	DIA	ETF	117.97	117.99	117.97	117.99	4100.0
2011-01-18 06:00:00	DIA	ETF	117.99	118.01	117.99	118.01	6400.0
2011-01-18 07:00:00	DIA	ETF	117.96	117.96	117.83	117.83	7700.0
2011-01-18 08:00:00	DIA	ETF	117.86	117.86	117.7	117.75	27070.0

> showing 50 of 5,463 rows — these rows as CSV

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