PREVIEW / etf_1hour / 2013-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-18.parquet
  size:    216 KB
  rows:    6,803

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
2013-11-18 04:00:00	SPY	ETF	179.75	179.86	179.59	179.83	50613.0
2013-11-18 05:00:00	SPY	ETF	179.84	180.07	179.84	180.02	19955.0
2013-11-18 06:00:00	SPY	ETF	180.03	180.22	180.01	180.22	65095.0
2013-11-18 07:00:00	SPY	ETF	180.23	180.3	180.11	180.13	435547.0
2013-11-18 08:00:00	SPY	ETF	180.14	180.24	179.7	180.22	1235550.0
2013-11-18 09:00:00	SPY	ETF	180.24	180.5	179.91	179.92	11963550.0
2013-11-18 10:00:00	SPY	ETF	179.91	180.27	179.79	180.26	10380913.0
2013-11-18 11:00:00	SPY	ETF	180.2599	180.41	180.07	180.12	8751835.0
2013-11-18 12:00:00	SPY	ETF	180.12	180.27	180.03	180.07	7294006.0
2013-11-18 13:00:00	SPY	ETF	180.07	180.25	180.03	180.2	6030461.0
2013-11-18 14:00:00	SPY	ETF	180.19	180.34	179.8	179.801	8265958.0
2013-11-18 15:00:00	SPY	ETF	179.8099	179.81	179.02	179.47	31806977.0
2013-11-18 16:00:00	SPY	ETF	179.46	180.39	179.36	179.5	7931169.0
2013-11-18 17:00:00	SPY	ETF	179.5	179.51	179.42	179.43	5856621.0
2013-11-18 18:00:00	SPY	ETF	179.45	179.48	179.31	179.42	46975.0
2013-11-18 19:00:00	SPY	ETF	179.41	179.57	179.4	179.49	142234.0
2013-11-18 04:00:00	QQQ	ETF	83.93	83.93	83.77	83.89	39100.0
2013-11-18 05:00:00	QQQ	ETF	83.91	83.97	83.91	83.97	5179.0
2013-11-18 06:00:00	QQQ	ETF	83.95	83.97	83.91	83.95	8547.0
2013-11-18 07:00:00	QQQ	ETF	83.97	83.99	83.93	83.94	21600.0
2013-11-18 08:00:00	QQQ	ETF	83.95	83.96	83.87	83.91	159145.0
2013-11-18 09:00:00	QQQ	ETF	83.93	84.105	83.77	83.77	5004805.0
2013-11-18 10:00:00	QQQ	ETF	83.771	83.94	83.59	83.91	6140531.0
2013-11-18 11:00:00	QQQ	ETF	83.91	83.97	83.73	83.76	2123876.0
2013-11-18 12:00:00	QQQ	ETF	83.76	83.89	83.73	83.75	1826694.0
2013-11-18 13:00:00	QQQ	ETF	83.7499	83.83	83.73	83.75	1659027.0
2013-11-18 14:00:00	QQQ	ETF	83.755	83.84	83.51	83.515	2495412.0
2013-11-18 15:00:00	QQQ	ETF	83.515	83.5299	82.98	83.16	10228877.0
2013-11-18 16:00:00	QQQ	ETF	83.16	83.956	83.07	83.13	1782112.0
2013-11-18 17:00:00	QQQ	ETF	83.15	83.19	83.15	83.19	19280.0
2013-11-18 18:00:00	QQQ	ETF	83.16	83.16	83.07	83.13	14000.0
2013-11-18 19:00:00	QQQ	ETF	83.15	83.22	83.14	83.14	14495.0
2013-11-18 06:00:00	IWM	ETF	111.1	111.1	111.1	111.1	100.0
2013-11-18 07:00:00	IWM	ETF	111.01	111.24	110.98	111.12	118300.0
2013-11-18 08:00:00	IWM	ETF	111.11	111.18	111.06	111.17	142930.0
2013-11-18 09:00:00	IWM	ETF	111.16	111.42	110.798	110.81	3648214.0
2013-11-18 10:00:00	IWM	ETF	110.804	111.18	110.57	111.18	4553446.0
2013-11-18 11:00:00	IWM	ETF	111.18	111.41	111.08	111.1674	3084641.0
2013-11-18 12:00:00	IWM	ETF	111.17	111.26	111.02	111.1	2274238.0
2013-11-18 13:00:00	IWM	ETF	111.1	111.15	110.92	110.98	1573154.0
2013-11-18 14:00:00	IWM	ETF	110.98	111.06	110.55	110.56	2926594.0
2013-11-18 15:00:00	IWM	ETF	110.55	110.56	109.75	110.07	9592782.0
2013-11-18 16:00:00	IWM	ETF	110.08	111.2684	110.03	110.05	700653.0
2013-11-18 17:00:00	IWM	ETF	110.13	110.19	110.03	110.12	36623.0
2013-11-18 18:00:00	IWM	ETF	110.09	110.13	110.09	110.09	1822.0
2013-11-18 19:00:00	IWM	ETF	110.27	110.28	110.26	110.26	2500.0
2013-11-18 05:00:00	DIA	ETF	159.3	159.45	159.3	159.45	800.0
2013-11-18 06:00:00	DIA	ETF	159.47	159.67	159.47	159.67	15500.0
2013-11-18 07:00:00	DIA	ETF	159.69	159.77	159.59	159.59	12400.0
2013-11-18 08:00:00	DIA	ETF	159.48	159.63	159.48	159.63	17200.0

> showing 50 of 6,803 rows — these rows as CSV

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