PREVIEW / stock_30min / 2011-07-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-20.parquet
  size:    1.4 MB
  rows:    75,274
  symbols: 3,532

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-07-20 04:00:00	AAPL	Stock	14.0579	14.0579	13.9646	13.9893	160300.0
2011-07-20 04:30:00	AAPL	Stock	13.9821	13.9843	13.95	13.9639	125692.0
2011-07-20 05:00:00	AAPL	Stock	13.9643	13.9714	13.9361	13.9714	106400.0
2011-07-20 05:30:00	AAPL	Stock	13.9786	14.0111	13.9786	14.0075	218288.0
2011-07-20 06:00:00	AAPL	Stock	14.0071	14.1071	14.0071	14.1071	944020.0
2011-07-20 06:30:00	AAPL	Stock	14.1068	14.125	14.1011	14.1071	703388.0
2011-07-20 07:00:00	AAPL	Stock	14.1111	14.2382	14.1071	14.2214	3327296.0
2011-07-20 07:30:00	AAPL	Stock	14.2196	14.2654	14.2125	14.2364	2685200.0
2011-07-20 08:00:00	AAPL	Stock	14.2364	14.2521	14.1646	14.2018	7885164.0
2011-07-20 08:30:00	AAPL	Stock	14.2054	14.2611	14.1743	14.2582	6832532.0
2011-07-20 09:00:00	AAPL	Stock	14.2532	14.2704	14.1071	14.1514	13411076.0
2011-07-20 09:30:00	AAPL	Stock	14.1504	14.1525	13.8254	13.9	317033724.0
2011-07-20 10:00:00	AAPL	Stock	13.9	13.9393	13.8025	13.8182	116379256.0
2011-07-20 10:30:00	AAPL	Stock	13.8164	13.8889	13.7857	13.8768	68251932.0
2011-07-20 11:00:00	AAPL	Stock	13.8773	13.9639	13.8768	13.8814	67579680.0
2011-07-20 11:30:00	AAPL	Stock	13.8814	13.9068	13.815	13.8343	45231788.0
2011-07-20 12:00:00	AAPL	Stock	13.8357	13.8525	13.815	13.8311	29443344.0
2011-07-20 12:30:00	AAPL	Stock	13.8325	13.8729	13.8277	13.8454	29980496.0
2011-07-20 13:00:00	AAPL	Stock	13.8459	13.8918	13.8346	13.889	23865128.0
2011-07-20 13:30:00	AAPL	Stock	13.8864	13.9161	13.8657	13.91	27010060.0
2011-07-20 14:00:00	AAPL	Stock	13.9079	13.9339	13.8914	13.9143	32860800.0
2011-07-20 14:30:00	AAPL	Stock	13.9143	13.9229	13.8657	13.875	29798944.0
2011-07-20 15:00:00	AAPL	Stock	13.8739	13.8914	13.8107	13.8368	36560692.0
2011-07-20 15:30:00	AAPL	Stock	13.8375	13.8654	13.8061	13.8214	62024844.0
2011-07-20 16:00:00	AAPL	Stock	13.8214	13.9127	13.8077	13.8196	7758240.0
2011-07-20 16:30:00	AAPL	Stock	13.8196	13.8853	13.7871	13.7911	508788.0
2011-07-20 17:00:00	AAPL	Stock	13.7911	13.8411	13.7718	13.7721	351204.0
2011-07-20 17:30:00	AAPL	Stock	13.7757	13.8179	13.7543	13.7679	809004.0
2011-07-20 18:00:00	AAPL	Stock	13.7679	13.8179	13.7643	13.7936	672000.0
2011-07-20 18:30:00	AAPL	Stock	13.7918	13.8239	13.7861	13.8214	283528.0
2011-07-20 19:00:00	AAPL	Stock	13.8214	13.83	13.8036	13.8036	169400.0
2011-07-20 19:30:00	AAPL	Stock	13.8096	13.8286	13.8096	13.8246	182448.0
2011-07-20 04:30:00	MSFT	Stock	27.6	27.62	27.6	27.62	707.0
2011-07-20 06:00:00	MSFT	Stock	27.53	27.53	27.53	27.53	100.0
2011-07-20 07:00:00	MSFT	Stock	27.64	27.64	27.57	27.57	1500.0
2011-07-20 07:30:00	MSFT	Stock	27.6	27.6	27.56	27.56	2645.0
2011-07-20 08:00:00	MSFT	Stock	27.5	27.583	27.42	27.5	33961.0
2011-07-20 08:30:00	MSFT	Stock	27.48	27.49	27.45	27.45	36067.0
2011-07-20 09:00:00	MSFT	Stock	27.44	27.44	27.22	27.22	62306.0
2011-07-20 09:30:00	MSFT	Stock	27.27	27.35	27.11	27.24	6062856.0
2011-07-20 10:00:00	MSFT	Stock	27.24	27.26	27.05	27.14	4624904.0
2011-07-20 10:30:00	MSFT	Stock	27.14	27.22	27.12	27.18	3240901.0
2011-07-20 11:00:00	MSFT	Stock	27.185	27.24	27.12	27.12	4071478.0
2011-07-20 11:30:00	MSFT	Stock	27.125	27.15	27.02	27.025	2652734.0
2011-07-20 12:00:00	MSFT	Stock	27.03	27.09	27.0	27.07	2386601.0
2011-07-20 12:30:00	MSFT	Stock	27.07	27.13	27.05	27.08	1823760.0
2011-07-20 13:00:00	MSFT	Stock	27.08	27.13	27.06	27.12	1493867.0
2011-07-20 13:30:00	MSFT	Stock	27.115	27.18	27.11	27.121	2223986.0
2011-07-20 14:00:00	MSFT	Stock	27.125	27.17	27.12	27.12	2033462.0
2011-07-20 14:30:00	MSFT	Stock	27.12	27.13	27.015	27.05	2951977.0

> showing 50 of 75,274 rows — these rows as CSV

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