PREVIEW / stock_1min / 2016-09-27

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-09-27.parquet
  size:    14.0 MB
  rows:    1,033,251
  symbols: 2,632

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
2016-09-27 04:17:00	AAPL	Stock	28.385	28.385	28.385	28.385	400.0
2016-09-27 04:25:00	AAPL	Stock	28.34	28.34	28.34	28.34	1748.0
2016-09-27 04:56:00	AAPL	Stock	28.325	28.325	28.325	28.325	6800.0
2016-09-27 04:57:00	AAPL	Stock	28.325	28.325	28.2275	28.2275	2072.0
2016-09-27 05:23:00	AAPL	Stock	28.2825	28.2825	28.2825	28.2825	840.0
2016-09-27 05:25:00	AAPL	Stock	28.2825	28.2825	28.2825	28.2825	800.0
2016-09-27 05:44:00	AAPL	Stock	28.2875	28.2875	28.2875	28.2875	416.0
2016-09-27 06:05:00	AAPL	Stock	28.22	28.22	28.22	28.22	400.0
2016-09-27 06:10:00	AAPL	Stock	28.25	28.25	28.25	28.25	1200.0
2016-09-27 06:21:00	AAPL	Stock	28.25	28.25	28.25	28.25	400.0
2016-09-27 06:25:00	AAPL	Stock	28.25	28.25	28.25	28.25	400.0
2016-09-27 06:30:00	AAPL	Stock	28.2275	28.2275	28.2125	28.2125	14000.0
2016-09-27 06:45:00	AAPL	Stock	28.21	28.285	28.21	28.285	7680.0
2016-09-27 06:46:00	AAPL	Stock	28.285	28.2875	28.25	28.2875	9200.0
2016-09-27 06:47:00	AAPL	Stock	28.2725	28.2975	28.2725	28.2975	19280.0
2016-09-27 06:48:00	AAPL	Stock	28.3125	28.32	28.3125	28.32	1160.0
2016-09-27 07:02:00	AAPL	Stock	28.31	28.31	28.31	28.31	800.0
2016-09-27 07:05:00	AAPL	Stock	28.2875	28.2875	28.2875	28.2875	400.0
2016-09-27 07:06:00	AAPL	Stock	28.3125	28.3125	28.3125	28.3125	520.0
2016-09-27 07:11:00	AAPL	Stock	28.265	28.2875	28.265	28.2875	1600.0
2016-09-27 07:13:00	AAPL	Stock	28.29	28.3	28.29	28.3	4320.0
2016-09-27 07:14:00	AAPL	Stock	28.31	28.31	28.3	28.3	4400.0
2016-09-27 07:15:00	AAPL	Stock	28.3	28.3	28.3	28.3	3200.0
2016-09-27 07:18:00	AAPL	Stock	28.3	28.3	28.3	28.3	400.0
2016-09-27 07:19:00	AAPL	Stock	28.3	28.3	28.3	28.3	1200.0
2016-09-27 07:21:00	AAPL	Stock	28.305	28.3225	28.305	28.3225	7480.0
2016-09-27 07:22:00	AAPL	Stock	28.325	28.325	28.325	28.325	16000.0
2016-09-27 07:23:00	AAPL	Stock	28.33	28.33	28.33	28.33	400.0
2016-09-27 07:26:00	AAPL	Stock	28.3375	28.3375	28.325	28.325	10160.0
2016-09-27 07:28:00	AAPL	Stock	28.325	28.325	28.3025	28.325	2800.0
2016-09-27 07:33:00	AAPL	Stock	28.3475	28.35	28.3475	28.35	5200.0
2016-09-27 07:34:00	AAPL	Stock	28.3425	28.3425	28.3425	28.3425	800.0
2016-09-27 07:35:00	AAPL	Stock	28.3425	28.3425	28.3425	28.3425	1200.0
2016-09-27 07:36:00	AAPL	Stock	28.355	28.355	28.355	28.355	4000.0
2016-09-27 07:37:00	AAPL	Stock	28.355	28.355	28.355	28.355	3920.0
2016-09-27 07:40:00	AAPL	Stock	28.36	28.365	28.36	28.36	2320.0
2016-09-27 07:41:00	AAPL	Stock	28.3725	28.375	28.37	28.3725	20400.0
2016-09-27 07:42:00	AAPL	Stock	28.3625	28.3625	28.36	28.36	4820.0
2016-09-27 07:43:00	AAPL	Stock	28.34	28.34	28.34	28.34	400.0
2016-09-27 07:45:00	AAPL	Stock	28.34	28.34	28.34	28.34	720.0
2016-09-27 07:46:00	AAPL	Stock	28.34	28.34	28.34	28.34	2352.0
2016-09-27 07:47:00	AAPL	Stock	28.325	28.325	28.325	28.325	2192.0
2016-09-27 07:48:00	AAPL	Stock	28.325	28.325	28.325	28.325	400.0
2016-09-27 07:52:00	AAPL	Stock	28.33	28.33	28.33	28.33	1952.0
2016-09-27 07:55:00	AAPL	Stock	28.33	28.3475	28.33	28.3475	13024.0
2016-09-27 08:00:00	AAPL	Stock	28.3625	28.3625	28.2875	28.3475	53956.0
2016-09-27 08:01:00	AAPL	Stock	28.1625	28.1625	28.1625	28.1625	4000.0
2016-09-27 08:03:00	AAPL	Stock	28.325	28.325	28.305	28.305	14200.0
2016-09-27 08:04:00	AAPL	Stock	28.3	28.3	28.2875	28.2975	15544.0
2016-09-27 08:05:00	AAPL	Stock	28.2975	28.2975	28.2975	28.2975	2000.0

> showing 50 of 1,033,251 rows — these rows as CSV

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