PREVIEW / etf_1hour / 2012-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-28.parquet
  size:    187 KB
  rows:    5,815

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
2012-02-28 04:00:00	SPY	ETF	137.47	137.72	137.46	137.66	94485.0
2012-02-28 05:00:00	SPY	ETF	137.62	137.69	137.6	137.65	30700.0
2012-02-28 06:00:00	SPY	ETF	137.7	137.75	137.61	137.71	131630.0
2012-02-28 07:00:00	SPY	ETF	137.62	137.8	137.62	137.69	269246.0
2012-02-28 08:00:00	SPY	ETF	137.67	137.72	137.11	137.22	4445106.0
2012-02-28 09:00:00	SPY	ETF	137.22	137.52	136.93	137.52	15666246.0
2012-02-28 10:00:00	SPY	ETF	137.37	137.72	137.05	137.48	33689448.0
2012-02-28 11:00:00	SPY	ETF	137.48	137.66	137.4	137.52	15683235.0
2012-02-28 12:00:00	SPY	ETF	137.52	137.6	137.43	137.56	7250213.0
2012-02-28 13:00:00	SPY	ETF	137.56	137.6	137.09	137.18	13255975.0
2012-02-28 14:00:00	SPY	ETF	137.18	137.33	137.09	137.29	13762462.0
2012-02-28 15:00:00	SPY	ETF	137.29	137.66	137.24	137.56	19430426.0
2012-02-28 16:00:00	SPY	ETF	137.56	137.65	136.94	137.55	5016325.0
2012-02-28 17:00:00	SPY	ETF	137.55	137.61	137.3741	137.55	79054.0
2012-02-28 18:00:00	SPY	ETF	137.56	137.63	137.54	137.6	134388.0
2012-02-28 19:00:00	SPY	ETF	137.58	137.71	137.54	137.71	75801.0
2012-02-28 06:00:00	QQQ	ETF	64.29	64.29	64.29	64.29	300.0
2012-02-28 07:00:00	QQQ	ETF	64.23	64.32	64.23	64.29	47753.0
2012-02-28 08:00:00	QQQ	ETF	64.3	64.3	64.07	64.08	371911.0
2012-02-28 09:00:00	QQQ	ETF	64.08	64.39	64.03	64.35	4697921.0
2012-02-28 10:00:00	QQQ	ETF	64.32	64.5999	64.21	64.5	12680547.0
2012-02-28 11:00:00	QQQ	ETF	64.4991	64.58	64.45	64.528	3688868.0
2012-02-28 12:00:00	QQQ	ETF	64.52	64.64	64.5144	64.619	2862301.0
2012-02-28 13:00:00	QQQ	ETF	64.615	64.65	64.35	64.4	4916329.0
2012-02-28 14:00:00	QQQ	ETF	64.39	64.48	64.32	64.44	5899011.0
2012-02-28 15:00:00	QQQ	ETF	64.44	64.6801	64.44	64.67	5447559.0
2012-02-28 16:00:00	QQQ	ETF	64.67	64.7	64.57	64.6	1058396.0
2012-02-28 17:00:00	QQQ	ETF	64.58	64.64	64.58	64.64	154857.0
2012-02-28 18:00:00	QQQ	ETF	64.62	64.65	64.62	64.65	11070.0
2012-02-28 19:00:00	QQQ	ETF	64.63	64.68	64.61	64.68	7425.0
2012-02-28 04:00:00	IWM	ETF	82.95	82.95	82.95	82.95	364.0
2012-02-28 06:00:00	IWM	ETF	82.94	83.0	82.94	83.0	860.0
2012-02-28 07:00:00	IWM	ETF	82.92	83.09	82.92	83.08	7375.0
2012-02-28 08:00:00	IWM	ETF	82.99	83.0	82.5	82.59	388171.0
2012-02-28 09:00:00	IWM	ETF	82.59	82.75	82.33	82.65	3630639.0
2012-02-28 10:00:00	IWM	ETF	82.65	83.02	82.47	82.95	9259089.0
2012-02-28 11:00:00	IWM	ETF	82.95	83.06	82.62	82.71	5173721.0
2012-02-28 12:00:00	IWM	ETF	82.71	82.76	82.51	82.67	3417218.0
2012-02-28 13:00:00	IWM	ETF	82.68	82.75	81.85	81.983	6280940.0
2012-02-28 14:00:00	IWM	ETF	81.98	82.2	81.8415	82.09	6614553.0
2012-02-28 15:00:00	IWM	ETF	82.09	82.33	81.99	82.28	6021714.0
2012-02-28 16:00:00	IWM	ETF	82.29	82.43	82.26	82.33	545500.0
2012-02-28 17:00:00	IWM	ETF	82.35	82.41	82.35	82.39	6100.0
2012-02-28 18:00:00	IWM	ETF	82.4	82.4	82.39	82.39	500.0
2012-02-28 19:00:00	IWM	ETF	82.38	82.4	82.37	82.4	6300.0
2012-02-28 07:00:00	DIA	ETF	130.08	130.1	130.08	130.1	200.0
2012-02-28 08:00:00	DIA	ETF	130.07	130.07	129.63	129.68	48964.0
2012-02-28 09:00:00	DIA	ETF	129.68	129.85	129.34	129.76	582522.0
2012-02-28 10:00:00	DIA	ETF	129.77	130.0	129.52	129.86	1426585.0
2012-02-28 11:00:00	DIA	ETF	129.86	130.01	129.79	129.86	597475.0

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

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