PREVIEW / etf_1hour / 2011-05-02

all etf 1-hour files

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

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-05-02 04:00:00	SPY	ETF	137.0	137.38	137.0	137.31	18655.0
2011-05-02 05:00:00	SPY	ETF	137.26	137.31	137.19	137.21	8400.0
2011-05-02 06:00:00	SPY	ETF	137.21	137.24	137.0	137.09	51140.0
2011-05-02 07:00:00	SPY	ETF	137.09	137.15	137.05	137.15	500952.0
2011-05-02 08:00:00	SPY	ETF	137.14	137.6	137.0025	137.17	2259218.0
2011-05-02 09:00:00	SPY	ETF	137.18	137.2	136.43	136.85	18708516.0
2011-05-02 10:00:00	SPY	ETF	136.85	137.18	136.76	137.02	17156145.0
2011-05-02 11:00:00	SPY	ETF	137.025	137.11	136.58	136.65	15082232.0
2011-05-02 12:00:00	SPY	ETF	136.64	136.71	136.15	136.31	24212010.0
2011-05-02 13:00:00	SPY	ETF	136.31	136.58	136.3	136.5	7224814.0
2011-05-02 14:00:00	SPY	ETF	136.5	136.65	136.24	136.27	9403893.0
2011-05-02 15:00:00	SPY	ETF	136.26	136.41	135.95	136.23	25519452.0
2011-05-02 16:00:00	SPY	ETF	136.23	136.3	136.16	136.21	5552196.0
2011-05-02 17:00:00	SPY	ETF	136.2	136.21	136.16	136.19	125614.0
2011-05-02 18:00:00	SPY	ETF	136.19	136.25	136.15	136.17	54235.0
2011-05-02 19:00:00	SPY	ETF	136.16	136.2	136.12	136.12	89569.0
2011-05-02 04:00:00	QQQ	ETF	59.4	59.4	59.34	59.34	1063.0
2011-05-02 05:00:00	QQQ	ETF	59.37	59.37	59.37	59.37	100.0
2011-05-02 06:00:00	QQQ	ETF	59.37	59.37	59.27	59.29	61500.0
2011-05-02 07:00:00	QQQ	ETF	59.29	59.3	59.25	59.3	68886.0
2011-05-02 08:00:00	QQQ	ETF	59.29	59.31	59.24	59.27	344836.0
2011-05-02 09:00:00	QQQ	ETF	59.27	59.28	58.99	59.06	6953609.0
2011-05-02 10:00:00	QQQ	ETF	59.07	59.34	59.02	59.25	8224822.0
2011-05-02 11:00:00	QQQ	ETF	59.25	59.31	59.0	59.051	5575294.0
2011-05-02 12:00:00	QQQ	ETF	59.05	59.11	58.82	58.94	6326842.0
2011-05-02 13:00:00	QQQ	ETF	58.94	59.14	58.93	59.12	5518381.0
2011-05-02 14:00:00	QQQ	ETF	59.13	59.22	59.01	59.03	4602162.0
2011-05-02 15:00:00	QQQ	ETF	59.025	59.12	58.86	58.9924	7790646.0
2011-05-02 16:00:00	QQQ	ETF	59.0	59.05	58.97	59.0	847404.0
2011-05-02 17:00:00	QQQ	ETF	59.01	59.01	58.98	58.98	4957.0
2011-05-02 18:00:00	QQQ	ETF	58.97	59.0	58.97	59.0	2178.0
2011-05-02 19:00:00	QQQ	ETF	58.96	59.0	58.96	59.0	22730.0
2011-05-02 04:00:00	IWM	ETF	86.84	86.92	86.84	86.92	2300.0
2011-05-02 05:00:00	IWM	ETF	86.85	86.85	86.85	86.85	125.0
2011-05-02 06:00:00	IWM	ETF	86.77	86.77	86.69	86.69	4300.0
2011-05-02 07:00:00	IWM	ETF	86.69	86.81	86.67	86.81	51705.0
2011-05-02 08:00:00	IWM	ETF	86.82	87.45	86.71	86.82	204047.0
2011-05-02 09:00:00	IWM	ETF	86.81	86.85	86.36	86.43	3727229.0
2011-05-02 10:00:00	IWM	ETF	86.43	86.73	86.29	86.52	6661165.0
2011-05-02 11:00:00	IWM	ETF	86.52	86.57	85.92	85.99	5906260.0
2011-05-02 12:00:00	IWM	ETF	85.99	86.01	85.48	85.62	6690255.0
2011-05-02 13:00:00	IWM	ETF	85.62	85.92	85.61	85.8	4314265.0
2011-05-02 14:00:00	IWM	ETF	85.8	85.9	85.58	85.62	4243189.0
2011-05-02 15:00:00	IWM	ETF	85.61	85.76	85.28	85.38	11129398.0
2011-05-02 16:00:00	IWM	ETF	85.38	85.43	85.31	85.36	1546523.0
2011-05-02 17:00:00	IWM	ETF	85.37	85.37	85.3	85.3	14960.0
2011-05-02 18:00:00	IWM	ETF	85.31	85.31	85.31	85.31	300.0
2011-05-02 19:00:00	IWM	ETF	85.33	85.33	85.33	85.33	6085.0
2011-05-02 04:00:00	DIA	ETF	128.65	128.77	128.65	128.77	1000.0
2011-05-02 05:00:00	DIA	ETF	128.68	128.75	128.68	128.75	615.0

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

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