PREVIEW / etf_1hour / 2015-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-02.parquet
  size:    241 KB
  rows:    7,636

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
2015-06-02 04:00:00	SPY	ETF	211.61	211.61	210.01	210.2	45513.0
2015-06-02 05:00:00	SPY	ETF	210.26	210.65	210.16	210.51	52357.0
2015-06-02 06:00:00	SPY	ETF	210.57	211.56	210.57	211.06	189719.0
2015-06-02 07:00:00	SPY	ETF	211.12	211.27	210.81	211.01	419196.0
2015-06-02 08:00:00	SPY	ETF	211.01	211.56	210.46	211.1	1775824.0
2015-06-02 09:00:00	SPY	ETF	211.11	211.14	210.27	210.769	18742520.0
2015-06-02 10:00:00	SPY	ETF	210.77	211.47	210.56	211.15	15427153.0
2015-06-02 11:00:00	SPY	ETF	211.16	211.44	211.04	211.37	6213345.0
2015-06-02 12:00:00	SPY	ETF	211.38	212.13	211.35	212.0	10649720.0
2015-06-02 13:00:00	SPY	ETF	212.0	212.19	211.87	212.11	5376400.0
2015-06-02 14:00:00	SPY	ETF	212.12	212.15	211.38	211.66	8759438.0
2015-06-02 15:00:00	SPY	ETF	211.66	211.665	211.24	211.37	15880221.0
2015-06-02 16:00:00	SPY	ETF	211.36	211.39	211.18	211.3	5635206.0
2015-06-02 17:00:00	SPY	ETF	211.3	211.3	211.25	211.29	52007.0
2015-06-02 18:00:00	SPY	ETF	211.3	211.39	211.3	211.38	45133.0
2015-06-02 19:00:00	SPY	ETF	211.36	211.42	211.34	211.4	16722.0
2015-06-02 04:00:00	QQQ	ETF	110.24	110.24	109.54	109.54	30371.0
2015-06-02 05:00:00	QQQ	ETF	109.6	109.6	109.6	109.6	100.0
2015-06-02 06:00:00	QQQ	ETF	109.85	110.43	109.85	110.26	10700.0
2015-06-02 07:00:00	QQQ	ETF	110.28	110.36	110.12	110.18	36160.0
2015-06-02 08:00:00	QQQ	ETF	110.2	110.26	109.81	110.18	105597.0
2015-06-02 09:00:00	QQQ	ETF	110.15	110.15	109.47	109.79	4494763.0
2015-06-02 10:00:00	QQQ	ETF	109.79	110.26	109.66	110.01	3453918.0
2015-06-02 11:00:00	QQQ	ETF	110.01	110.17	109.91	110.0957	1245826.0
2015-06-02 12:00:00	QQQ	ETF	110.08	110.52	110.07	110.47	2130042.0
2015-06-02 13:00:00	QQQ	ETF	110.465	110.61	110.4001	110.53	1508747.0
2015-06-02 14:00:00	QQQ	ETF	110.5365	110.55	110.051	110.2	1611171.0
2015-06-02 15:00:00	QQQ	ETF	110.2	110.225	110.03	110.06	2853026.0
2015-06-02 16:00:00	QQQ	ETF	110.06	110.09	109.89	109.92	418025.0
2015-06-02 17:00:00	QQQ	ETF	109.93	109.95	109.91	109.91	4000.0
2015-06-02 18:00:00	QQQ	ETF	109.96	109.97	109.95	109.97	8629.0
2015-06-02 19:00:00	QQQ	ETF	109.96	110.0	109.95	110.0	13200.0
2015-06-02 04:00:00	IWM	ETF	124.11	124.11	123.01	123.01	700.0
2015-06-02 05:00:00	IWM	ETF	123.3	123.3	123.13	123.19	500.0
2015-06-02 06:00:00	IWM	ETF	123.7	123.88	123.7	123.88	900.0
2015-06-02 07:00:00	IWM	ETF	123.73	123.82	123.62	123.68	44050.0
2015-06-02 08:00:00	IWM	ETF	123.69	123.86	123.52	123.73	64454.0
2015-06-02 09:00:00	IWM	ETF	123.65	123.98	123.48	123.9	2634877.0
2015-06-02 10:00:00	IWM	ETF	123.88	124.68	123.7	124.32	2928610.0
2015-06-02 11:00:00	IWM	ETF	124.311	124.63	124.21	124.525	1362317.0
2015-06-02 12:00:00	IWM	ETF	124.515	125.31	124.48	125.22	3413868.0
2015-06-02 13:00:00	IWM	ETF	125.21	125.27	124.9002	125.02	1673390.0
2015-06-02 14:00:00	IWM	ETF	125.0	125.01	124.44	124.65	2567222.0
2015-06-02 15:00:00	IWM	ETF	124.6499	124.65	124.34	124.52	3549008.0
2015-06-02 16:00:00	IWM	ETF	124.5	124.54	124.2967	124.52	6662765.0
2015-06-02 18:00:00	IWM	ETF	124.5	124.5	124.5	124.5	500.0
2015-06-02 06:00:00	DIA	ETF	180.3	180.35	180.05	180.1	900.0
2015-06-02 07:00:00	DIA	ETF	180.2	180.2	180.2	180.2	200.0
2015-06-02 08:00:00	DIA	ETF	180.0	180.2	179.65	180.2	14400.0
2015-06-02 09:00:00	DIA	ETF	180.0	180.16	179.27	179.79	1126472.0

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

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