PREVIEW / etf_30min / 2011-06-30

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-30.parquet
  size:    279 KB
  rows:    9,379

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-30 04:00:00	SPY	ETF	130.99	131.08	130.99	131.07	1200.0
2011-06-30 04:30:00	SPY	ETF	131.1	131.15	131.1	131.15	450.0
2011-06-30 05:00:00	SPY	ETF	131.15	131.17	131.14	131.17	1000.0
2011-06-30 05:30:00	SPY	ETF	131.15	131.2	131.01	131.01	22200.0
2011-06-30 06:00:00	SPY	ETF	131.05	131.08	131.03	131.08	500.0
2011-06-30 06:30:00	SPY	ETF	131.07	131.07	130.91	130.99	17100.0
2011-06-30 07:00:00	SPY	ETF	130.98	131.17	130.91	131.17	292570.0
2011-06-30 07:30:00	SPY	ETF	131.16	131.19	131.03	131.11	204670.0
2011-06-30 08:00:00	SPY	ETF	131.11	131.18	131.06	131.11	939968.0
2011-06-30 08:30:00	SPY	ETF	131.11	134.46	131.02	131.22	1539963.0
2011-06-30 09:00:00	SPY	ETF	131.21	131.29	131.09	131.13	1209755.0
2011-06-30 09:30:00	SPY	ETF	131.14	131.79	130.99	131.53	32910582.0
2011-06-30 10:00:00	SPY	ETF	131.53	131.96	131.52	131.841	17978087.0
2011-06-30 10:30:00	SPY	ETF	131.845	131.8856	131.63	131.75	11570866.0
2011-06-30 11:00:00	SPY	ETF	131.75	132.03	131.74	131.93	11052992.0
2011-06-30 11:30:00	SPY	ETF	131.93	132.07	131.89	132.005	13600234.0
2011-06-30 12:00:00	SPY	ETF	132.0	132.1	131.93	131.98	5388688.0
2011-06-30 12:30:00	SPY	ETF	131.98	131.985	131.83	131.9	6676928.0
2011-06-30 13:00:00	SPY	ETF	131.89	131.98	131.69	131.77	8286929.0
2011-06-30 13:30:00	SPY	ETF	131.779	131.87	131.69	131.86	7634042.0
2011-06-30 14:00:00	SPY	ETF	131.86	131.91	131.75	131.77	5858530.0
2011-06-30 14:30:00	SPY	ETF	131.775	131.95	131.74	131.79	8861290.0
2011-06-30 15:00:00	SPY	ETF	131.79	131.91	131.67	131.88	10955968.0
2011-06-30 15:30:00	SPY	ETF	131.88	132.18	131.87	131.97	39185795.0
2011-06-30 16:00:00	SPY	ETF	131.97	132.08	131.9	131.95	20618391.0
2011-06-30 16:30:00	SPY	ETF	131.94	131.95	130.705	131.83	6338395.0
2011-06-30 17:00:00	SPY	ETF	131.83	132.04	131.82	131.99	829156.0
2011-06-30 17:30:00	SPY	ETF	131.98	132.03	131.96	132.02	7138996.0
2011-06-30 18:00:00	SPY	ETF	132.0	132.05	131.97	132.01	430359.0
2011-06-30 18:30:00	SPY	ETF	132.0	132.04	131.94	132.01	32772.0
2011-06-30 19:00:00	SPY	ETF	131.98	132.09	131.98	132.0	60228.0
2011-06-30 19:30:00	SPY	ETF	132.0	132.02	131.87	131.87	33194.0
2011-06-30 05:00:00	QQQ	ETF	56.48	56.49	56.48	56.49	300.0
2011-06-30 05:30:00	QQQ	ETF	56.48	56.53	56.48	56.52	500.0
2011-06-30 06:30:00	QQQ	ETF	56.42	56.45	56.42	56.45	700.0
2011-06-30 07:00:00	QQQ	ETF	56.45	56.5	56.41	56.5	22975.0
2011-06-30 07:30:00	QQQ	ETF	56.53	56.54	56.51	56.52	34200.0
2011-06-30 08:00:00	QQQ	ETF	56.5	56.54	56.49	56.51	165350.0
2011-06-30 08:30:00	QQQ	ETF	56.5	56.57	56.47	56.54	245259.0
2011-06-30 09:00:00	QQQ	ETF	56.54	56.54	56.45	56.5	153937.0
2011-06-30 09:30:00	QQQ	ETF	56.51	56.8	56.47	56.73	8655524.0
2011-06-30 10:00:00	QQQ	ETF	56.7338	56.96	56.73	56.92	5361179.0
2011-06-30 10:30:00	QQQ	ETF	56.92	56.93	56.7416	56.84	3025170.0
2011-06-30 11:00:00	QQQ	ETF	56.84	57.0	56.84	56.98	2993551.0
2011-06-30 11:30:00	QQQ	ETF	56.98	57.06	56.96	57.0119	3494908.0
2011-06-30 12:00:00	QQQ	ETF	57.02	57.06	56.95	56.96	1641295.0
2011-06-30 12:30:00	QQQ	ETF	56.96	57.01	56.92	56.99	1488339.0
2011-06-30 13:00:00	QQQ	ETF	56.985	57.02	56.89	56.93	1619215.0
2011-06-30 13:30:00	QQQ	ETF	56.92	56.97	56.9	56.97	842855.0
2011-06-30 14:00:00	QQQ	ETF	56.97	57.0	56.93	56.94	1242506.0

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

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