PREVIEW / etf_1hour / 2011-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-16.parquet
  size:    183 KB
  rows:    5,604

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-16 04:00:00	SPY	ETF	133.72	133.72	133.43	133.43	8338.0
2011-05-16 05:00:00	SPY	ETF	133.42	133.42	133.16	133.21	37600.0
2011-05-16 06:00:00	SPY	ETF	133.25	133.35	133.21	133.3	75950.0
2011-05-16 07:00:00	SPY	ETF	133.33	133.52	133.23	133.52	580283.0
2011-05-16 08:00:00	SPY	ETF	133.52	134.04	133.31	133.46	2250761.0
2011-05-16 09:00:00	SPY	ETF	133.46	133.88	133.3	133.72	17903930.0
2011-05-16 10:00:00	SPY	ETF	133.72	134.46	133.685	134.44	19937120.0
2011-05-16 11:00:00	SPY	ETF	134.44	134.61	134.1	134.18	16555010.0
2011-05-16 12:00:00	SPY	ETF	134.185	134.22	133.64	133.66	13319903.0
2011-05-16 13:00:00	SPY	ETF	133.67	133.93	133.46	133.8	11176661.0
2011-05-16 14:00:00	SPY	ETF	133.8	134.015	133.36	133.53	14978659.0
2011-05-16 15:00:00	SPY	ETF	133.53	133.81	132.97	133.21	33406554.0
2011-05-16 16:00:00	SPY	ETF	133.21	133.7558	132.5	132.74	8460941.0
2011-05-16 17:00:00	SPY	ETF	132.74	132.78	132.63	132.69	297811.0
2011-05-16 18:00:00	SPY	ETF	132.72	133.19	132.7	132.74	156452.0
2011-05-16 19:00:00	SPY	ETF	132.79	132.81	132.65	132.72	50118.0
2011-05-16 05:00:00	QQQ	ETF	58.13	58.17	58.11	58.17	36500.0
2011-05-16 06:00:00	QQQ	ETF	58.2	58.21	58.2	58.21	20000.0
2011-05-16 07:00:00	QQQ	ETF	58.16	58.2	58.1	58.18	28195.0
2011-05-16 08:00:00	QQQ	ETF	58.2	58.25	58.14	58.17	349985.0
2011-05-16 09:00:00	QQQ	ETF	58.19	58.269	58.0	58.17	6267242.0
2011-05-16 10:00:00	QQQ	ETF	58.16	58.29	58.12	58.2199	7608441.0
2011-05-16 11:00:00	QQQ	ETF	58.22	58.32	57.96	57.975	6383328.0
2011-05-16 12:00:00	QQQ	ETF	57.975	57.99	57.645	57.66	7151014.0
2011-05-16 13:00:00	QQQ	ETF	57.66	57.76	57.53	57.6805	4546313.0
2011-05-16 14:00:00	QQQ	ETF	57.68	57.8	57.45	57.521	4897384.0
2011-05-16 15:00:00	QQQ	ETF	57.53	57.65	57.27	57.4	12412088.0
2011-05-16 16:00:00	QQQ	ETF	57.4	57.4547	57.18	57.25	3826109.0
2011-05-16 17:00:00	QQQ	ETF	57.24	57.27	57.21	57.24	109985.0
2011-05-16 18:00:00	QQQ	ETF	57.29	57.4	57.23	57.27	96945.0
2011-05-16 19:00:00	QQQ	ETF	57.26	57.27	57.18	57.18	18995.0
2011-05-16 05:00:00	IWM	ETF	82.82	82.82	82.82	82.82	100.0
2011-05-16 06:00:00	IWM	ETF	82.84	82.84	82.75	82.78	3500.0
2011-05-16 07:00:00	IWM	ETF	82.84	82.99	82.84	82.99	37600.0
2011-05-16 08:00:00	IWM	ETF	82.98	83.51	82.81	82.91	409659.0
2011-05-16 09:00:00	IWM	ETF	82.92	83.25	82.77	82.97	9677359.0
2011-05-16 10:00:00	IWM	ETF	82.97	83.61	82.94	83.6	10296483.0
2011-05-16 11:00:00	IWM	ETF	83.6	83.89	83.07	83.2	7948137.0
2011-05-16 12:00:00	IWM	ETF	83.1999	83.29	82.81	82.85	5015228.0
2011-05-16 13:00:00	IWM	ETF	82.84	83.13	82.64	82.98	4386020.0
2011-05-16 14:00:00	IWM	ETF	82.98	83.17	82.55	82.63	5456274.0
2011-05-16 15:00:00	IWM	ETF	82.63	82.82	82.22	82.27	13505217.0
2011-05-16 16:00:00	IWM	ETF	82.27	83.2	81.83	81.87	3790776.0
2011-05-16 17:00:00	IWM	ETF	81.91	81.93	81.8	81.89	34044.0
2011-05-16 18:00:00	IWM	ETF	81.93	81.93	81.85	81.85	2437.0
2011-05-16 19:00:00	IWM	ETF	81.92	81.92	81.84	81.86	6979.0
2011-05-16 04:00:00	DIA	ETF	125.47	125.47	125.47	125.47	100.0
2011-05-16 05:00:00	DIA	ETF	125.34	125.39	125.32	125.32	800.0
2011-05-16 06:00:00	DIA	ETF	125.27	125.27	125.27	125.27	100.0
2011-05-16 07:00:00	DIA	ETF	125.47	125.57	125.47	125.57	400.0

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

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