PREVIEW / stock_5min / 2013-03-05

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-03-05.parquet
  size:    5.1 MB
  rows:    339,670
  symbols: 3,491

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-03-05 04:00:00	AAPL	Stock	14.9893	14.9893	14.9893	14.9893	2800.0
2013-03-05 04:05:00	AAPL	Stock	14.9714	14.9714	14.9496	14.9496	9324.0
2013-03-05 04:30:00	AAPL	Stock	15.0	15.0	14.9893	14.9893	16800.0
2013-03-05 04:40:00	AAPL	Stock	14.9893	14.9893	14.9893	14.9893	2800.0
2013-03-05 05:10:00	AAPL	Stock	14.995	14.995	14.9946	14.9946	14644.0
2013-03-05 05:15:00	AAPL	Stock	14.9946	14.9946	14.9946	14.9946	2800.0
2013-03-05 05:20:00	AAPL	Stock	14.9946	14.9946	14.9946	14.9946	2800.0
2013-03-05 05:25:00	AAPL	Stock	14.9946	15.0	14.9946	15.0	5600.0
2013-03-05 05:30:00	AAPL	Stock	15.0	15.0	15.0	15.0	28000.0
2013-03-05 05:40:00	AAPL	Stock	14.9964	14.9964	14.9946	14.9946	14000.0
2013-03-05 05:45:00	AAPL	Stock	14.9946	15.0	14.9946	15.0	14000.0
2013-03-05 06:15:00	AAPL	Stock	15.0	15.0125	15.0	15.0125	25620.0
2013-03-05 06:20:00	AAPL	Stock	15.0107	15.0107	15.0107	15.0107	8400.0
2013-03-05 06:25:00	AAPL	Stock	15.0018	15.0018	15.0	15.0	8400.0
2013-03-05 06:40:00	AAPL	Stock	15.0071	15.0179	15.0071	15.0179	22288.0
2013-03-05 06:45:00	AAPL	Stock	15.0039	15.0039	15.0004	15.0004	5600.0
2013-03-05 06:50:00	AAPL	Stock	15.0211	15.0211	15.0211	15.0211	2828.0
2013-03-05 06:55:00	AAPL	Stock	15.025	15.0404	15.025	15.0357	33796.0
2013-03-05 07:00:00	AAPL	Stock	15.0246	15.05	15.0246	15.05	35224.0
2013-03-05 07:05:00	AAPL	Stock	15.0446	15.0936	15.0446	15.0936	35644.0
2013-03-05 07:10:00	AAPL	Stock	15.1064	15.125	15.0893	15.1071	90440.0
2013-03-05 07:15:00	AAPL	Stock	15.1021	15.1229	15.1	15.12	45108.0
2013-03-05 07:20:00	AAPL	Stock	15.1161	15.1657	15.1161	15.165	139244.0
2013-03-05 07:25:00	AAPL	Stock	15.1604	15.1607	15.1411	15.1436	70420.0
2013-03-05 07:30:00	AAPL	Stock	15.1425	15.1425	15.1068	15.1164	124124.0
2013-03-05 07:35:00	AAPL	Stock	15.125	15.1339	15.1214	15.1339	49672.0
2013-03-05 07:40:00	AAPL	Stock	15.1411	15.1411	15.1407	15.1407	8400.0
2013-03-05 07:45:00	AAPL	Stock	15.1268	15.1296	15.1071	15.1071	74788.0
2013-03-05 07:50:00	AAPL	Stock	15.1057	15.1071	15.0896	15.0896	68572.0
2013-03-05 07:55:00	AAPL	Stock	15.0857	15.1032	15.0857	15.0982	32900.0
2013-03-05 08:00:00	AAPL	Stock	15.0961	15.1546	14.9821	15.0496	806120.0
2013-03-05 08:05:00	AAPL	Stock	15.0675	15.0714	15.0543	15.07	351260.0
2013-03-05 08:10:00	AAPL	Stock	15.0661	15.0893	15.065	15.0786	292964.0
2013-03-05 08:15:00	AAPL	Stock	15.0775	15.1036	15.0764	15.0925	233352.0
2013-03-05 08:20:00	AAPL	Stock	15.0879	15.0886	15.0304	15.0357	171164.0
2013-03-05 08:25:00	AAPL	Stock	15.0357	15.0432	15.0257	15.035	196560.0
2013-03-05 08:30:00	AAPL	Stock	15.0286	15.0536	15.0275	15.0493	211680.0
2013-03-05 08:35:00	AAPL	Stock	15.0511	15.1036	15.0468	15.0971	377524.0
2013-03-05 08:40:00	AAPL	Stock	15.0921	15.0929	15.0786	15.0882	227192.0
2013-03-05 08:45:00	AAPL	Stock	15.0807	15.0875	15.0554	15.0671	106932.0
2013-03-05 08:50:00	AAPL	Stock	15.0618	15.0618	15.0432	15.0589	114996.0
2013-03-05 08:55:00	AAPL	Stock	15.0604	15.085	15.0536	15.0821	88452.0
2013-03-05 09:00:00	AAPL	Stock	15.0829	15.0982	15.0829	15.0964	316260.0
2013-03-05 09:05:00	AAPL	Stock	15.0964	15.135	15.0929	15.1304	495516.0
2013-03-05 09:10:00	AAPL	Stock	15.13	15.1571	15.1268	15.1571	699664.0
2013-03-05 09:15:00	AAPL	Stock	15.1561	15.1561	15.1286	15.1339	438900.0
2013-03-05 09:20:00	AAPL	Stock	15.1332	15.1379	15.1	15.1004	460768.0
2013-03-05 09:25:00	AAPL	Stock	15.1	15.1004	15.0375	15.0525	792540.0
2013-03-05 09:30:00	AAPL	Stock	15.0525	15.1225	15.0268	15.0714	22994552.0
2013-03-05 09:35:00	AAPL	Stock	15.0714	15.1939	15.0632	15.1757	22253112.0

> showing 50 of 339,670 rows — these rows as CSV

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