PREVIEW / stock_1min / 2010-07-27

all stock 1-min files

  file:    by_date/stock_1min/2010/2010-07-27.parquet
  size:    13.1 MB
  rows:    997,034
  symbols: 2,809

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
2010-07-27 05:15:00	AAPL	Stock	9.2718	9.2718	9.2718	9.2718	3556.0
2010-07-27 05:21:00	AAPL	Stock	9.2661	9.2661	9.25	9.25	8792.0
2010-07-27 05:55:00	AAPL	Stock	9.26	9.26	9.26	9.26	14000.0
2010-07-27 06:10:00	AAPL	Stock	9.2507	9.2507	9.2507	9.2507	9800.0
2010-07-27 06:12:00	AAPL	Stock	9.2679	9.2679	9.2679	9.2679	2800.0
2010-07-27 06:44:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	8400.0
2010-07-27 07:01:00	AAPL	Stock	9.2689	9.2689	9.2689	9.2689	2800.0
2010-07-27 07:03:00	AAPL	Stock	9.2689	9.2689	9.2689	9.2689	2800.0
2010-07-27 07:09:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	5600.0
2010-07-27 07:11:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	8400.0
2010-07-27 07:13:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	2800.0
2010-07-27 07:16:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	8400.0
2010-07-27 07:25:00	AAPL	Stock	9.2579	9.2579	9.255	9.255	19600.0
2010-07-27 07:28:00	AAPL	Stock	9.2464	9.2464	9.2321	9.2321	21000.0
2010-07-27 07:30:00	AAPL	Stock	9.2339	9.2339	9.2321	9.2321	43400.0
2010-07-27 07:33:00	AAPL	Stock	9.2321	9.2321	9.2321	9.2321	2800.0
2010-07-27 07:35:00	AAPL	Stock	9.2318	9.2321	9.2268	9.2268	16800.0
2010-07-27 07:36:00	AAPL	Stock	9.2214	9.2214	9.2214	9.2214	13412.0
2010-07-27 07:37:00	AAPL	Stock	9.2214	9.2214	9.2214	9.2214	5600.0
2010-07-27 07:38:00	AAPL	Stock	9.2214	9.2214	9.215	9.215	27636.0
2010-07-27 07:40:00	AAPL	Stock	9.2254	9.2254	9.2254	9.2254	2800.0
2010-07-27 07:46:00	AAPL	Stock	9.2186	9.2186	9.2179	9.2186	17388.0
2010-07-27 07:47:00	AAPL	Stock	9.2179	9.2179	9.2104	9.2104	89404.0
2010-07-27 07:48:00	AAPL	Stock	9.2143	9.2143	9.2143	9.2143	14000.0
2010-07-27 07:49:00	AAPL	Stock	9.2143	9.2143	9.2143	9.2143	14000.0
2010-07-27 07:50:00	AAPL	Stock	9.2143	9.2143	9.2143	9.2143	11200.0
2010-07-27 07:51:00	AAPL	Stock	9.2139	9.2143	9.2139	9.2143	19600.0
2010-07-27 07:52:00	AAPL	Stock	9.225	9.225	9.225	9.225	2800.0
2010-07-27 07:53:00	AAPL	Stock	9.215	9.215	9.215	9.215	2800.0
2010-07-27 07:56:00	AAPL	Stock	9.2271	9.2321	9.2271	9.2282	15960.0
2010-07-27 08:00:00	AAPL	Stock	9.2282	9.2482	9.2143	9.2368	58912.0
2010-07-27 08:01:00	AAPL	Stock	9.2368	9.2379	9.2368	9.2379	5600.0
2010-07-27 08:02:00	AAPL	Stock	9.2339	9.2339	9.2311	9.2321	8400.0
2010-07-27 08:03:00	AAPL	Stock	9.2321	9.2457	9.2321	9.2457	14840.0
2010-07-27 08:05:00	AAPL	Stock	9.2425	9.2425	9.2425	9.2425	8400.0
2010-07-27 08:06:00	AAPL	Stock	9.2454	9.2464	9.2454	9.2461	14000.0
2010-07-27 08:07:00	AAPL	Stock	9.2464	9.25	9.2464	9.25	39200.0
2010-07-27 08:08:00	AAPL	Stock	9.2504	9.2536	9.2504	9.2536	8400.0
2010-07-27 08:09:00	AAPL	Stock	9.2536	9.2536	9.2536	9.2536	2800.0
2010-07-27 08:10:00	AAPL	Stock	9.2539	9.2625	9.2539	9.2568	23548.0
2010-07-27 08:11:00	AAPL	Stock	9.2575	9.2575	9.2575	9.2575	14000.0
2010-07-27 08:12:00	AAPL	Stock	9.2571	9.2604	9.2571	9.2604	5600.0
2010-07-27 08:13:00	AAPL	Stock	9.2607	9.2639	9.2589	9.2639	19880.0
2010-07-27 08:14:00	AAPL	Stock	9.2639	9.2646	9.2639	9.2646	12600.0
2010-07-27 08:15:00	AAPL	Stock	9.2675	9.2761	9.2639	9.2761	156800.0
2010-07-27 08:16:00	AAPL	Stock	9.2768	9.2818	9.2768	9.28	61600.0
2010-07-27 08:17:00	AAPL	Stock	9.28	9.2804	9.2736	9.2757	85540.0
2010-07-27 08:18:00	AAPL	Stock	9.2718	9.2718	9.2604	9.2604	25200.0
2010-07-27 08:19:00	AAPL	Stock	9.2675	9.2675	9.2675	9.2675	2800.0
2010-07-27 08:20:00	AAPL	Stock	9.2618	9.2621	9.2607	9.2621	22400.0

> showing 50 of 997,034 rows — these rows as CSV

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