PREVIEW / etf_30min / 2011-09-15

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-15.parquet
  size:    281 KB
  rows:    9,395

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-15 04:00:00	SPY	ETF	119.54	119.65	119.54	119.65	1600.0
2011-09-15 04:30:00	SPY	ETF	119.72	119.92	119.72	119.92	2109.0
2011-09-15 05:00:00	SPY	ETF	119.9	119.93	119.8	119.9	3350.0
2011-09-15 05:30:00	SPY	ETF	119.69	120.01	119.64	119.95	15700.0
2011-09-15 06:00:00	SPY	ETF	120.0	120.05	119.9	119.9	10600.0
2011-09-15 06:30:00	SPY	ETF	119.9	120.23	119.9	120.22	45591.0
2011-09-15 07:00:00	SPY	ETF	120.2	120.27	120.03	120.18	671520.0
2011-09-15 07:30:00	SPY	ETF	120.22	120.24	120.0	120.14	336557.0
2011-09-15 08:00:00	SPY	ETF	120.08	120.2	119.94	119.97	1977544.0
2011-09-15 08:30:00	SPY	ETF	119.98	120.03	119.4	119.53	4855709.0
2011-09-15 09:00:00	SPY	ETF	119.54	121.14	119.54	120.65	15032554.0
2011-09-15 09:30:00	SPY	ETF	120.65	120.75	120.0	120.34	28881199.0
2011-09-15 10:00:00	SPY	ETF	120.34	120.99	120.04	120.15	28152813.0
2011-09-15 10:30:00	SPY	ETF	120.1501	120.18	119.64	119.7837	23177935.0
2011-09-15 11:00:00	SPY	ETF	119.79	120.36	119.57	120.26	15662372.0
2011-09-15 11:30:00	SPY	ETF	120.25	120.62	120.22	120.51	14988239.0
2011-09-15 12:00:00	SPY	ETF	120.5	120.74	120.34	120.54	7812023.0
2011-09-15 12:30:00	SPY	ETF	120.54	120.85	120.48	120.76	8862843.0
2011-09-15 13:00:00	SPY	ETF	120.77	120.99	120.72	120.76	13064075.0
2011-09-15 13:30:00	SPY	ETF	120.75	120.94	120.6	120.93	13165690.0
2011-09-15 14:00:00	SPY	ETF	120.94	121.32	120.87	121.01	19420465.0
2011-09-15 14:30:00	SPY	ETF	121.01	121.37	120.97	121.29	14973774.0
2011-09-15 15:00:00	SPY	ETF	121.27	121.46	120.87	120.955	29899387.0
2011-09-15 15:30:00	SPY	ETF	120.955	121.46	120.92	121.44	36832094.0
2011-09-15 16:00:00	SPY	ETF	121.43	121.7	119.4049	121.48	29075134.0
2011-09-15 16:30:00	SPY	ETF	121.48	121.54	121.38	121.42	8747469.0
2011-09-15 17:00:00	SPY	ETF	121.43	122.02	119.4034	121.94	3471363.0
2011-09-15 17:30:00	SPY	ETF	122.0	122.0	119.4049	121.74	761150.0
2011-09-15 18:00:00	SPY	ETF	121.78	121.93	121.47	121.88	424491.0
2011-09-15 18:30:00	SPY	ETF	121.86	121.87	121.55	121.62	131132.0
2011-09-15 19:00:00	SPY	ETF	121.6	121.78	121.59	121.74	98962.0
2011-09-15 19:30:00	SPY	ETF	121.73	121.73	121.52	121.52	117971.0
2011-09-15 04:30:00	QQQ	ETF	55.55	55.76	55.55	55.76	5500.0
2011-09-15 05:30:00	QQQ	ETF	55.76	55.76	55.76	55.76	100.0
2011-09-15 06:00:00	QQQ	ETF	55.76	55.76	55.76	55.76	5000.0
2011-09-15 06:30:00	QQQ	ETF	55.69	55.84	55.69	55.83	13240.0
2011-09-15 07:00:00	QQQ	ETF	55.84	55.87	55.78	55.87	59126.0
2011-09-15 07:30:00	QQQ	ETF	55.84	55.85	55.75	55.78	35190.0
2011-09-15 08:00:00	QQQ	ETF	55.77	55.81	55.7	55.7	194881.0
2011-09-15 08:30:00	QQQ	ETF	55.7	55.75	55.5	55.53	910447.0
2011-09-15 09:00:00	QQQ	ETF	55.53	56.17	55.53	55.99	2890381.0
2011-09-15 09:30:00	QQQ	ETF	55.98	55.98	55.5693	55.78	6450035.0
2011-09-15 10:00:00	QQQ	ETF	55.78	56.03	55.62	55.7	6286937.0
2011-09-15 10:30:00	QQQ	ETF	55.6981	55.71	55.45	55.53	3952873.0
2011-09-15 11:00:00	QQQ	ETF	55.52	55.8	55.39	55.74	3426883.0
2011-09-15 11:30:00	QQQ	ETF	55.74	55.91	55.73	55.85	2710345.0
2011-09-15 12:00:00	QQQ	ETF	55.8571	55.93	55.77	55.87	2042386.0
2011-09-15 12:30:00	QQQ	ETF	55.87	56.02	55.86	55.99	2198814.0
2011-09-15 13:00:00	QQQ	ETF	56.0	56.13	55.98	56.01	2867656.0
2011-09-15 13:30:00	QQQ	ETF	56.01	56.095	55.94	56.09	3492688.0

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

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