PREVIEW / etf_1hour / 2011-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-16.parquet
  size:    173 KB
  rows:    5,360

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-02-16 04:00:00	SPY	ETF	132.9	133.65	132.9	133.58	6938.0
2011-02-16 05:00:00	SPY	ETF	133.56	133.59	133.55	133.55	900.0
2011-02-16 06:00:00	SPY	ETF	133.5	133.53	133.5	133.52	2200.0
2011-02-16 07:00:00	SPY	ETF	133.5	133.52	133.44	133.52	321060.0
2011-02-16 08:00:00	SPY	ETF	133.52	133.79	133.46	133.47	1235981.0
2011-02-16 09:00:00	SPY	ETF	133.47	133.65	133.38	133.6362	13308040.0
2011-02-16 10:00:00	SPY	ETF	133.64	134.01	133.44	133.99	20789243.0
2011-02-16 11:00:00	SPY	ETF	133.98	134.01	133.59	133.75	17614888.0
2011-02-16 12:00:00	SPY	ETF	133.75	133.77	133.19	133.6	22253861.0
2011-02-16 13:00:00	SPY	ETF	133.6	133.79	133.49	133.78	11410511.0
2011-02-16 14:00:00	SPY	ETF	133.79	133.89	133.5	133.78	15344617.0
2011-02-16 15:00:00	SPY	ETF	133.78	133.96	133.75	133.83	19233004.0
2011-02-16 16:00:00	SPY	ETF	133.82	133.91	133.63	133.76	7952478.0
2011-02-16 17:00:00	SPY	ETF	133.74	133.76	133.6	133.69	158304.0
2011-02-16 18:00:00	SPY	ETF	133.68	133.82	133.66	133.7	118820.0
2011-02-16 19:00:00	SPY	ETF	133.71	133.71	133.66	133.67	35734.0
2011-02-16 04:00:00	QQQ	ETF	58.69	58.71	58.67	58.68	6488.0
2011-02-16 05:00:00	QQQ	ETF	58.69	58.69	58.65	58.68	4200.0
2011-02-16 06:00:00	QQQ	ETF	58.62	58.62	58.62	58.62	100.0
2011-02-16 07:00:00	QQQ	ETF	58.66	58.66	58.63	58.63	89862.0
2011-02-16 08:00:00	QQQ	ETF	58.65	58.79	58.65	58.67	379465.0
2011-02-16 09:00:00	QQQ	ETF	58.67	58.78	58.62	58.75	6743072.0
2011-02-16 10:00:00	QQQ	ETF	58.74	59.03	58.68	59.025	10013310.0
2011-02-16 11:00:00	QQQ	ETF	59.03	59.04	58.845	58.92	8405862.0
2011-02-16 12:00:00	QQQ	ETF	58.92	58.93	58.63	58.82	6200558.0
2011-02-16 13:00:00	QQQ	ETF	58.82	58.93	58.76	58.92	2418194.0
2011-02-16 14:00:00	QQQ	ETF	58.93	58.96	58.76	58.9067	6323476.0
2011-02-16 15:00:00	QQQ	ETF	58.9	58.98	58.85	58.89	6688805.0
2011-02-16 16:00:00	QQQ	ETF	58.89	58.9	58.71	58.74	1274308.0
2011-02-16 17:00:00	QQQ	ETF	58.77	58.8	58.7	58.72	45630.0
2011-02-16 18:00:00	QQQ	ETF	58.76	58.76	58.73	58.76	108375.0
2011-02-16 19:00:00	QQQ	ETF	58.73	58.76	58.71	58.72	12635.0
2011-02-16 06:00:00	IWM	ETF	82.28	82.3	82.28	82.3	2600.0
2011-02-16 07:00:00	IWM	ETF	82.27	82.32	82.26	82.3	49900.0
2011-02-16 08:00:00	IWM	ETF	82.58	82.58	82.25	82.26	134033.0
2011-02-16 09:00:00	IWM	ETF	82.25	82.49	82.19	82.48	4333343.0
2011-02-16 10:00:00	IWM	ETF	82.47	82.82	82.37	82.77	4852900.0
2011-02-16 11:00:00	IWM	ETF	82.77	82.79	82.51	82.64	2971040.0
2011-02-16 12:00:00	IWM	ETF	82.64	82.6599	82.1783	82.5	4042237.0
2011-02-16 13:00:00	IWM	ETF	82.51	82.7	82.4	82.68	1871898.0
2011-02-16 14:00:00	IWM	ETF	82.68	82.72	82.34	82.66	4941870.0
2011-02-16 15:00:00	IWM	ETF	82.66	82.77	82.64	82.68	5137904.0
2011-02-16 16:00:00	IWM	ETF	82.68	82.79	82.59	82.66	3604720.0
2011-02-16 17:00:00	IWM	ETF	82.69	82.7	82.62	82.7	27275.0
2011-02-16 18:00:00	IWM	ETF	82.62	82.67	82.62	82.67	500.0
2011-02-16 19:00:00	IWM	ETF	82.63	82.63	82.6	82.6	500.0
2011-02-16 07:00:00	DIA	ETF	122.56	122.57	122.53	122.53	4000.0
2011-02-16 08:00:00	DIA	ETF	122.57	122.69	122.53	122.59	25514.0
2011-02-16 09:00:00	DIA	ETF	122.57	122.79	122.47	122.78	489986.0
2011-02-16 10:00:00	DIA	ETF	122.78	123.06	122.64	123.02	1042930.0

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

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