PREVIEW / stock_30min / 2012-07-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-19.parquet
  size:    1.4 MB
  rows:    74,039
  symbols: 3,485

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-07-19 04:00:00	AAPL	Stock	21.7839	21.8032	21.7839	21.8032	6020.0
2012-07-19 05:30:00	AAPL	Stock	21.7843	21.7846	21.7843	21.7846	19600.0
2012-07-19 06:00:00	AAPL	Stock	21.8	21.8143	21.8	21.8143	25200.0
2012-07-19 06:30:00	AAPL	Stock	21.7893	21.7893	21.7554	21.7821	54740.0
2012-07-19 07:00:00	AAPL	Stock	21.7786	21.7804	21.7418	21.75	112980.0
2012-07-19 07:30:00	AAPL	Stock	21.7464	21.7857	21.7286	21.7786	453292.0
2012-07-19 08:00:00	AAPL	Stock	21.7721	21.8125	21.75	21.7954	1163316.0
2012-07-19 08:30:00	AAPL	Stock	21.7857	21.8129	21.7636	21.7946	1837696.0
2012-07-19 09:00:00	AAPL	Stock	21.7996	21.8857	21.7857	21.8336	3216444.0
2012-07-19 09:30:00	AAPL	Stock	21.8329	21.8739	21.7232	21.7643	60261544.0
2012-07-19 10:00:00	AAPL	Stock	21.7632	21.8518	21.7411	21.8275	42455952.0
2012-07-19 10:30:00	AAPL	Stock	21.8286	21.8286	21.7643	21.7696	21671188.0
2012-07-19 11:00:00	AAPL	Stock	21.7739	21.8689	21.7725	21.8679	30498216.0
2012-07-19 11:30:00	AAPL	Stock	21.8689	21.87	21.8079	21.8257	20924848.0
2012-07-19 12:00:00	AAPL	Stock	21.8261	21.9243	21.6429	21.9161	38413116.0
2012-07-19 12:30:00	AAPL	Stock	21.9157	21.925	21.8629	21.8671	25425652.0
2012-07-19 13:00:00	AAPL	Stock	21.8675	21.9643	21.8664	21.9611	31102708.0
2012-07-19 13:30:00	AAPL	Stock	21.96	21.96	21.8689	21.8904	25604936.0
2012-07-19 14:00:00	AAPL	Stock	21.895	21.9643	21.8904	21.95	26855976.0
2012-07-19 14:30:00	AAPL	Stock	21.9475	21.9539	21.8771	21.8896	23008860.0
2012-07-19 15:00:00	AAPL	Stock	21.8896	21.955	21.8861	21.9482	25130252.0
2012-07-19 15:30:00	AAPL	Stock	21.9464	21.9768	21.9189	21.9436	39924948.0
2012-07-19 16:00:00	AAPL	Stock	21.9414	22.04	21.872	21.9436	9773120.0
2012-07-19 16:30:00	AAPL	Stock	21.9436	21.9577	21.8969	21.9429	1051036.0
2012-07-19 17:00:00	AAPL	Stock	21.9429	21.9589	21.94	21.9436	238308.0
2012-07-19 17:30:00	AAPL	Stock	21.9446	21.9568	21.9286	21.9554	194264.0
2012-07-19 18:00:00	AAPL	Stock	21.95	21.9571	21.9432	21.9571	163296.0
2012-07-19 18:30:00	AAPL	Stock	21.9607	21.9782	21.9607	21.9782	98532.0
2012-07-19 19:00:00	AAPL	Stock	21.9732	22.0104	21.9732	21.9964	284984.0
2012-07-19 19:30:00	AAPL	Stock	21.9964	22.0118	21.9964	22.0004	186956.0
2012-07-19 07:00:00	MSFT	Stock	30.5	30.5	30.5	30.5	200.0
2012-07-19 07:30:00	MSFT	Stock	30.6	30.62	30.59	30.62	1660.0
2012-07-19 08:00:00	MSFT	Stock	30.62	30.7	30.51	30.63	13908.0
2012-07-19 08:30:00	MSFT	Stock	30.61	30.67	30.59	30.6	5958.0
2012-07-19 09:00:00	MSFT	Stock	30.61	30.62	30.51	30.53	51002.0
2012-07-19 09:30:00	MSFT	Stock	30.51	30.8	30.38	30.72	4104434.0
2012-07-19 10:00:00	MSFT	Stock	30.71	30.73	30.5	30.505	4046899.0
2012-07-19 10:30:00	MSFT	Stock	30.505	30.74	30.47	30.642	2847677.0
2012-07-19 11:00:00	MSFT	Stock	30.65	30.71	30.64	30.67	2614150.0
2012-07-19 11:30:00	MSFT	Stock	30.67	30.69	30.58	30.67	2691467.0
2012-07-19 12:00:00	MSFT	Stock	30.67	30.75	30.47	30.71	2301813.0
2012-07-19 12:30:00	MSFT	Stock	30.71	30.74	30.7	30.71	1933342.0
2012-07-19 13:00:00	MSFT	Stock	30.71	30.72	30.66	30.672	1385821.0
2012-07-19 13:30:00	MSFT	Stock	30.675	30.68	30.46	30.53	2823911.0
2012-07-19 14:00:00	MSFT	Stock	30.54	30.66	30.54	30.57	1652166.0
2012-07-19 14:30:00	MSFT	Stock	30.57	30.67	30.53	30.625	2232295.0
2012-07-19 15:00:00	MSFT	Stock	30.63	30.67	30.57	30.62	2761575.0
2012-07-19 15:30:00	MSFT	Stock	30.63	30.74	30.595	30.61	7128198.0
2012-07-19 16:00:00	MSFT	Stock	30.61	31.48	29.79	31.32	5366600.0
2012-07-19 16:30:00	MSFT	Stock	31.33	31.5	30.616	31.45	685280.0

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

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