PREVIEW / etf_1hour / 2013-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-02.parquet
  size:    215 KB
  rows:    6,738

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-12-02 04:00:00	SPY	ETF	180.89	181.0	180.87	180.93	900.0
2013-12-02 05:00:00	SPY	ETF	180.89	180.89	180.7	180.8	1700.0
2013-12-02 06:00:00	SPY	ETF	180.85	180.89	180.8	180.8	13991.0
2013-12-02 07:00:00	SPY	ETF	180.8	181.005	180.7	181.0	282291.0
2013-12-02 08:00:00	SPY	ETF	181.0	181.05	180.82	180.95	415819.0
2013-12-02 09:00:00	SPY	ETF	180.95	181.22	180.67	180.79	13083553.0
2013-12-02 10:00:00	SPY	ETF	180.8	181.16	180.63	181.03	13680775.0
2013-12-02 11:00:00	SPY	ETF	181.04	181.29	180.95	181.22	7353029.0
2013-12-02 12:00:00	SPY	ETF	181.225	181.43	181.19	181.365	4649761.0
2013-12-02 13:00:00	SPY	ETF	181.36	181.375	181.05	181.14	8103409.0
2013-12-02 14:00:00	SPY	ETF	181.14	181.18	180.76	180.97	7387008.0
2013-12-02 15:00:00	SPY	ETF	180.97	181.01	180.25	180.53	23953370.0
2013-12-02 16:00:00	SPY	ETF	180.52	180.987	180.4409	180.53	18371013.0
2013-12-02 17:00:00	SPY	ETF	180.54	180.54	180.48	180.52	30997.0
2013-12-02 18:00:00	SPY	ETF	180.53	180.65	180.48	180.59	117177.0
2013-12-02 19:00:00	SPY	ETF	180.6	180.66	180.53	180.65	35650.0
2013-12-02 04:00:00	QQQ	ETF	85.71	85.72	85.71	85.72	1400.0
2013-12-02 05:00:00	QQQ	ETF	85.68	85.71	85.65	85.65	5600.0
2013-12-02 06:00:00	QQQ	ETF	85.68	85.74	85.68	85.71	4500.0
2013-12-02 07:00:00	QQQ	ETF	85.71	85.79	85.69	85.79	4900.0
2013-12-02 08:00:00	QQQ	ETF	85.69	85.8	85.69	85.78	116048.0
2013-12-02 09:00:00	QQQ	ETF	85.78	85.96	85.57	85.5899	3915428.0
2013-12-02 10:00:00	QQQ	ETF	85.59	85.75	85.5	85.68	4505138.0
2013-12-02 11:00:00	QQQ	ETF	85.68	85.72	85.51	85.62	2145005.0
2013-12-02 12:00:00	QQQ	ETF	85.63	85.77	85.61	85.73	2187732.0
2013-12-02 13:00:00	QQQ	ETF	85.73	85.75	85.59	85.645	1869465.0
2013-12-02 14:00:00	QQQ	ETF	85.64	85.67	85.485	85.66	2055950.0
2013-12-02 15:00:00	QQQ	ETF	85.67	85.68	85.35	85.47	5102166.0
2013-12-02 16:00:00	QQQ	ETF	85.47	85.74	85.47	85.53	2083679.0
2013-12-02 17:00:00	QQQ	ETF	85.52	85.53	85.52	85.53	13550.0
2013-12-02 18:00:00	QQQ	ETF	85.51	85.59	85.51	85.55	7500.0
2013-12-02 19:00:00	QQQ	ETF	85.56	85.59	85.55	85.58	11870.0
2013-12-02 04:00:00	IWM	ETF	113.41	113.41	113.41	113.41	1799.0
2013-12-02 07:00:00	IWM	ETF	113.43	113.46	113.34	113.46	26869.0
2013-12-02 08:00:00	IWM	ETF	113.52	113.58	113.47	113.53	273402.0
2013-12-02 09:00:00	IWM	ETF	113.54	113.76	113.06	113.12	5485861.0
2013-12-02 10:00:00	IWM	ETF	113.12	113.24	112.91	113.2101	7351273.0
2013-12-02 11:00:00	IWM	ETF	113.22	113.32	112.85	113.12	4166022.0
2013-12-02 12:00:00	IWM	ETF	113.11	113.18	112.97	113.1	2718407.0
2013-12-02 13:00:00	IWM	ETF	113.1	113.1	112.45	112.5	4516860.0
2013-12-02 14:00:00	IWM	ETF	112.5	112.53	112.06	112.43	5332198.0
2013-12-02 15:00:00	IWM	ETF	112.43	112.53	112.055	112.37	8494536.0
2013-12-02 16:00:00	IWM	ETF	112.37	113.71	112.2241	112.42	2380138.0
2013-12-02 17:00:00	IWM	ETF	112.37	112.4	112.35	112.35	64050.0
2013-12-02 18:00:00	IWM	ETF	112.43	112.5	112.43	112.46	3940.0
2013-12-02 19:00:00	IWM	ETF	112.47	112.47	112.4	112.4	690.0
2013-12-02 07:00:00	DIA	ETF	160.63	160.63	160.63	160.63	865.0
2013-12-02 08:00:00	DIA	ETF	160.64	160.77	160.64	160.68	2670.0
2013-12-02 09:00:00	DIA	ETF	160.7	160.84	160.17	160.3	880098.0
2013-12-02 10:00:00	DIA	ETF	160.28	160.61	160.14	160.43	1055941.0

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

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