PREVIEW / etf_30min / 2011-07-12

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-12.parquet
  size:    287 KB
  rows:    9,666

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-12 04:00:00	SPY	ETF	130.95	130.95	130.17	130.68	26675.0
2011-07-12 04:30:00	SPY	ETF	130.86	131.0	130.57	130.8	14800.0
2011-07-12 05:00:00	SPY	ETF	130.84	131.28	130.8	131.28	41980.0
2011-07-12 05:30:00	SPY	ETF	131.24	131.51	131.06	131.06	11365.0
2011-07-12 06:00:00	SPY	ETF	131.0	131.3	130.91	131.12	33871.0
2011-07-12 06:30:00	SPY	ETF	131.1	131.29	130.95	131.01	289300.0
2011-07-12 07:00:00	SPY	ETF	130.96	131.05	130.63	130.98	840643.0
2011-07-12 07:30:00	SPY	ETF	130.95	131.8	130.87	131.74	1607675.0
2011-07-12 08:00:00	SPY	ETF	131.7	131.85	130.67	131.66	4319394.0
2011-07-12 08:30:00	SPY	ETF	131.61	132.1	131.53	131.76	2970554.0
2011-07-12 09:00:00	SPY	ETF	131.76	131.81	131.25	131.68	4261899.0
2011-07-12 09:30:00	SPY	ETF	131.69	132.05	131.57	132.03	24930094.0
2011-07-12 10:00:00	SPY	ETF	132.03	132.23	131.84	132.02	17036574.0
2011-07-12 10:30:00	SPY	ETF	132.02	132.17	131.67	131.875	11392000.0
2011-07-12 11:00:00	SPY	ETF	131.88	132.21	131.79	132.11	9415394.0
2011-07-12 11:30:00	SPY	ETF	132.11	132.4	132.05	132.23	10555176.0
2011-07-12 12:00:00	SPY	ETF	132.22	132.36	132.06	132.07	5880780.0
2011-07-12 12:30:00	SPY	ETF	132.07	132.24	131.97	132.08	7698845.0
2011-07-12 13:00:00	SPY	ETF	132.09	132.25	131.86	131.88	9600293.0
2011-07-12 13:30:00	SPY	ETF	131.87	132.05	131.82	131.92	5853759.0
2011-07-12 14:00:00	SPY	ETF	131.925	132.78	131.85	132.541	23650576.0
2011-07-12 14:30:00	SPY	ETF	132.545	132.62	132.11	132.155	12728275.0
2011-07-12 15:00:00	SPY	ETF	132.16	132.28	131.78	131.97	20580164.0
2011-07-12 15:30:00	SPY	ETF	131.97	132.0	131.36	131.402	27802007.0
2011-07-12 16:00:00	SPY	ETF	131.41	132.0676	131.33	131.52	8947536.0
2011-07-12 16:30:00	SPY	ETF	131.53	131.58	131.47	131.5	2422651.0
2011-07-12 17:00:00	SPY	ETF	131.47	131.53	131.41	131.46	824309.0
2011-07-12 17:30:00	SPY	ETF	131.46	131.48	131.4	131.45	65056.0
2011-07-12 18:00:00	SPY	ETF	131.44	131.44	131.31	131.38	314607.0
2011-07-12 18:30:00	SPY	ETF	131.36	131.37	131.21	131.24	195696.0
2011-07-12 19:00:00	SPY	ETF	131.25	131.33	131.23	131.27	82150.0
2011-07-12 19:30:00	SPY	ETF	131.28	131.45	131.28	131.4	171863.0
2011-07-12 04:00:00	QQQ	ETF	57.57	57.57	57.34	57.4	4365.0
2011-07-12 04:30:00	QQQ	ETF	57.57	57.59	57.5	57.59	700.0
2011-07-12 05:00:00	QQQ	ETF	57.69	57.74	57.69	57.74	200.0
2011-07-12 05:30:00	QQQ	ETF	57.73	57.8	57.6	57.6	20800.0
2011-07-12 06:00:00	QQQ	ETF	57.68	57.75	57.68	57.7	2200.0
2011-07-12 06:30:00	QQQ	ETF	57.71	57.71	57.63	57.68	1300.0
2011-07-12 07:00:00	QQQ	ETF	57.71	57.71	57.5	57.62	330199.0
2011-07-12 07:30:00	QQQ	ETF	57.62	57.93	57.59	57.92	338859.0
2011-07-12 08:00:00	QQQ	ETF	57.89	58.02	57.84	57.93	366407.0
2011-07-12 08:30:00	QQQ	ETF	57.93	58.13	57.89	58.05	527024.0
2011-07-12 09:00:00	QQQ	ETF	58.06	58.06	57.88	57.94	418264.0
2011-07-12 09:30:00	QQQ	ETF	57.94	58.0	57.49	57.7	11346988.0
2011-07-12 10:00:00	QQQ	ETF	57.7	57.95	57.67	57.84	6385684.0
2011-07-12 10:30:00	QQQ	ETF	57.84	57.94	57.62	57.73	4687728.0
2011-07-12 11:00:00	QQQ	ETF	57.74	57.8811	57.71	57.81	3284199.0
2011-07-12 11:30:00	QQQ	ETF	57.81	57.93	57.745	57.7699	3540058.0
2011-07-12 12:00:00	QQQ	ETF	57.77	57.855	57.65	57.655	3065719.0
2011-07-12 12:30:00	QQQ	ETF	57.65	57.73	57.63	57.71	1930502.0

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

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