PREVIEW / stock_30min / 2012-04-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-18.parquet
  size:    1.4 MB
  rows:    75,029
  symbols: 3,499

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-04-18 04:00:00	AAPL	Stock	21.7982	21.8964	21.7982	21.8964	198660.0
2012-04-18 04:30:00	AAPL	Stock	21.9089	21.9089	21.8214	21.8393	64400.0
2012-04-18 05:00:00	AAPL	Stock	21.8071	21.8071	21.75	21.75	40600.0
2012-04-18 05:30:00	AAPL	Stock	21.775	21.775	21.6793	21.6889	67200.0
2012-04-18 06:00:00	AAPL	Stock	21.6896	21.6929	21.68	21.6929	42840.0
2012-04-18 06:30:00	AAPL	Stock	21.6964	21.7143	21.6875	21.6968	70140.0
2012-04-18 07:00:00	AAPL	Stock	21.705	21.7143	21.6811	21.6989	274568.0
2012-04-18 07:30:00	AAPL	Stock	21.6996	21.7846	21.6929	21.76	280056.0
2012-04-18 08:00:00	AAPL	Stock	21.7629	21.9821	21.6818	21.9386	5808124.0
2012-04-18 08:30:00	AAPL	Stock	21.9329	21.9554	21.7986	21.8368	5125708.0
2012-04-18 09:00:00	AAPL	Stock	21.8389	21.9321	21.8218	21.9236	5039608.0
2012-04-18 09:30:00	AAPL	Stock	21.9179	22.1518	21.8614	22.1237	167217736.0
2012-04-18 10:00:00	AAPL	Stock	22.1249	22.1311	21.8929	21.9321	89912284.0
2012-04-18 10:30:00	AAPL	Stock	21.9289	21.9821	21.8036	21.9607	85497664.0
2012-04-18 11:00:00	AAPL	Stock	21.96	21.9657	21.5357	21.6582	103651492.0
2012-04-18 11:30:00	AAPL	Stock	21.6589	21.8096	21.5254	21.7814	76424040.0
2012-04-18 12:00:00	AAPL	Stock	21.7786	21.78	21.6146	21.6379	38190824.0
2012-04-18 12:30:00	AAPL	Stock	21.6387	21.7232	21.5814	21.6643	29280804.0
2012-04-18 13:00:00	AAPL	Stock	21.6675	21.7093	21.6068	21.6125	23151296.0
2012-04-18 13:30:00	AAPL	Stock	21.6125	21.6307	21.5435	21.5857	31675504.0
2012-04-18 14:00:00	AAPL	Stock	21.5857	21.9664	21.5636	21.8871	85439284.0
2012-04-18 14:30:00	AAPL	Stock	21.8886	21.9536	21.8414	21.9179	47855528.0
2012-04-18 15:00:00	AAPL	Stock	21.9174	21.9771	21.7357	21.7386	65049628.0
2012-04-18 15:30:00	AAPL	Stock	21.7393	21.8571	21.7182	21.7229	61935636.0
2012-04-18 16:00:00	AAPL	Stock	21.7239	21.9287	21.4989	21.5893	17830232.0
2012-04-18 16:30:00	AAPL	Stock	21.5839	21.7264	21.5714	21.6036	2403548.0
2012-04-18 17:00:00	AAPL	Stock	21.6036	21.6775	21.6036	21.6596	825944.0
2012-04-18 17:30:00	AAPL	Stock	21.6489	21.66	21.6429	21.6439	87080.0
2012-04-18 18:00:00	AAPL	Stock	21.6536	21.6536	21.6082	21.6086	209692.0
2012-04-18 18:30:00	AAPL	Stock	21.6107	21.6114	21.5714	21.5893	272776.0
2012-04-18 19:00:00	AAPL	Stock	21.5893	21.6014	21.5671	21.5696	431844.0
2012-04-18 19:30:00	AAPL	Stock	21.5711	21.6068	21.5664	21.6068	402584.0
2012-04-18 07:00:00	MSFT	Stock	31.28	31.28	31.01	31.2	4622.0
2012-04-18 07:30:00	MSFT	Stock	31.1	31.18	31.1	31.18	2000.0
2012-04-18 08:00:00	MSFT	Stock	31.19	31.26	31.19	31.26	7024.0
2012-04-18 08:30:00	MSFT	Stock	31.29	31.29	31.21	31.22	2335.0
2012-04-18 09:00:00	MSFT	Stock	31.25	31.27	31.21	31.26	11637.0
2012-04-18 09:30:00	MSFT	Stock	31.25	31.31	31.05	31.125	5124577.0
2012-04-18 10:00:00	MSFT	Stock	31.13	31.19	31.1	31.15	2936273.0
2012-04-18 10:30:00	MSFT	Stock	31.15	31.25	31.09	31.175	2333743.0
2012-04-18 11:00:00	MSFT	Stock	31.17	31.2	31.07	31.178	2610172.0
2012-04-18 11:30:00	MSFT	Stock	31.171	31.25	31.13	31.18	2243946.0
2012-04-18 12:00:00	MSFT	Stock	31.19	31.22	31.12	31.16	1577544.0
2012-04-18 12:30:00	MSFT	Stock	31.15	31.16	31.04	31.09	1972418.0
2012-04-18 13:00:00	MSFT	Stock	31.085	31.14	31.08	31.12	1314308.0
2012-04-18 13:30:00	MSFT	Stock	31.126	31.2	31.06	31.1	2252784.0
2012-04-18 14:00:00	MSFT	Stock	31.09	31.205	31.08	31.16	1488559.0
2012-04-18 14:30:00	MSFT	Stock	31.16	31.24	31.13	31.184	1480517.0
2012-04-18 15:00:00	MSFT	Stock	31.185	31.21	31.09	31.122	2331818.0
2012-04-18 15:30:00	MSFT	Stock	31.13	31.2	31.11	31.13	4511311.0

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

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