PREVIEW / etf_30min / 2011-08-31

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-31.parquet
  size:    290 KB
  rows:    9,817

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-08-31 04:00:00	SPY	ETF	121.84	122.05	121.8	122.01	10210.0
2011-08-31 04:30:00	SPY	ETF	122.01	122.28	122.01	122.2	11380.0
2011-08-31 05:00:00	SPY	ETF	122.16	122.29	122.05	122.29	113800.0
2011-08-31 05:30:00	SPY	ETF	122.35	122.35	122.01	122.08	74990.0
2011-08-31 06:00:00	SPY	ETF	122.08	122.23	122.06	122.19	39860.0
2011-08-31 06:30:00	SPY	ETF	122.08	122.08	121.99	122.02	75288.0
2011-08-31 07:00:00	SPY	ETF	122.02	122.16	121.98	122.03	486694.0
2011-08-31 07:30:00	SPY	ETF	122.1	122.29	122.03	122.08	338991.0
2011-08-31 08:00:00	SPY	ETF	122.08	122.29	121.87	122.25	2277665.0
2011-08-31 08:30:00	SPY	ETF	122.25	122.42	122.18	122.38	1258502.0
2011-08-31 09:00:00	SPY	ETF	122.37	122.59	122.33	122.44	2392266.0
2011-08-31 09:30:00	SPY	ETF	122.46	123.28	122.33	123.05	36748659.0
2011-08-31 10:00:00	SPY	ETF	123.06	123.51	123.0	123.29	27582424.0
2011-08-31 10:30:00	SPY	ETF	123.28	123.4	122.82	122.86	18823388.0
2011-08-31 11:00:00	SPY	ETF	122.86	123.05	122.4	122.615	21322675.0
2011-08-31 11:30:00	SPY	ETF	122.61	122.75	122.29	122.29	13665195.0
2011-08-31 12:00:00	SPY	ETF	122.29	122.85	122.28	122.7199	12845896.0
2011-08-31 12:30:00	SPY	ETF	122.71	123.04	122.68	123.0299	7902112.0
2011-08-31 13:00:00	SPY	ETF	123.03	123.12	122.6	122.73	9182855.0
2011-08-31 13:30:00	SPY	ETF	122.72	122.85	122.26	122.3	9765435.0
2011-08-31 14:00:00	SPY	ETF	122.3	122.41	122.02	122.31	13125622.0
2011-08-31 14:30:00	SPY	ETF	122.31	122.33	121.52	121.86	19587682.0
2011-08-31 15:00:00	SPY	ETF	121.86	122.21	121.3	121.82	23131484.0
2011-08-31 15:30:00	SPY	ETF	121.82	122.66	121.74	122.26	44203489.0
2011-08-31 16:00:00	SPY	ETF	122.26	123.15	121.7	122.38	18745820.0
2011-08-31 16:30:00	SPY	ETF	122.3328	122.41	122.3	122.37	7739810.0
2011-08-31 17:00:00	SPY	ETF	122.37	122.37	121.7075	122.31	1110751.0
2011-08-31 17:30:00	SPY	ETF	122.3	122.37	122.3	122.3	421096.0
2011-08-31 18:00:00	SPY	ETF	122.3	122.4	122.06	122.39	95462.0
2011-08-31 18:30:00	SPY	ETF	122.4	122.41	122.32	122.35	166995.0
2011-08-31 19:00:00	SPY	ETF	122.37	122.38	122.32	122.37	20793.0
2011-08-31 19:30:00	SPY	ETF	122.35	122.38	122.25	122.3	67387.0
2011-08-31 04:00:00	QQQ	ETF	55.06	55.15	55.06	55.13	2251.0
2011-08-31 04:30:00	QQQ	ETF	55.2	55.26	55.2	55.21	855.0
2011-08-31 05:00:00	QQQ	ETF	55.2	55.27	55.19	55.24	2640.0
2011-08-31 05:30:00	QQQ	ETF	55.21	55.21	55.21	55.21	300.0
2011-08-31 06:30:00	QQQ	ETF	55.22	55.22	55.16	55.2	14900.0
2011-08-31 07:00:00	QQQ	ETF	55.2	55.22	55.18	55.19	11411.0
2011-08-31 07:30:00	QQQ	ETF	55.21	55.25	55.17	55.19	28850.0
2011-08-31 08:00:00	QQQ	ETF	55.22	55.24	55.13	55.23	228667.0
2011-08-31 08:30:00	QQQ	ETF	55.23	55.28	55.2	55.25	114449.0
2011-08-31 09:00:00	QQQ	ETF	55.28	55.31	55.2	55.3	362432.0
2011-08-31 09:30:00	QQQ	ETF	55.29	55.58	55.14	55.48	11094096.0
2011-08-31 10:00:00	QQQ	ETF	55.48	55.74	55.44	55.625	6826184.0
2011-08-31 10:30:00	QQQ	ETF	55.62	55.68	55.47	55.48	4049764.0
2011-08-31 11:00:00	QQQ	ETF	55.4781	55.54	55.1901	55.33	4630684.0
2011-08-31 11:30:00	QQQ	ETF	55.3201	55.35	55.01	55.01	2841066.0
2011-08-31 12:00:00	QQQ	ETF	55.02	55.3098	55.01	55.2598	2355335.0
2011-08-31 12:30:00	QQQ	ETF	55.25	55.4	55.21	55.39	2008418.0
2011-08-31 13:00:00	QQQ	ETF	55.39	55.43	55.15	55.21	1831262.0

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

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