PREVIEW / etf_1hour / 2011-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-10.parquet
  size:    182 KB
  rows:    5,551

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-06-10 04:00:00	SPY	ETF	129.07	129.19	128.86	129.17	12114.0
2011-06-10 05:00:00	SPY	ETF	129.17	129.18	129.12	129.12	800.0
2011-06-10 06:00:00	SPY	ETF	129.14	129.14	128.85	128.9	89008.0
2011-06-10 07:00:00	SPY	ETF	128.92	129.07	128.74	129.02	558103.0
2011-06-10 08:00:00	SPY	ETF	129.03	129.23	128.761	128.81	1824976.0
2011-06-10 09:00:00	SPY	ETF	128.81	128.93	128.19	128.295	24998285.0
2011-06-10 10:00:00	SPY	ETF	128.3	128.37	127.73	127.87	37488489.0
2011-06-10 11:00:00	SPY	ETF	127.87	127.92	127.52	127.85	24610130.0
2011-06-10 12:00:00	SPY	ETF	127.85	128.02	127.67	127.87	14084810.0
2011-06-10 13:00:00	SPY	ETF	127.87	127.88	127.26	127.399	19300889.0
2011-06-10 14:00:00	SPY	ETF	127.4	128.37	127.39	128.35	36646302.0
2011-06-10 15:00:00	SPY	ETF	128.35	128.43	127.5	127.53	48716104.0
2011-06-10 16:00:00	SPY	ETF	127.53	129.3579	127.36	127.55	22522550.0
2011-06-10 17:00:00	SPY	ETF	127.55	127.57	127.45	127.53	320135.0
2011-06-10 18:00:00	SPY	ETF	127.53	127.57	127.5	127.54	180620.0
2011-06-10 19:00:00	SPY	ETF	127.51	127.56	127.46	127.56	37010.0
2011-06-10 04:00:00	QQQ	ETF	55.3	55.39	55.3	55.39	10500.0
2011-06-10 06:00:00	QQQ	ETF	55.25	55.25	55.23	55.24	750.0
2011-06-10 07:00:00	QQQ	ETF	55.25	55.27	55.21	55.27	11960.0
2011-06-10 08:00:00	QQQ	ETF	55.28	55.35	55.22	55.24	149323.0
2011-06-10 09:00:00	QQQ	ETF	55.23	55.34	55.13	55.19	6255513.0
2011-06-10 10:00:00	QQQ	ETF	55.19	55.21	54.78	54.83	9839628.0
2011-06-10 11:00:00	QQQ	ETF	54.83	54.91	54.68	54.89	5576767.0
2011-06-10 12:00:00	QQQ	ETF	54.89	54.96	54.81	54.911	2536768.0
2011-06-10 13:00:00	QQQ	ETF	54.91	54.91	54.63	54.71	3218553.0
2011-06-10 14:00:00	QQQ	ETF	54.72	55.02	54.715	55.02	5783935.0
2011-06-10 15:00:00	QQQ	ETF	55.015	55.04	54.59	54.62	12119721.0
2011-06-10 16:00:00	QQQ	ETF	54.62	54.72	54.56	54.68	1627421.0
2011-06-10 17:00:00	QQQ	ETF	54.7	54.7	54.65	54.65	23157.0
2011-06-10 18:00:00	QQQ	ETF	54.66	54.66	54.58	54.58	26690.0
2011-06-10 19:00:00	QQQ	ETF	54.58	54.64	54.57	54.64	12050.0
2011-06-10 05:00:00	IWM	ETF	79.15	79.15	79.02	79.02	400.0
2011-06-10 06:00:00	IWM	ETF	78.86	78.86	78.86	78.86	5800.0
2011-06-10 07:00:00	IWM	ETF	78.86	78.93	78.69	78.85	49897.0
2011-06-10 08:00:00	IWM	ETF	78.89	79.04	78.72	78.75	289603.0
2011-06-10 09:00:00	IWM	ETF	78.74	78.91	78.55	78.6	8883270.0
2011-06-10 10:00:00	IWM	ETF	78.61	78.62	78.01	78.13	9445453.0
2011-06-10 11:00:00	IWM	ETF	78.12	78.19	77.78	78.119	7208501.0
2011-06-10 12:00:00	IWM	ETF	78.12	78.24	77.98	78.15	4261673.0
2011-06-10 13:00:00	IWM	ETF	78.15	78.16	77.65	77.75	5764010.0
2011-06-10 14:00:00	IWM	ETF	77.75	78.65	77.74	78.64	11397542.0
2011-06-10 15:00:00	IWM	ETF	78.6424	78.7	77.88	77.96	17399852.0
2011-06-10 16:00:00	IWM	ETF	77.95	78.0268	77.81	77.98	2821175.0
2011-06-10 17:00:00	IWM	ETF	77.99	78.01	77.97	77.97	4100.0
2011-06-10 18:00:00	IWM	ETF	77.96	78.0	77.95	77.95	2800.0
2011-06-10 19:00:00	IWM	ETF	78.0	78.0	77.98	78.0	500.0
2011-06-10 04:00:00	DIA	ETF	120.67	120.67	120.67	120.67	200.0
2011-06-10 06:00:00	DIA	ETF	120.74	120.74	120.74	120.74	100.0
2011-06-10 07:00:00	DIA	ETF	120.77	120.84	120.77	120.84	1000.0
2011-06-10 08:00:00	DIA	ETF	120.87	120.98	120.65	120.65	9430.0

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

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