PREVIEW / etf_30min / 2011-07-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-29.parquet
  size:    296 KB
  rows:    9,892

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-07-29 04:00:00	SPY	ETF	130.05	130.05	129.42	129.7	4600.0
2011-07-29 04:30:00	SPY	ETF	129.65	129.83	129.64	129.83	500.0
2011-07-29 05:00:00	SPY	ETF	129.65	129.65	129.65	129.65	100.0
2011-07-29 05:30:00	SPY	ETF	129.5	129.8	129.5	129.73	2700.0
2011-07-29 06:00:00	SPY	ETF	129.74	129.74	129.51	129.51	900.0
2011-07-29 06:30:00	SPY	ETF	129.51	129.57	129.18	129.41	69400.0
2011-07-29 07:00:00	SPY	ETF	129.48	129.72	129.38	129.6	180072.0
2011-07-29 07:30:00	SPY	ETF	129.55	129.65	129.5	129.52	205686.0
2011-07-29 08:00:00	SPY	ETF	129.56	129.67	129.48	129.5	1618777.0
2011-07-29 08:30:00	SPY	ETF	129.47	129.49	128.67	128.95	7197354.0
2011-07-29 09:00:00	SPY	ETF	128.96	129.08	128.76	128.91	3782212.0
2011-07-29 09:30:00	SPY	ETF	128.91	129.29	128.36	129.11	46384259.0
2011-07-29 10:00:00	SPY	ETF	129.12	129.48	127.9667	129.31	24433908.0
2011-07-29 10:30:00	SPY	ETF	129.31	130.14	129.03	129.92	35376787.0
2011-07-29 11:00:00	SPY	ETF	129.93	130.55	129.25	130.1	21859681.0
2011-07-29 11:30:00	SPY	ETF	130.1	130.2	129.87	130.05	13076400.0
2011-07-29 12:00:00	SPY	ETF	130.05	130.14	129.6	129.71	15829317.0
2011-07-29 12:30:00	SPY	ETF	129.705	129.91	129.51	129.565	10102469.0
2011-07-29 13:00:00	SPY	ETF	129.57	129.82	129.44	129.705	7333084.0
2011-07-29 13:30:00	SPY	ETF	129.7	130.05	129.59	129.97	10722667.0
2011-07-29 14:00:00	SPY	ETF	129.97	130.19	129.73	129.805	9496193.0
2011-07-29 14:30:00	SPY	ETF	129.795	130.09	129.6859	129.79	8706039.0
2011-07-29 15:00:00	SPY	ETF	129.79	130.0	129.52	129.66	12905900.0
2011-07-29 15:30:00	SPY	ETF	129.65	129.74	129.23	129.32	42207514.0
2011-07-29 16:00:00	SPY	ETF	129.32	130.174	129.01	129.48	25155511.0
2011-07-29 16:30:00	SPY	ETF	129.5	130.174	129.42	129.51	7360424.0
2011-07-29 17:00:00	SPY	ETF	129.5	129.56	129.5	129.51	140372.0
2011-07-29 17:30:00	SPY	ETF	129.5	129.59	129.41	129.45	59714.0
2011-07-29 18:00:00	SPY	ETF	129.43	129.5	129.39	129.45	185625.0
2011-07-29 18:30:00	SPY	ETF	129.45	129.5	129.05	129.42	257117.0
2011-07-29 19:00:00	SPY	ETF	129.42	129.58	129.42	129.53	29044.0
2011-07-29 19:30:00	SPY	ETF	129.55	129.59	129.49	129.58	34995.0
2011-07-29 04:00:00	QQQ	ETF	58.23	58.23	57.97	57.97	400.0
2011-07-29 04:30:00	QQQ	ETF	58.05	58.11	58.05	58.11	300.0
2011-07-29 06:30:00	QQQ	ETF	58.01	58.01	57.99	57.99	1600.0
2011-07-29 07:00:00	QQQ	ETF	58.0	58.06	57.95	57.99	30225.0
2011-07-29 07:30:00	QQQ	ETF	57.98	58.02	57.98	58.0	21800.0
2011-07-29 08:00:00	QQQ	ETF	57.99	58.11	57.96	58.05	206633.0
2011-07-29 08:30:00	QQQ	ETF	58.03	58.04	57.7	57.79	919726.0
2011-07-29 09:00:00	QQQ	ETF	57.79	57.84	57.71	57.73	561856.0
2011-07-29 09:30:00	QQQ	ETF	57.73	57.89	57.44	57.87	12331378.0
2011-07-29 10:00:00	QQQ	ETF	57.865	57.965	57.68	57.87	7044619.0
2011-07-29 10:30:00	QQQ	ETF	57.88	58.36	57.8105	58.32	10781121.0
2011-07-29 11:00:00	QQQ	ETF	58.32	58.61	58.2	58.399	6722449.0
2011-07-29 11:30:00	QQQ	ETF	58.4	58.425	58.23	58.33	3627687.0
2011-07-29 12:00:00	QQQ	ETF	58.34	58.37	58.1	58.16	3032670.0
2011-07-29 12:30:00	QQQ	ETF	58.16	58.26	58.08	58.11	3307069.0
2011-07-29 13:00:00	QQQ	ETF	58.11	58.22	58.07	58.16	1847649.0
2011-07-29 13:30:00	QQQ	ETF	58.1599	58.41	58.1	58.35	4681410.0
2011-07-29 14:00:00	QQQ	ETF	58.35	58.44	58.21	58.25	2450689.0

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

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