PREVIEW / etf_1hour / 2013-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-02.parquet
  size:    206 KB
  rows:    6,387

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-10-02 04:00:00	SPY	ETF	168.65	168.65	168.04	168.19	126523.0
2013-10-02 05:00:00	SPY	ETF	168.17	168.48	168.1	168.21	55820.0
2013-10-02 06:00:00	SPY	ETF	168.23	168.31	168.12	168.27	92169.0
2013-10-02 07:00:00	SPY	ETF	168.26	168.66	168.21	168.56	1058247.0
2013-10-02 08:00:00	SPY	ETF	168.6186	168.95	168.03	168.17	2182783.0
2013-10-02 09:00:00	SPY	ETF	168.16	169.3422	168.11	168.337	15930154.0
2013-10-02 10:00:00	SPY	ETF	168.33	168.39	167.83	168.3	17397911.0
2013-10-02 11:00:00	SPY	ETF	168.3	168.75	168.25	168.65	14015822.0
2013-10-02 12:00:00	SPY	ETF	168.65	169.05	168.65	168.8973	7515871.0
2013-10-02 13:00:00	SPY	ETF	168.89	169.21	168.85	169.025	8518119.0
2013-10-02 14:00:00	SPY	ETF	169.025	169.03	168.68	168.79	8415812.0
2013-10-02 15:00:00	SPY	ETF	168.79	169.21	168.7	169.15	16186023.0
2013-10-02 16:00:00	SPY	ETF	169.17	169.3422	168.7	168.83	19259034.0
2013-10-02 17:00:00	SPY	ETF	168.83	168.87	168.5615	168.81	1604317.0
2013-10-02 18:00:00	SPY	ETF	168.81	168.81	168.6	168.61	125503.0
2013-10-02 19:00:00	SPY	ETF	168.61	168.61	168.01	168.25	365365.0
2013-10-02 04:00:00	QQQ	ETF	79.33	79.33	79.12	79.22	59550.0
2013-10-02 05:00:00	QQQ	ETF	79.23	79.35	79.17	79.24	35450.0
2013-10-02 06:00:00	QQQ	ETF	79.25	79.29	79.19	79.25	47250.0
2013-10-02 07:00:00	QQQ	ETF	79.23	79.44	79.22	79.4	101990.0
2013-10-02 08:00:00	QQQ	ETF	79.4	79.44	79.16	79.18	365516.0
2013-10-02 09:00:00	QQQ	ETF	79.18	79.4599	79.1	79.389	3949238.0
2013-10-02 10:00:00	QQQ	ETF	79.38	79.46	79.06	79.37	4603380.0
2013-10-02 11:00:00	QQQ	ETF	79.37	79.56	79.35	79.51	2468615.0
2013-10-02 12:00:00	QQQ	ETF	79.51	79.67	79.471	79.569	1894769.0
2013-10-02 13:00:00	QQQ	ETF	79.56	79.76	79.49	79.699	1723159.0
2013-10-02 14:00:00	QQQ	ETF	79.695	79.695	79.47	79.549	1835759.0
2013-10-02 15:00:00	QQQ	ETF	79.54	79.68	79.47	79.65	3190670.0
2013-10-02 16:00:00	QQQ	ETF	79.65	79.68	79.156	79.5	2605933.0
2013-10-02 17:00:00	QQQ	ETF	79.49	79.53	79.4075	79.4075	295003.0
2013-10-02 18:00:00	QQQ	ETF	79.51	79.51	79.44	79.45	10681.0
2013-10-02 19:00:00	QQQ	ETF	79.45	79.45	79.17	79.32	26285.0
2013-10-02 05:00:00	IWM	ETF	107.31	107.31	107.21	107.21	2900.0
2013-10-02 06:00:00	IWM	ETF	107.21	107.21	107.1	107.1	450.0
2013-10-02 07:00:00	IWM	ETF	107.14	107.45	107.14	107.37	105800.0
2013-10-02 08:00:00	IWM	ETF	107.22	107.39	106.92	107.05	487345.0
2013-10-02 09:00:00	IWM	ETF	107.02	107.38	107.01	107.26	3479965.0
2013-10-02 10:00:00	IWM	ETF	107.23	107.33	106.85	107.21	4887651.0
2013-10-02 11:00:00	IWM	ETF	107.2	107.51	107.18	107.41	2713781.0
2013-10-02 12:00:00	IWM	ETF	107.41	107.65	107.36	107.559	1823222.0
2013-10-02 13:00:00	IWM	ETF	107.559	107.75	107.525	107.58	2003081.0
2013-10-02 14:00:00	IWM	ETF	107.59	107.63	107.25	107.345	2911242.0
2013-10-02 15:00:00	IWM	ETF	107.33	107.475	107.24	107.43	5527213.0
2013-10-02 16:00:00	IWM	ETF	107.44	107.9322	107.04	107.1	1609592.0
2013-10-02 17:00:00	IWM	ETF	107.12	107.3066	107.08	107.08	231391.0
2013-10-02 18:00:00	IWM	ETF	107.13	107.26	107.12	107.13	39950.0
2013-10-02 19:00:00	IWM	ETF	107.09	107.09	106.75	106.8	32251.0
2013-10-02 04:00:00	DIA	ETF	150.7	150.75	150.7	150.75	600.0
2013-10-02 08:00:00	DIA	ETF	151.03	151.16	150.75	150.77	9990.0
2013-10-02 09:00:00	DIA	ETF	150.78	151.01	150.38	150.56	1449347.0

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

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