PREVIEW / stock_30min / 2013-06-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-04.parquet
  size:    1.5 MB
  rows:    79,676
  symbols: 3,502

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-06-04 04:00:00	AAPL	Stock	16.1229	16.1268	16.1229	16.125	21000.0
2013-06-04 06:30:00	AAPL	Stock	16.1071	16.1071	16.0982	16.1004	8400.0
2013-06-04 07:00:00	AAPL	Stock	16.1079	16.1907	16.1071	16.1764	365988.0
2013-06-04 07:30:00	AAPL	Stock	16.1632	16.1918	16.1604	16.1786	349020.0
2013-06-04 08:00:00	AAPL	Stock	16.175	16.225	16.0714	16.2175	1501416.0
2013-06-04 08:30:00	AAPL	Stock	16.2214	16.2214	16.1821	16.1879	771456.0
2013-06-04 09:00:00	AAPL	Stock	16.1936	16.2021	16.1786	16.1857	952504.0
2013-06-04 09:30:00	AAPL	Stock	16.1907	16.2224	16.0989	16.1721	46025000.0
2013-06-04 10:00:00	AAPL	Stock	16.175	16.2118	16.1318	16.205	23155972.0
2013-06-04 10:30:00	AAPL	Stock	16.2025	16.2296	16.1579	16.1604	24359300.0
2013-06-04 11:00:00	AAPL	Stock	16.1604	16.1839	16.1125	16.1768	20300448.0
2013-06-04 11:30:00	AAPL	Stock	16.1791	16.1986	16.1429	16.1875	12020680.0
2013-06-04 12:00:00	AAPL	Stock	16.1871	16.1964	16.1071	16.1104	24449936.0
2013-06-04 12:30:00	AAPL	Stock	16.1104	16.1457	16.1075	16.1379	9683324.0
2013-06-04 13:00:00	AAPL	Stock	16.1364	16.1561	16.0764	16.0879	16987544.0
2013-06-04 13:30:00	AAPL	Stock	16.0839	16.1036	16.0243	16.0561	20472256.0
2013-06-04 14:00:00	AAPL	Stock	16.055	16.055	15.9782	16.0275	17371648.0
2013-06-04 14:30:00	AAPL	Stock	16.0259	16.0616	16.0043	16.0243	13922468.0
2013-06-04 15:00:00	AAPL	Stock	16.025	16.0496	15.9929	16.03	13664784.0
2013-06-04 15:30:00	AAPL	Stock	16.0339	16.1118	16.0254	16.0468	27205472.0
2013-06-04 16:00:00	AAPL	Stock	16.0468	16.0625	16.0294	16.06	8954456.0
2013-06-04 16:30:00	AAPL	Stock	16.0543	16.065	16.0468	16.0643	322812.0
2013-06-04 17:00:00	AAPL	Stock	16.0468	16.0643	15.7857	15.9286	2302580.0
2013-06-04 17:30:00	AAPL	Stock	15.9507	15.9904	15.9146	15.9321	902104.0
2013-06-04 18:00:00	AAPL	Stock	15.9393	16.0468	15.9354	15.9411	661864.0
2013-06-04 18:30:00	AAPL	Stock	15.9411	15.9621	15.9357	15.9621	157192.0
2013-06-04 19:00:00	AAPL	Stock	15.9554	15.9554	15.9379	15.9379	148764.0
2013-06-04 19:30:00	AAPL	Stock	15.9375	15.95	15.9375	15.9379	275380.0
2013-06-04 04:00:00	MSFT	Stock	35.6	35.6	35.6	35.6	100.0
2013-06-04 04:30:00	MSFT	Stock	35.8	35.8	35.8	35.8	186.0
2013-06-04 05:30:00	MSFT	Stock	35.7	35.7	35.7	35.7	100.0
2013-06-04 06:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	200.0
2013-06-04 06:30:00	MSFT	Stock	35.7	35.7	35.7	35.7	200.0
2013-06-04 07:00:00	MSFT	Stock	35.6	35.6	35.59	35.59	3383.0
2013-06-04 07:30:00	MSFT	Stock	35.62	35.62	35.61	35.61	1700.0
2013-06-04 08:00:00	MSFT	Stock	35.67	35.67	35.55	35.64	8122.0
2013-06-04 08:30:00	MSFT	Stock	35.64	35.69	35.59	35.62	88250.0
2013-06-04 09:00:00	MSFT	Stock	35.64	35.69	35.6	35.64	60574.0
2013-06-04 09:30:00	MSFT	Stock	35.62	35.74	35.49	35.52	7042378.0
2013-06-04 10:00:00	MSFT	Stock	35.525	35.56	35.36	35.515	5613867.0
2013-06-04 10:30:00	MSFT	Stock	35.515	35.59	35.47	35.475	3804645.0
2013-06-04 11:00:00	MSFT	Stock	35.47	35.62	35.45	35.62	5410420.0
2013-06-04 11:30:00	MSFT	Stock	35.615	35.685	35.6	35.652	3650698.0
2013-06-04 12:00:00	MSFT	Stock	35.65	35.66	35.475	35.53	4682774.0
2013-06-04 12:30:00	MSFT	Stock	35.535	35.59	35.52	35.543	2868871.0
2013-06-04 13:00:00	MSFT	Stock	35.545	35.56	35.41	35.42	2560039.0
2013-06-04 13:30:00	MSFT	Stock	35.42	35.46	35.25	35.27	3326842.0
2013-06-04 14:00:00	MSFT	Stock	35.275	35.3	35.09	35.12	3324257.0
2013-06-04 14:30:00	MSFT	Stock	35.115	35.175	35.0	35.009	3238093.0
2013-06-04 15:00:00	MSFT	Stock	35.01	35.065	34.771	34.8	6384763.0

> showing 50 of 79,676 rows — these rows as CSV

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