PREVIEW / stock_1min / 2012-05-07

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-05-07.parquet
  size:    13.1 MB
  rows:    985,655
  symbols: 2,849

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-05-07 04:00:00	AAPL	Stock	20.0714	20.0714	20.0714	20.0714	2800.0
2012-05-07 04:12:00	AAPL	Stock	20.025	20.025	20.025	20.025	14000.0
2012-05-07 04:17:00	AAPL	Stock	20.0321	20.0321	20.0321	20.0321	10696.0
2012-05-07 04:24:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	2800.0
2012-05-07 04:34:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	2800.0
2012-05-07 04:39:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	11200.0
2012-05-07 05:29:00	AAPL	Stock	20.1029	20.1029	20.1029	20.1029	2800.0
2012-05-07 05:30:00	AAPL	Stock	20.1029	20.1029	20.1029	20.1029	5600.0
2012-05-07 05:54:00	AAPL	Stock	20.1068	20.1071	20.1068	20.1071	9800.0
2012-05-07 05:55:00	AAPL	Stock	20.1243	20.125	20.1243	20.125	5600.0
2012-05-07 06:02:00	AAPL	Stock	20.1075	20.1075	20.1075	20.1075	2800.0
2012-05-07 06:04:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2012-05-07 06:06:00	AAPL	Stock	20.1293	20.1429	20.125	20.125	8400.0
2012-05-07 06:08:00	AAPL	Stock	20.1607	20.1607	20.1607	20.1607	2800.0
2012-05-07 06:14:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2012-05-07 06:15:00	AAPL	Stock	20.1596	20.1596	20.1596	20.1596	5600.0
2012-05-07 06:44:00	AAPL	Stock	20.1596	20.1596	20.1596	20.1596	5880.0
2012-05-07 06:49:00	AAPL	Stock	20.15	20.15	20.15	20.15	5600.0
2012-05-07 07:01:00	AAPL	Stock	20.1082	20.1082	20.09	20.1071	28560.0
2012-05-07 07:02:00	AAPL	Stock	20.0807	20.0807	20.0786	20.0786	30352.0
2012-05-07 07:03:00	AAPL	Stock	20.0779	20.0779	20.0771	20.0771	5600.0
2012-05-07 07:04:00	AAPL	Stock	20.0754	20.0754	20.0754	20.0754	7056.0
2012-05-07 07:05:00	AAPL	Stock	20.0768	20.0821	20.0668	20.0668	61404.0
2012-05-07 07:06:00	AAPL	Stock	20.0643	20.0643	20.0557	20.0614	12600.0
2012-05-07 07:07:00	AAPL	Stock	20.0589	20.0589	20.0539	20.0539	45640.0
2012-05-07 07:08:00	AAPL	Stock	20.0536	20.0554	20.0536	20.0554	5600.0
2012-05-07 07:09:00	AAPL	Stock	20.0625	20.0714	20.0539	20.0539	83328.0
2012-05-07 07:10:00	AAPL	Stock	20.0536	20.0536	20.0536	20.0536	2800.0
2012-05-07 07:11:00	AAPL	Stock	20.0479	20.0479	20.03	20.03	34412.0
2012-05-07 07:12:00	AAPL	Stock	20.0289	20.0446	20.0214	20.0446	107604.0
2012-05-07 07:14:00	AAPL	Stock	20.0657	20.0657	20.0657	20.0657	2800.0
2012-05-07 07:15:00	AAPL	Stock	20.0657	20.0657	20.05	20.05	14000.0
2012-05-07 07:18:00	AAPL	Stock	20.0536	20.0536	20.0464	20.0464	33600.0
2012-05-07 07:21:00	AAPL	Stock	20.0375	20.0529	20.0368	20.0529	11172.0
2012-05-07 07:22:00	AAPL	Stock	20.0461	20.0536	20.0461	20.0536	21868.0
2012-05-07 07:23:00	AAPL	Stock	20.0464	20.0464	20.03	20.0357	126000.0
2012-05-07 07:24:00	AAPL	Stock	20.0357	20.0536	20.0357	20.0536	20104.0
2012-05-07 07:25:00	AAPL	Stock	20.0471	20.0471	20.0379	20.0379	6440.0
2012-05-07 07:27:00	AAPL	Stock	20.0621	20.0982	20.0621	20.0964	19460.0
2012-05-07 07:28:00	AAPL	Stock	20.0818	20.0818	20.0818	20.0818	5600.0
2012-05-07 07:29:00	AAPL	Stock	20.0943	20.0943	20.0929	20.0943	14812.0
2012-05-07 07:30:00	AAPL	Stock	20.0964	20.0964	20.0964	20.0964	4200.0
2012-05-07 07:31:00	AAPL	Stock	20.0893	20.0893	20.0721	20.0764	42000.0
2012-05-07 07:32:00	AAPL	Stock	20.0893	20.0893	20.0771	20.0807	8400.0
2012-05-07 07:33:00	AAPL	Stock	20.0754	20.0754	20.0754	20.0754	2800.0
2012-05-07 07:34:00	AAPL	Stock	20.0732	20.0893	20.0732	20.0893	6300.0
2012-05-07 07:35:00	AAPL	Stock	20.0896	20.0964	20.0896	20.0896	15596.0
2012-05-07 07:36:00	AAPL	Stock	20.0893	20.0893	20.0893	20.0893	7728.0
2012-05-07 07:37:00	AAPL	Stock	20.0886	20.0886	20.0886	20.0886	2800.0
2012-05-07 07:38:00	AAPL	Stock	20.0821	20.0821	20.0821	20.0821	8400.0

> showing 50 of 985,655 rows — these rows as CSV

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