PREVIEW / etf_1hour / 2011-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-02.parquet
  size:    184 KB
  rows:    5,686

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-12-02 04:00:00	SPY	ETF	125.95	126.39	125.95	126.27	56429.0
2011-12-02 05:00:00	SPY	ETF	126.26	126.4	126.14	126.4	14317.0
2011-12-02 06:00:00	SPY	ETF	126.25	126.5	126.19	126.36	80201.0
2011-12-02 07:00:00	SPY	ETF	126.3	126.75	126.14	126.36	1270363.0
2011-12-02 08:00:00	SPY	ETF	126.37	126.83	126.06	126.3	9008620.0
2011-12-02 09:00:00	SPY	ETF	126.3	126.35	125.7	126.03	22971702.0
2011-12-02 10:00:00	SPY	ETF	126.03	126.5	125.98	126.2199	32475400.0
2011-12-02 11:00:00	SPY	ETF	126.21	126.31	125.22	125.52	36390927.0
2011-12-02 12:00:00	SPY	ETF	125.52	125.8	125.32	125.7	17858633.0
2011-12-02 13:00:00	SPY	ETF	125.69	125.75	125.36	125.5	13862767.0
2011-12-02 14:00:00	SPY	ETF	125.51	125.56	125.08	125.14	22870255.0
2011-12-02 15:00:00	SPY	ETF	125.14	125.42	124.78	124.83	33531752.0
2011-12-02 16:00:00	SPY	ETF	124.84	125.661	124.82	125.0	19974229.0
2011-12-02 17:00:00	SPY	ETF	125.0	125.03	124.9	124.92	1423526.0
2011-12-02 18:00:00	SPY	ETF	124.92	125.05	124.86	124.97	301834.0
2011-12-02 19:00:00	SPY	ETF	124.97	125.0	124.92	124.92	39108.0
2011-12-02 04:00:00	QQQ	ETF	57.17	57.49	57.17	57.44	2252.0
2011-12-02 05:00:00	QQQ	ETF	57.48	57.48	57.41	57.43	2200.0
2011-12-02 06:00:00	QQQ	ETF	57.45	57.48	57.45	57.47	2300.0
2011-12-02 07:00:00	QQQ	ETF	57.45	57.62	57.4	57.49	87863.0
2011-12-02 08:00:00	QQQ	ETF	57.46	57.66	57.16	57.35	1040825.0
2011-12-02 09:00:00	QQQ	ETF	57.37	57.4	56.99	57.18	6539112.0
2011-12-02 10:00:00	QQQ	ETF	57.18	57.32	57.13	57.175	6120628.0
2011-12-02 11:00:00	QQQ	ETF	57.16	57.215	56.76	56.885	5826050.0
2011-12-02 12:00:00	QQQ	ETF	56.88	56.965	56.78	56.925	1928236.0
2011-12-02 13:00:00	QQQ	ETF	56.92	56.95	56.77	56.858	1983394.0
2011-12-02 14:00:00	QQQ	ETF	56.85	56.88	56.7	56.75	4349515.0
2011-12-02 15:00:00	QQQ	ETF	56.742	56.835	56.57	56.59	6927224.0
2011-12-02 16:00:00	QQQ	ETF	56.6	56.7479	56.59	56.65	1569363.0
2011-12-02 17:00:00	QQQ	ETF	56.62	56.69	56.62	56.69	12524.0
2011-12-02 18:00:00	QQQ	ETF	56.67	56.7	56.62	56.62	13662.0
2011-12-02 19:00:00	QQQ	ETF	56.62	56.69	56.61	56.61	13809.0
2011-12-02 04:00:00	IWM	ETF	73.99	74.07	73.99	74.05	3076.0
2011-12-02 05:00:00	IWM	ETF	74.15	74.15	74.15	74.15	200.0
2011-12-02 06:00:00	IWM	ETF	74.12	74.12	74.12	74.12	100.0
2011-12-02 07:00:00	IWM	ETF	74.11	74.46	74.01	74.32	180157.0
2011-12-02 08:00:00	IWM	ETF	74.3	74.7	74.07	74.25	1328046.0
2011-12-02 09:00:00	IWM	ETF	74.26	74.28	73.8599	74.16	6593498.0
2011-12-02 10:00:00	IWM	ETF	74.16	74.63	74.12	74.43	8195313.0
2011-12-02 11:00:00	IWM	ETF	74.42	74.49	73.59	73.84	7050529.0
2011-12-02 12:00:00	IWM	ETF	73.85	74.1	73.66	73.965	2804972.0
2011-12-02 13:00:00	IWM	ETF	73.96	74.03	73.67	73.78	2852703.0
2011-12-02 14:00:00	IWM	ETF	73.79	73.875	73.31	73.63	5678499.0
2011-12-02 15:00:00	IWM	ETF	73.62	73.78	73.39	73.43	7454122.0
2011-12-02 16:00:00	IWM	ETF	73.44	73.53	73.38	73.51	1433404.0
2011-12-02 17:00:00	IWM	ETF	73.49	73.49	73.42	73.43	6898.0
2011-12-02 18:00:00	IWM	ETF	73.42	73.43	73.4	73.43	11456.0
2011-12-02 19:00:00	IWM	ETF	73.41	73.45	73.38	73.41	4109.0
2011-12-02 07:00:00	DIA	ETF	121.48	121.68	121.48	121.61	4300.0
2011-12-02 08:00:00	DIA	ETF	121.26	121.78	120.49	121.21	49490.0

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

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