PREVIEW / etf_30min / 2011-02-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-23.parquet
  size:    293 KB
  rows:    9,625

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-23 04:00:00	SPY	ETF	132.27	132.27	132.19	132.21	550.0
2011-02-23 04:30:00	SPY	ETF	132.5	132.56	132.19	132.25	1050.0
2011-02-23 05:00:00	SPY	ETF	132.25	132.25	132.0	132.0	400.0
2011-02-23 05:30:00	SPY	ETF	132.21	132.21	132.21	132.21	300.0
2011-02-23 06:00:00	SPY	ETF	132.26	132.41	132.23	132.37	14800.0
2011-02-23 06:30:00	SPY	ETF	132.4	132.47	132.37	132.46	170500.0
2011-02-23 07:00:00	SPY	ETF	132.46	132.47	132.35	132.45	235690.0
2011-02-23 07:30:00	SPY	ETF	132.45	132.49	132.3	132.34	400487.0
2011-02-23 08:00:00	SPY	ETF	132.34	132.44	132.08	132.12	1484763.0
2011-02-23 08:30:00	SPY	ETF	132.12	132.16	132.01	132.06	936177.0
2011-02-23 09:00:00	SPY	ETF	132.05	132.07	131.7	131.75	1898177.0
2011-02-23 09:30:00	SPY	ETF	131.75	132.07	131.48	131.56	22788596.0
2011-02-23 10:00:00	SPY	ETF	131.56	131.8	131.22	131.68	16753246.0
2011-02-23 10:30:00	SPY	ETF	131.68	131.84	131.27	131.665	12642584.0
2011-02-23 11:00:00	SPY	ETF	131.67	131.78	131.42	131.4602	8527955.0
2011-02-23 11:30:00	SPY	ETF	131.47	131.47	130.98	131.0174	16659610.0
2011-02-23 12:00:00	SPY	ETF	131.02	131.1	130.47	130.78	20665052.0
2011-02-23 12:30:00	SPY	ETF	130.785	130.925	130.53	130.71	10928926.0
2011-02-23 13:00:00	SPY	ETF	130.71	130.83	130.21	130.64	15860884.0
2011-02-23 13:30:00	SPY	ETF	130.64	131.0	130.47	130.87	15330417.0
2011-02-23 14:00:00	SPY	ETF	130.87	131.2	130.82	131.03	11135691.0
2011-02-23 14:30:00	SPY	ETF	131.03	131.33	130.84	131.319	11975986.0
2011-02-23 15:00:00	SPY	ETF	131.32	131.58	131.18	131.33	19055082.0
2011-02-23 15:30:00	SPY	ETF	131.33	131.35	130.97	131.03	27339241.0
2011-02-23 16:00:00	SPY	ETF	131.03	131.6	130.54	131.0	8439936.0
2011-02-23 16:30:00	SPY	ETF	130.99	131.16	130.96	131.1	1431973.0
2011-02-23 17:00:00	SPY	ETF	131.09	131.14	131.06	131.12	65922.0
2011-02-23 17:30:00	SPY	ETF	131.15	131.8126	131.1	131.11	1019821.0
2011-02-23 18:00:00	SPY	ETF	131.11	131.27	131.11	131.27	249199.0
2011-02-23 18:30:00	SPY	ETF	131.28	131.3	131.01	131.29	282488.0
2011-02-23 19:00:00	SPY	ETF	131.23	131.23	131.16	131.21	36053.0
2011-02-23 19:30:00	SPY	ETF	131.22	131.28	131.18	131.19	19904.0
2011-02-23 06:00:00	QQQ	ETF	57.28	57.3	57.28	57.3	200.0
2011-02-23 06:30:00	QQQ	ETF	57.33	57.34	57.33	57.34	10300.0
2011-02-23 07:00:00	QQQ	ETF	57.33	57.35	57.31	57.35	14700.0
2011-02-23 07:30:00	QQQ	ETF	57.34	57.34	57.3	57.32	207117.0
2011-02-23 08:00:00	QQQ	ETF	57.31	57.34	57.17	57.23	575481.0
2011-02-23 08:30:00	QQQ	ETF	57.23	57.25	57.2	57.21	137488.0
2011-02-23 09:00:00	QQQ	ETF	57.22	57.22	56.99	57.0	773285.0
2011-02-23 09:30:00	QQQ	ETF	57.0	57.23	56.93	56.96	9581042.0
2011-02-23 10:00:00	QQQ	ETF	56.96	57.01	56.82	56.9388	9363657.0
2011-02-23 10:30:00	QQQ	ETF	56.94	57.01	56.66	56.8575	6704249.0
2011-02-23 11:00:00	QQQ	ETF	56.86	56.9	56.71	56.74	6753174.0
2011-02-23 11:30:00	QQQ	ETF	56.74	56.74	56.49	56.5	5589499.0
2011-02-23 12:00:00	QQQ	ETF	56.5	56.5	56.17	56.345	11378489.0
2011-02-23 12:30:00	QQQ	ETF	56.35	56.39	56.22	56.3649	6031656.0
2011-02-23 13:00:00	QQQ	ETF	56.36	56.4	56.13	56.33	5188903.0
2011-02-23 13:30:00	QQQ	ETF	56.3226	56.51	56.24	56.44	3460942.0
2011-02-23 14:00:00	QQQ	ETF	56.4475	56.63	56.4399	56.547	3703745.0
2011-02-23 14:30:00	QQQ	ETF	56.55	56.71	56.47	56.7	4359657.0

> showing 50 of 9,625 rows — these rows as CSV

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