PREVIEW / etf_30min / 2011-08-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-29.parquet
  size:    286 KB
  rows:    9,431

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-29 04:00:00	SPY	ETF	118.7	119.3	118.7	119.26	4110.0
2011-08-29 04:30:00	SPY	ETF	119.31	119.33	119.14	119.19	17885.0
2011-08-29 05:00:00	SPY	ETF	119.33	119.37	119.28	119.37	1585.0
2011-08-29 05:30:00	SPY	ETF	119.29	119.32	119.22	119.27	1400.0
2011-08-29 06:00:00	SPY	ETF	119.27	119.32	119.17	119.17	2700.0
2011-08-29 06:30:00	SPY	ETF	119.15	119.32	119.1	119.31	18080.0
2011-08-29 07:00:00	SPY	ETF	119.3	119.65	119.3	119.43	243304.0
2011-08-29 07:30:00	SPY	ETF	119.41	119.53	119.25	119.28	301851.0
2011-08-29 08:00:00	SPY	ETF	119.28	119.445	118.15	119.35	1602428.0
2011-08-29 08:30:00	SPY	ETF	119.36	119.56	119.34	119.42	1119048.0
2011-08-29 09:00:00	SPY	ETF	119.42	119.64	119.39	119.56	1795612.0
2011-08-29 09:30:00	SPY	ETF	119.56	120.25	119.48	120.07	25430017.0
2011-08-29 10:00:00	SPY	ETF	120.08	120.44	119.9	120.18	15314793.0
2011-08-29 10:30:00	SPY	ETF	120.18	120.33	119.97	120.09	10694103.0
2011-08-29 11:00:00	SPY	ETF	120.09	120.1	119.78	120.0	12154464.0
2011-08-29 11:30:00	SPY	ETF	120.0	120.42	119.95	120.26	8943617.0
2011-08-29 12:00:00	SPY	ETF	120.255	120.56	120.251	120.4615	7104985.0
2011-08-29 12:30:00	SPY	ETF	120.46	120.76	120.37	120.67	8196446.0
2011-08-29 13:00:00	SPY	ETF	120.66	120.9301	120.62	120.75	7881924.0
2011-08-29 13:30:00	SPY	ETF	120.75	120.78	120.56	120.68	5668374.0
2011-08-29 14:00:00	SPY	ETF	120.69	121.02	120.67	121.01	7373632.0
2011-08-29 14:30:00	SPY	ETF	121.005	121.16	120.87	120.97	9205610.0
2011-08-29 15:00:00	SPY	ETF	120.97	121.22	120.9	121.19	13180641.0
2011-08-29 15:30:00	SPY	ETF	121.18	121.43	121.1	121.35	31594673.0
2011-08-29 16:00:00	SPY	ETF	121.34	121.5	121.23	121.4	12472976.0
2011-08-29 16:30:00	SPY	ETF	121.4	121.42	121.3	121.32	507495.0
2011-08-29 17:00:00	SPY	ETF	121.33	121.4	121.29	121.29	4955557.0
2011-08-29 17:30:00	SPY	ETF	121.29	121.33	121.28	121.29	26432.0
2011-08-29 18:00:00	SPY	ETF	121.29	121.38	121.25	121.28	327492.0
2011-08-29 18:30:00	SPY	ETF	121.28	121.3	121.24	121.24	67075.0
2011-08-29 19:00:00	SPY	ETF	121.25	121.29	121.24	121.27	24811.0
2011-08-29 19:30:00	SPY	ETF	121.28	121.35	121.26	121.34	119659.0
2011-08-29 04:00:00	QQQ	ETF	53.42	53.59	53.42	53.58	1002.0
2011-08-29 05:00:00	QQQ	ETF	53.7	53.7	53.7	53.7	1000.0
2011-08-29 05:30:00	QQQ	ETF	53.7	53.7	53.57	53.57	2100.0
2011-08-29 06:00:00	QQQ	ETF	53.62	53.62	53.61	53.61	550.0
2011-08-29 06:30:00	QQQ	ETF	53.6	53.65	53.6	53.65	800.0
2011-08-29 07:00:00	QQQ	ETF	53.69	53.79	53.68	53.73	30950.0
2011-08-29 07:30:00	QQQ	ETF	53.7	53.75	53.63	53.63	12429.0
2011-08-29 08:00:00	QQQ	ETF	53.64	53.73	53.6	53.71	107669.0
2011-08-29 08:30:00	QQQ	ETF	53.72	53.79	53.68	53.74	171812.0
2011-08-29 09:00:00	QQQ	ETF	53.75	53.83	53.65	53.65	477424.0
2011-08-29 09:30:00	QQQ	ETF	53.64	54.2	53.64	54.1	8172912.0
2011-08-29 10:00:00	QQQ	ETF	54.11	54.28	53.97	54.15	4747997.0
2011-08-29 10:30:00	QQQ	ETF	54.15	54.23	54.07	54.14	2531806.0
2011-08-29 11:00:00	QQQ	ETF	54.13	54.15	53.99	54.1	2227305.0
2011-08-29 11:30:00	QQQ	ETF	54.11	54.31	54.07	54.26	1983913.0
2011-08-29 12:00:00	QQQ	ETF	54.26	54.3698	54.245	54.3	2298250.0
2011-08-29 12:30:00	QQQ	ETF	54.3	54.41	54.27	54.37	1819668.0
2011-08-29 13:00:00	QQQ	ETF	54.36	54.49	54.34	54.3702	2279178.0

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

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