PREVIEW / stock_30min / 2012-10-22

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-22.parquet
  size:    1.4 MB
  rows:    74,770
  symbols: 3,438

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
2012-10-22 04:00:00	AAPL	Stock	21.8571	21.8571	21.8211	21.8214	32088.0
2012-10-22 04:30:00	AAPL	Stock	21.8393	21.8482	21.8129	21.8286	184380.0
2012-10-22 05:00:00	AAPL	Stock	21.8214	21.875	21.8214	21.875	167552.0
2012-10-22 05:30:00	AAPL	Stock	21.8825	21.8929	21.875	21.875	102788.0
2012-10-22 06:00:00	AAPL	Stock	21.875	21.8929	21.8718	21.875	150780.0
2012-10-22 06:30:00	AAPL	Stock	21.875	21.875	21.8304	21.8393	71540.0
2012-10-22 07:00:00	AAPL	Stock	21.85	21.9325	21.8393	21.9211	751968.0
2012-10-22 07:30:00	AAPL	Stock	21.9143	21.9171	21.8629	21.8857	360136.0
2012-10-22 08:00:00	AAPL	Stock	21.8896	21.9239	21.8421	21.9239	4110484.0
2012-10-22 08:30:00	AAPL	Stock	21.92	21.9286	21.775	21.775	3239152.0
2012-10-22 09:00:00	AAPL	Stock	21.7757	21.8729	21.7571	21.8729	2790480.0
2012-10-22 09:30:00	AAPL	Stock	21.8729	22.2171	21.8129	22.1153	107808708.0
2012-10-22 10:00:00	AAPL	Stock	22.1125	22.2586	22.0989	22.2546	52005828.0
2012-10-22 10:30:00	AAPL	Stock	22.255	22.2818	22.0846	22.1011	36587656.0
2012-10-22 11:00:00	AAPL	Stock	22.0957	22.2232	22.0575	22.2121	33355196.0
2012-10-22 11:30:00	AAPL	Stock	22.2171	22.3107	22.1911	22.2679	31587444.0
2012-10-22 12:00:00	AAPL	Stock	22.2679	22.3267	22.2325	22.2918	22833244.0
2012-10-22 12:30:00	AAPL	Stock	22.2911	22.3393	22.2393	22.3124	20299132.0
2012-10-22 13:00:00	AAPL	Stock	22.31	22.3479	22.2554	22.2607	25067588.0
2012-10-22 13:30:00	AAPL	Stock	22.2607	22.3354	22.1971	22.287	29881628.0
2012-10-22 14:00:00	AAPL	Stock	22.2818	22.3996	22.275	22.3996	24275664.0
2012-10-22 14:30:00	AAPL	Stock	22.3996	22.4268	22.3721	22.4046	22403612.0
2012-10-22 15:00:00	AAPL	Stock	22.4046	22.535	22.3696	22.5332	34527668.0
2012-10-22 15:30:00	AAPL	Stock	22.5279	22.6921	22.5	22.6486	64810816.0
2012-10-22 16:00:00	AAPL	Stock	22.6486	22.6696	21.9741	22.6679	15205036.0
2012-10-22 16:30:00	AAPL	Stock	22.6696	22.6964	22.108	22.6925	927556.0
2012-10-22 17:00:00	AAPL	Stock	22.6893	22.7061	22.6836	22.7	465976.0
2012-10-22 17:30:00	AAPL	Stock	22.7018	22.7107	22.6871	22.7039	339052.0
2012-10-22 18:00:00	AAPL	Stock	22.7054	22.7271	22.6936	22.7271	266868.0
2012-10-22 18:30:00	AAPL	Stock	22.7286	22.7393	22.7139	22.7214	147140.0
2012-10-22 19:00:00	AAPL	Stock	22.7232	22.7318	22.7207	22.725	53144.0
2012-10-22 19:30:00	AAPL	Stock	22.7321	22.7411	22.7261	22.7411	350700.0
2012-10-22 06:00:00	MSFT	Stock	28.85	28.85	28.85	28.85	200.0
2012-10-22 07:00:00	MSFT	Stock	28.85	28.92	28.85	28.89	10009.0
2012-10-22 07:30:00	MSFT	Stock	28.85	28.85	28.8	28.8	6511.0
2012-10-22 08:00:00	MSFT	Stock	28.8	28.92	28.72	28.74	37161.0
2012-10-22 08:30:00	MSFT	Stock	28.75	28.75	28.71	28.71	13070.0
2012-10-22 09:00:00	MSFT	Stock	28.7	28.78	28.67	28.78	44600.0
2012-10-22 09:30:00	MSFT	Stock	28.74	28.83	28.26	28.27	7871004.0
2012-10-22 10:00:00	MSFT	Stock	28.28	28.38	28.15	28.16	5958269.0
2012-10-22 10:30:00	MSFT	Stock	28.17	28.21	28.07	28.12	5916740.0
2012-10-22 11:00:00	MSFT	Stock	28.12	28.18	28.04	28.055	4878746.0
2012-10-22 11:30:00	MSFT	Stock	28.055	28.12	28.03	28.04	4459173.0
2012-10-22 12:00:00	MSFT	Stock	28.05	28.11	28.0	28.07	5594237.0
2012-10-22 12:30:00	MSFT	Stock	28.075	28.13	28.05	28.087	2149160.0
2012-10-22 13:00:00	MSFT	Stock	28.08	28.097	27.89	27.9	6566535.0
2012-10-22 13:30:00	MSFT	Stock	27.906	27.98	27.83	27.97	7438808.0
2012-10-22 14:00:00	MSFT	Stock	27.97	28.04	27.93	27.935	4485952.0
2012-10-22 14:30:00	MSFT	Stock	27.94	27.99	27.91	27.95	5166180.0
2012-10-22 15:00:00	MSFT	Stock	27.955	28.03	27.93	28.0	5020202.0

> showing 50 of 74,770 rows — these rows as CSV

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