PREVIEW / etf_30min / 2011-09-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-14.parquet
  size:    284 KB
  rows:    9,374

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-09-14 04:00:00	SPY	ETF	117.45	117.63	117.25	117.25	1950.0
2011-09-14 04:30:00	SPY	ETF	117.2	117.37	117.01	117.37	4300.0
2011-09-14 05:00:00	SPY	ETF	117.11	117.29	117.01	117.2	3300.0
2011-09-14 05:30:00	SPY	ETF	117.25	117.59	117.25	117.57	5700.0
2011-09-14 06:00:00	SPY	ETF	117.63	117.9	117.63	117.9	7770.0
2011-09-14 06:30:00	SPY	ETF	117.9	118.49	117.9	118.3	282622.0
2011-09-14 07:00:00	SPY	ETF	118.3	118.74	118.3	118.57	721170.0
2011-09-14 07:30:00	SPY	ETF	118.54	118.9	118.41	118.9	570914.0
2011-09-14 08:00:00	SPY	ETF	118.9	118.9	117.1	118.55	1602762.0
2011-09-14 08:30:00	SPY	ETF	118.55	118.64	118.11	118.32	2901150.0
2011-09-14 09:00:00	SPY	ETF	118.33	118.53	118.1	118.35	1917151.0
2011-09-14 09:30:00	SPY	ETF	118.34	118.6	117.81	117.93	21638247.0
2011-09-14 10:00:00	SPY	ETF	117.94	118.06	116.72	117.36	38790187.0
2011-09-14 10:30:00	SPY	ETF	117.36	117.68	117.08	117.6	16910721.0
2011-09-14 11:00:00	SPY	ETF	117.6	118.29	117.37	118.2429	14597107.0
2011-09-14 11:30:00	SPY	ETF	118.25	118.43	117.95	118.43	9943098.0
2011-09-14 12:00:00	SPY	ETF	118.42	118.48	118.1	118.33	6820526.0
2011-09-14 12:30:00	SPY	ETF	118.34	118.76	118.32	118.54	10490053.0
2011-09-14 13:00:00	SPY	ETF	118.54	118.83	118.5	118.72	8940922.0
2011-09-14 13:30:00	SPY	ETF	118.72	119.35	118.69	118.94	20130467.0
2011-09-14 14:00:00	SPY	ETF	118.93	119.75	118.93	119.51	23285363.0
2011-09-14 14:30:00	SPY	ETF	119.5101	119.8	119.38	119.7895	16718912.0
2011-09-14 15:00:00	SPY	ETF	119.79	120.68	119.78	120.53	29165687.0
2011-09-14 15:30:00	SPY	ETF	120.53	120.8	119.34	119.37	54645784.0
2011-09-14 16:00:00	SPY	ETF	119.36	120.502	118.15	119.41	10678760.0
2011-09-14 16:30:00	SPY	ETF	119.41	119.5	119.3	119.33	23852120.0
2011-09-14 17:00:00	SPY	ETF	119.32	119.33	119.02	119.03	550321.0
2011-09-14 17:30:00	SPY	ETF	119.05	119.12	119.05	119.1	62948.0
2011-09-14 18:00:00	SPY	ETF	119.1	119.36	118.99	119.06	1344220.0
2011-09-14 18:30:00	SPY	ETF	119.06	119.29	119.03	119.27	221713.0
2011-09-14 19:00:00	SPY	ETF	119.28	119.35	119.23	119.32	34950.0
2011-09-14 19:30:00	SPY	ETF	119.31	119.45	119.31	119.45	95384.0
2011-09-14 06:00:00	QQQ	ETF	54.63	54.7	54.63	54.7	1000.0
2011-09-14 06:30:00	QQQ	ETF	54.67	54.93	54.67	54.91	7000.0
2011-09-14 07:00:00	QQQ	ETF	54.87	55.05	54.87	55.0	29950.0
2011-09-14 07:30:00	QQQ	ETF	54.96	55.12	54.96	55.12	6637.0
2011-09-14 08:00:00	QQQ	ETF	55.12	55.12	54.84	54.9	199694.0
2011-09-14 08:30:00	QQQ	ETF	54.88	55.0	54.78	54.88	266135.0
2011-09-14 09:00:00	QQQ	ETF	54.87	54.95	54.8	54.87	750639.0
2011-09-14 09:30:00	QQQ	ETF	54.86	55.06	54.74	54.9	7383908.0
2011-09-14 10:00:00	QQQ	ETF	54.91	54.95	54.32	54.5937	9571971.0
2011-09-14 10:30:00	QQQ	ETF	54.6	54.78	54.51	54.74	3707287.0
2011-09-14 11:00:00	QQQ	ETF	54.73	55.01	54.66	54.99	3914454.0
2011-09-14 11:30:00	QQQ	ETF	55.0	55.1	54.89	55.1	4844257.0
2011-09-14 12:00:00	QQQ	ETF	55.1	55.13	54.97	55.0502	2633446.0
2011-09-14 12:30:00	QQQ	ETF	55.06	55.24	55.06	55.11	3150984.0
2011-09-14 13:00:00	QQQ	ETF	55.11	55.2	55.08	55.14	1794779.0
2011-09-14 13:30:00	QQQ	ETF	55.15	55.39	55.13	55.24	3994160.0
2011-09-14 14:00:00	QQQ	ETF	55.23	55.54	55.23	55.48	3592422.0
2011-09-14 14:30:00	QQQ	ETF	55.479	55.61	55.38	55.6	3239819.0

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

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