PREVIEW / stock_30min / 2013-05-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-22.parquet
  size:    1.6 MB
  rows:    80,015
  symbols: 3,523

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
2013-05-22 04:00:00	AAPL	Stock	15.7246	15.7246	15.7246	15.7246	8400.0
2013-05-22 05:00:00	AAPL	Stock	15.725	15.725	15.725	15.725	2800.0
2013-05-22 05:30:00	AAPL	Stock	15.7818	15.7818	15.7271	15.7271	5600.0
2013-05-22 07:00:00	AAPL	Stock	15.7729	15.79	15.7729	15.7771	145600.0
2013-05-22 07:30:00	AAPL	Stock	15.7768	15.7946	15.7593	15.7946	157920.0
2013-05-22 08:00:00	AAPL	Stock	15.785	15.8929	15.6536	15.8214	2169720.0
2013-05-22 08:30:00	AAPL	Stock	15.8161	15.8682	15.8021	15.8682	740740.0
2013-05-22 09:00:00	AAPL	Stock	15.8668	15.8804	15.8446	15.8589	2110164.0
2013-05-22 09:30:00	AAPL	Stock	15.8575	16.0125	15.8496	15.9661	84906360.0
2013-05-22 10:00:00	AAPL	Stock	15.9696	16.0064	15.9121	15.9421	42924952.0
2013-05-22 10:30:00	AAPL	Stock	15.9464	15.9536	15.7921	15.8343	47799864.0
2013-05-22 11:00:00	AAPL	Stock	15.8271	15.9	15.8036	15.89	32880876.0
2013-05-22 11:30:00	AAPL	Stock	15.89	15.9479	15.8679	15.9136	29230796.0
2013-05-22 12:00:00	AAPL	Stock	15.9132	15.9425	15.8582	15.8582	12680584.0
2013-05-22 12:30:00	AAPL	Stock	15.8585	15.9171	15.8571	15.9171	15395156.0
2013-05-22 13:00:00	AAPL	Stock	15.9132	15.9171	15.8304	15.8494	12079340.0
2013-05-22 13:30:00	AAPL	Stock	15.8468	15.8607	15.7807	15.8446	28628292.0
2013-05-22 14:00:00	AAPL	Stock	15.8446	15.8679	15.7079	15.7393	39713772.0
2013-05-22 14:30:00	AAPL	Stock	15.7393	15.7807	15.6739	15.7622	22730484.0
2013-05-22 15:00:00	AAPL	Stock	15.7604	15.7604	15.6507	15.6809	21538160.0
2013-05-22 15:30:00	AAPL	Stock	15.6811	15.7668	15.6638	15.7636	31715768.0
2013-05-22 16:00:00	AAPL	Stock	15.7636	15.9604	15.7021	15.7775	9783928.0
2013-05-22 16:30:00	AAPL	Stock	15.7636	15.7946	15.7315	15.7911	946820.0
2013-05-22 17:00:00	AAPL	Stock	15.7907	15.7943	15.7636	15.775	408800.0
2013-05-22 17:30:00	AAPL	Stock	15.7839	15.7857	15.7679	15.7714	187488.0
2013-05-22 18:00:00	AAPL	Stock	15.7721	15.7768	15.7021	15.7768	128800.0
2013-05-22 18:30:00	AAPL	Stock	15.7736	15.7768	15.7714	15.7714	121884.0
2013-05-22 19:00:00	AAPL	Stock	15.7829	15.7836	15.7829	15.7836	22400.0
2013-05-22 19:30:00	AAPL	Stock	15.7786	15.7857	15.7768	15.7857	77112.0
2013-05-22 06:00:00	MSFT	Stock	34.85	34.85	34.85	34.85	550.0
2013-05-22 07:00:00	MSFT	Stock	34.89	34.89	34.89	34.89	100.0
2013-05-22 07:30:00	MSFT	Stock	34.89	34.92	34.89	34.92	1476.0
2013-05-22 08:00:00	MSFT	Stock	34.81	34.91	34.75	34.91	15709.0
2013-05-22 08:30:00	MSFT	Stock	34.88	34.9	34.81	34.9	13235.0
2013-05-22 09:00:00	MSFT	Stock	34.88	34.97	34.76	34.8	35015.0
2013-05-22 09:30:00	MSFT	Stock	34.84	34.84	34.38	34.53	6728902.0
2013-05-22 10:00:00	MSFT	Stock	34.53	34.82	34.515	34.76	5467119.0
2013-05-22 10:30:00	MSFT	Stock	34.76	34.78	34.36	34.45	5035912.0
2013-05-22 11:00:00	MSFT	Stock	34.45	34.71	34.44	34.679	5104266.0
2013-05-22 11:30:00	MSFT	Stock	34.67	34.81	34.655	34.75	4171651.0
2013-05-22 12:00:00	MSFT	Stock	34.753	34.79	34.69	34.72	2257819.0
2013-05-22 12:30:00	MSFT	Stock	34.72	34.754	34.7	34.74	2405489.0
2013-05-22 13:00:00	MSFT	Stock	34.74	34.75	34.69	34.708	2208183.0
2013-05-22 13:30:00	MSFT	Stock	34.705	34.71	34.55	34.564	3276894.0
2013-05-22 14:00:00	MSFT	Stock	34.56	34.63	34.47	34.54	5126822.0
2013-05-22 14:30:00	MSFT	Stock	34.54	34.64	34.45	34.63	3594025.0
2013-05-22 15:00:00	MSFT	Stock	34.62	34.625	34.43	34.442	3632250.0
2013-05-22 15:30:00	MSFT	Stock	34.44	34.61	34.42	34.61	6973667.0
2013-05-22 16:00:00	MSFT	Stock	34.61	34.85	34.457	34.603	3814203.0
2013-05-22 16:30:00	MSFT	Stock	34.61	34.75	34.509	34.75	68144.0

> showing 50 of 80,015 rows — these rows as CSV

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