PREVIEW / stock_1min / 2012-05-25

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-05-25.parquet
  size:    12.0 MB
  rows:    902,700
  symbols: 2,842

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-25 04:00:00	AAPL	Stock	20.25	20.2536	20.25	20.25	26600.0
2012-05-25 04:01:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	14000.0
2012-05-25 04:02:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	11200.0
2012-05-25 04:14:00	AAPL	Stock	20.3357	20.3357	20.3357	20.3357	2800.0
2012-05-25 04:18:00	AAPL	Stock	20.3357	20.3357	20.3357	20.3357	2800.0
2012-05-25 04:24:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	14000.0
2012-05-25 04:42:00	AAPL	Stock	20.3143	20.3143	20.3143	20.3143	7000.0
2012-05-25 04:57:00	AAPL	Stock	20.3	20.3	20.3	20.3	2800.0
2012-05-25 06:12:00	AAPL	Stock	20.3104	20.3104	20.3104	20.3104	5600.0
2012-05-25 06:28:00	AAPL	Stock	20.3036	20.3036	20.3036	20.3036	2800.0
2012-05-25 06:31:00	AAPL	Stock	20.3036	20.3036	20.3036	20.3036	2800.0
2012-05-25 06:49:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	2800.0
2012-05-25 06:53:00	AAPL	Stock	20.2321	20.2321	20.2321	20.2321	36400.0
2012-05-25 07:02:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	11200.0
2012-05-25 07:04:00	AAPL	Stock	20.2643	20.2643	20.2643	20.2643	5600.0
2012-05-25 07:05:00	AAPL	Stock	20.2807	20.2807	20.2807	20.2807	2800.0
2012-05-25 07:06:00	AAPL	Stock	20.2679	20.2679	20.2679	20.2679	4200.0
2012-05-25 07:07:00	AAPL	Stock	20.2679	20.2679	20.2679	20.2679	2800.0
2012-05-25 07:11:00	AAPL	Stock	20.2846	20.2846	20.2846	20.2846	4060.0
2012-05-25 07:13:00	AAPL	Stock	20.2607	20.2607	20.2607	20.2607	2800.0
2012-05-25 07:15:00	AAPL	Stock	20.2679	20.2679	20.2679	20.2679	6720.0
2012-05-25 07:21:00	AAPL	Stock	20.25	20.2857	20.2357	20.2357	59500.0
2012-05-25 07:22:00	AAPL	Stock	20.2679	20.275	20.2657	20.275	22960.0
2012-05-25 07:24:00	AAPL	Stock	20.2711	20.2711	20.2711	20.2711	2800.0
2012-05-25 07:32:00	AAPL	Stock	20.2429	20.2429	20.2429	20.2429	2800.0
2012-05-25 07:33:00	AAPL	Stock	20.2439	20.2439	20.2439	20.2439	2800.0
2012-05-25 07:43:00	AAPL	Stock	20.2464	20.2464	20.2464	20.2464	2800.0
2012-05-25 07:44:00	AAPL	Stock	20.2479	20.2479	20.2479	20.2479	2800.0
2012-05-25 07:45:00	AAPL	Stock	20.2468	20.2468	20.2468	20.2468	2800.0
2012-05-25 07:51:00	AAPL	Stock	20.2589	20.2589	20.2589	20.2589	2800.0
2012-05-25 07:53:00	AAPL	Stock	20.25	20.25	20.25	20.25	2800.0
2012-05-25 07:54:00	AAPL	Stock	20.2482	20.2482	20.2321	20.2321	47600.0
2012-05-25 07:55:00	AAPL	Stock	20.2454	20.275	20.2454	20.255	76440.0
2012-05-25 07:57:00	AAPL	Stock	20.2604	20.2604	20.2604	20.2604	2800.0
2012-05-25 07:59:00	AAPL	Stock	20.2446	20.2446	20.2436	20.2436	5600.0
2012-05-25 08:00:00	AAPL	Stock	20.25	20.2946	20.2375	20.25	70980.0
2012-05-25 08:01:00	AAPL	Stock	20.2586	20.2589	20.2482	20.25	51100.0
2012-05-25 08:02:00	AAPL	Stock	20.2568	20.2568	20.25	20.25	12852.0
2012-05-25 08:03:00	AAPL	Stock	20.25	20.25	20.2404	20.25	37800.0
2012-05-25 08:04:00	AAPL	Stock	20.25	20.25	20.245	20.25	77000.0
2012-05-25 08:05:00	AAPL	Stock	20.25	20.25	20.2471	20.25	12040.0
2012-05-25 08:06:00	AAPL	Stock	20.2507	20.2564	20.25	20.25	46060.0
2012-05-25 08:07:00	AAPL	Stock	20.2493	20.2496	20.2364	20.2364	8400.0
2012-05-25 08:08:00	AAPL	Stock	20.2321	20.2321	20.2161	20.2161	30800.0
2012-05-25 08:09:00	AAPL	Stock	20.2179	20.2179	20.2179	20.2179	2800.0
2012-05-25 08:10:00	AAPL	Stock	20.2229	20.2232	20.2089	20.21	61432.0
2012-05-25 08:11:00	AAPL	Stock	20.2089	20.2089	20.1904	20.1904	42868.0
2012-05-25 08:12:00	AAPL	Stock	20.1964	20.2071	20.1861	20.2071	158956.0
2012-05-25 08:13:00	AAPL	Stock	20.1964	20.1964	20.1964	20.1964	9408.0
2012-05-25 08:14:00	AAPL	Stock	20.1964	20.1964	20.1643	20.1643	68852.0

> showing 50 of 902,700 rows — these rows as CSV

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