PREVIEW / etf_1hour / 2011-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-24.parquet
  size:    181 KB
  rows:    5,520

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-24 04:00:00	SPY	ETF	130.25	130.29	129.9	130.2	25489.0
2011-02-24 05:00:00	SPY	ETF	130.26	130.51	130.26	130.3	31400.0
2011-02-24 06:00:00	SPY	ETF	130.4	130.45	130.15	130.19	202362.0
2011-02-24 07:00:00	SPY	ETF	130.19	130.36	130.13	130.19	839708.0
2011-02-24 08:00:00	SPY	ETF	130.2	130.76	130.2	130.69	5216121.0
2011-02-24 09:00:00	SPY	ETF	130.7	131.27	130.67	131.19	26148265.0
2011-02-24 10:00:00	SPY	ETF	131.2	131.44	130.79	130.95	28500960.0
2011-02-24 11:00:00	SPY	ETF	130.95	131.11	130.44	130.6	24260177.0
2011-02-24 12:00:00	SPY	ETF	130.59	130.71	130.18	130.55	32912441.0
2011-02-24 13:00:00	SPY	ETF	130.56	130.65	129.7	129.9	31031869.0
2011-02-24 14:00:00	SPY	ETF	129.9	130.92	129.88	130.75	42655059.0
2011-02-24 15:00:00	SPY	ETF	130.75	131.28	130.57	130.93	41346940.0
2011-02-24 16:00:00	SPY	ETF	130.94	131.0394	130.527	130.67	16697818.0
2011-02-24 17:00:00	SPY	ETF	130.66	130.87	130.66	130.75	933631.0
2011-02-24 18:00:00	SPY	ETF	130.75	131.04	130.75	131.04	273932.0
2011-02-24 19:00:00	SPY	ETF	131.02	131.11	130.99	131.06	80600.0
2011-02-24 04:00:00	QQQ	ETF	56.27	56.27	56.13	56.21	1481.0
2011-02-24 05:00:00	QQQ	ETF	56.33	56.33	56.33	56.33	100.0
2011-02-24 06:00:00	QQQ	ETF	56.26	56.28	56.2	56.25	2900.0
2011-02-24 07:00:00	QQQ	ETF	56.24	56.28	56.2	56.24	196660.0
2011-02-24 08:00:00	QQQ	ETF	56.24	56.6	56.23	56.57	2892097.0
2011-02-24 09:00:00	QQQ	ETF	56.57	56.81	56.55	56.76	10112252.0
2011-02-24 10:00:00	QQQ	ETF	56.77	56.98	56.59	56.63	17814024.0
2011-02-24 11:00:00	QQQ	ETF	56.6217	56.74	56.4	56.57	8587976.0
2011-02-24 12:00:00	QQQ	ETF	56.57	56.61	56.38	56.577	5658417.0
2011-02-24 13:00:00	QQQ	ETF	56.57	56.64	56.14	56.23	12358028.0
2011-02-24 14:00:00	QQQ	ETF	56.23	56.79	56.22	56.73	13170464.0
2011-02-24 15:00:00	QQQ	ETF	56.73	57.03	56.5254	56.83	12392936.0
2011-02-24 16:00:00	QQQ	ETF	56.83	56.91	56.5254	56.68	5934538.0
2011-02-24 17:00:00	QQQ	ETF	56.68	56.82	56.5253	56.8	1929813.0
2011-02-24 18:00:00	QQQ	ETF	56.81	56.88	56.81	56.88	24125.0
2011-02-24 19:00:00	QQQ	ETF	56.87	56.92	56.8	56.85	25925.0
2011-02-24 04:00:00	IWM	ETF	79.36	79.36	79.36	79.36	567.0
2011-02-24 05:00:00	IWM	ETF	79.57	79.63	79.57	79.63	25000.0
2011-02-24 06:00:00	IWM	ETF	79.46	79.6	79.36	79.43	23100.0
2011-02-24 07:00:00	IWM	ETF	79.43	79.53	79.24	79.29	169354.0
2011-02-24 08:00:00	IWM	ETF	79.27	79.79	79.27	79.78	622847.0
2011-02-24 09:00:00	IWM	ETF	79.79	80.41	79.5899	80.34	8883413.0
2011-02-24 10:00:00	IWM	ETF	80.33	80.72	80.11	80.25	13086558.0
2011-02-24 11:00:00	IWM	ETF	80.2584	80.32	79.64	80.0	9538735.0
2011-02-24 12:00:00	IWM	ETF	80.0	80.1	79.59	80.03	8423396.0
2011-02-24 13:00:00	IWM	ETF	80.04	80.2	79.36	79.51	8612823.0
2011-02-24 14:00:00	IWM	ETF	79.5	80.23	79.49	80.14	11739544.0
2011-02-24 15:00:00	IWM	ETF	80.14	80.5278	79.99	80.33	13330378.0
2011-02-24 16:00:00	IWM	ETF	80.33	80.38	80.0	80.18	1429852.0
2011-02-24 17:00:00	IWM	ETF	80.35	80.35	79.8856	80.16	1520259.0
2011-02-24 18:00:00	IWM	ETF	80.27	80.36	80.27	80.36	2200.0
2011-02-24 19:00:00	IWM	ETF	80.39	80.44	80.39	80.4	2301.0
2011-02-24 06:00:00	DIA	ETF	120.35	120.35	120.34	120.35	300.0
2011-02-24 07:00:00	DIA	ETF	120.38	120.39	120.25	120.25	35800.0

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

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