PREVIEW / etf_30min / 2011-12-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-16.parquet
  size:    282 KB
  rows:    9,500

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-12-16 04:00:00	SPY	ETF	122.76	122.76	122.3	122.3	69497.0
2011-12-16 04:30:00	SPY	ETF	122.37	122.45	122.26	122.26	3700.0
2011-12-16 05:00:00	SPY	ETF	122.27	122.38	122.18	122.32	49822.0
2011-12-16 05:30:00	SPY	ETF	122.33	122.64	122.3	122.41	73700.0
2011-12-16 06:00:00	SPY	ETF	122.42	122.42	122.2	122.35	24100.0
2011-12-16 06:30:00	SPY	ETF	122.31	122.43	122.25	122.39	55350.0
2011-12-16 07:00:00	SPY	ETF	122.38	122.5	122.22	122.45	251542.0
2011-12-16 07:30:00	SPY	ETF	122.45	122.65	122.42	122.51	275248.0
2011-12-16 08:00:00	SPY	ETF	122.54	122.68	122.49	122.54	2275187.0
2011-12-16 08:30:00	SPY	ETF	122.54	122.6	122.35	122.47	3289915.0
2011-12-16 09:00:00	SPY	ETF	122.49	122.5	122.14	122.22	3437618.0
2011-12-16 09:30:00	SPY	ETF	122.23	122.58	122.07	122.41	29400496.0
2011-12-16 10:00:00	SPY	ETF	122.42	122.95	122.31	122.67	18522672.0
2011-12-16 10:30:00	SPY	ETF	122.67	122.8	122.61	122.68	8961208.0
2011-12-16 11:00:00	SPY	ETF	122.69	122.77	122.47	122.52	8055249.0
2011-12-16 11:30:00	SPY	ETF	122.52	122.56	121.89	121.91	13027724.0
2011-12-16 12:00:00	SPY	ETF	121.91	121.97	121.73	121.76	11023486.0
2011-12-16 12:30:00	SPY	ETF	121.76	121.77	121.3	121.61	19792006.0
2011-12-16 13:00:00	SPY	ETF	121.61	121.89	121.55	121.771	11989995.0
2011-12-16 13:30:00	SPY	ETF	121.78	121.9	121.51	121.59	10571096.0
2011-12-16 14:00:00	SPY	ETF	121.591	121.7	121.42	121.449	6748315.0
2011-12-16 14:30:00	SPY	ETF	121.45	121.83	121.4	121.67	7845510.0
2011-12-16 15:00:00	SPY	ETF	121.675	121.87	121.52	121.57	10449244.0
2011-12-16 15:30:00	SPY	ETF	121.57	121.88	121.54	121.67	28199352.0
2011-12-16 16:00:00	SPY	ETF	121.66	122.75	121.3881	121.58	19072508.0
2011-12-16 16:30:00	SPY	ETF	121.58	121.743	121.31	121.4	642001.0
2011-12-16 17:00:00	SPY	ETF	121.4	121.57	121.35	121.55	318711.0
2011-12-16 17:30:00	SPY	ETF	121.57	121.62	121.49	121.5	29888.0
2011-12-16 18:00:00	SPY	ETF	121.5	121.57	121.45	121.52	835675.0
2011-12-16 18:30:00	SPY	ETF	121.51	121.53	121.49	121.53	11700.0
2011-12-16 19:00:00	SPY	ETF	121.51	121.55	121.49	121.52	22741.0
2011-12-16 19:30:00	SPY	ETF	121.53	121.58	121.5	121.58	18500.0
2011-12-16 04:00:00	QQQ	ETF	54.85	54.92	54.85	54.87	23654.0
2011-12-16 05:00:00	QQQ	ETF	54.83	54.83	54.83	54.83	1000.0
2011-12-16 05:30:00	QQQ	ETF	54.87	55.01	54.85	54.92	55900.0
2011-12-16 06:00:00	QQQ	ETF	54.92	54.93	54.91	54.92	46200.0
2011-12-16 06:30:00	QQQ	ETF	54.89	54.93	54.85	54.93	9200.0
2011-12-16 07:00:00	QQQ	ETF	54.92	54.97	54.89	54.96	54284.0
2011-12-16 07:30:00	QQQ	ETF	54.96	55.03	54.96	55.02	51900.0
2011-12-16 08:00:00	QQQ	ETF	54.97	55.13	54.97	55.1	1305715.0
2011-12-16 08:30:00	QQQ	ETF	55.11	55.11	55.0	55.06	1620657.0
2011-12-16 09:00:00	QQQ	ETF	55.06	55.08	54.85	54.88	813834.0
2011-12-16 09:30:00	QQQ	ETF	54.88	55.29	54.87	55.27	9921283.0
2011-12-16 10:00:00	QQQ	ETF	55.27	55.61	55.205	55.46	7484178.0
2011-12-16 10:30:00	QQQ	ETF	55.47	55.56	55.46	55.52	1774232.0
2011-12-16 11:00:00	QQQ	ETF	55.52	55.55	55.37	55.39	2014521.0
2011-12-16 11:30:00	QQQ	ETF	55.39	55.41	55.03	55.04	4223254.0
2011-12-16 12:00:00	QQQ	ETF	55.035	55.06	54.91	54.98	2010423.0
2011-12-16 12:30:00	QQQ	ETF	54.9758	54.99	54.77	54.906	5056338.0
2011-12-16 13:00:00	QQQ	ETF	54.9	55.04	54.88	54.98	2260028.0

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

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