PREVIEW / stock_1min / 2012-08-27

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-08-27.parquet
  size:    11.7 MB
  rows:    868,996
  symbols: 2,788

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-08-27 04:00:00	AAPL	Stock	24.1425	24.2496	24.1425	24.1621	93156.0
2012-08-27 04:02:00	AAPL	Stock	24.1918	24.1918	24.1918	24.1918	2800.0
2012-08-27 04:03:00	AAPL	Stock	24.2036	24.2036	24.2036	24.2036	8400.0
2012-08-27 04:06:00	AAPL	Stock	24.2036	24.2214	24.1786	24.1786	43736.0
2012-08-27 04:07:00	AAPL	Stock	24.1786	24.2021	24.1786	24.2021	22400.0
2012-08-27 04:08:00	AAPL	Stock	24.1607	24.1607	24.1607	24.1607	2800.0
2012-08-27 04:09:00	AAPL	Stock	24.1607	24.1607	24.1457	24.1457	20020.0
2012-08-27 04:10:00	AAPL	Stock	24.1732	24.1736	24.1732	24.1736	9772.0
2012-08-27 04:11:00	AAPL	Stock	24.1729	24.1729	24.1729	24.1729	2800.0
2012-08-27 04:12:00	AAPL	Stock	24.175	24.1786	24.175	24.1786	19600.0
2012-08-27 04:14:00	AAPL	Stock	24.1786	24.1786	24.1786	24.1786	10052.0
2012-08-27 04:18:00	AAPL	Stock	24.2025	24.2025	24.2025	24.2025	3500.0
2012-08-27 04:21:00	AAPL	Stock	24.175	24.175	24.175	24.175	4424.0
2012-08-27 04:29:00	AAPL	Stock	24.2061	24.2061	24.2061	24.2061	5600.0
2012-08-27 04:33:00	AAPL	Stock	24.2486	24.2496	24.2486	24.2496	6496.0
2012-08-27 04:37:00	AAPL	Stock	24.2496	24.2496	24.2496	24.2496	2800.0
2012-08-27 04:40:00	AAPL	Stock	24.2171	24.2171	24.2171	24.2171	2800.0
2012-08-27 04:41:00	AAPL	Stock	24.2479	24.2482	24.2479	24.2482	5600.0
2012-08-27 04:42:00	AAPL	Stock	24.2482	24.2496	24.2482	24.2496	11984.0
2012-08-27 04:46:00	AAPL	Stock	24.2496	24.2496	24.2496	24.2496	11200.0
2012-08-27 04:51:00	AAPL	Stock	24.2293	24.2293	24.2286	24.2286	10920.0
2012-08-27 04:52:00	AAPL	Stock	24.2454	24.2461	24.2454	24.2461	5600.0
2012-08-27 04:57:00	AAPL	Stock	24.2461	24.2461	24.2461	24.2461	2800.0
2012-08-27 05:02:00	AAPL	Stock	24.2457	24.2457	24.2457	24.2457	2800.0
2012-08-27 05:09:00	AAPL	Stock	24.2457	24.2457	24.2457	24.2457	8792.0
2012-08-27 05:10:00	AAPL	Stock	24.25	24.25	24.25	24.25	8092.0
2012-08-27 05:13:00	AAPL	Stock	24.2571	24.2571	24.2571	24.2571	2800.0
2012-08-27 05:14:00	AAPL	Stock	24.25	24.25	24.25	24.25	30800.0
2012-08-27 05:15:00	AAPL	Stock	24.25	24.2575	24.25	24.2504	22960.0
2012-08-27 05:19:00	AAPL	Stock	24.25	24.25	24.25	24.25	8400.0
2012-08-27 05:20:00	AAPL	Stock	24.25	24.25	24.25	24.25	11900.0
2012-08-27 05:21:00	AAPL	Stock	24.25	24.25	24.25	24.25	2800.0
2012-08-27 05:22:00	AAPL	Stock	24.25	24.25	24.25	24.25	14000.0
2012-08-27 05:23:00	AAPL	Stock	24.25	24.25	24.25	24.25	3808.0
2012-08-27 05:25:00	AAPL	Stock	24.2482	24.25	24.2482	24.2482	20580.0
2012-08-27 05:27:00	AAPL	Stock	24.2482	24.2482	24.2482	24.2482	7000.0
2012-08-27 05:32:00	AAPL	Stock	24.2464	24.2464	24.2464	24.2464	2800.0
2012-08-27 05:35:00	AAPL	Stock	24.25	24.25	24.25	24.25	7392.0
2012-08-27 05:50:00	AAPL	Stock	24.2532	24.2536	24.2532	24.2536	16520.0
2012-08-27 05:53:00	AAPL	Stock	24.2536	24.255	24.2536	24.255	5600.0
2012-08-27 05:55:00	AAPL	Stock	24.2554	24.2554	24.2554	24.2554	14000.0
2012-08-27 06:03:00	AAPL	Stock	24.2554	24.2554	24.2432	24.2432	36400.0
2012-08-27 06:04:00	AAPL	Stock	24.2429	24.2429	24.2429	24.2429	14000.0
2012-08-27 06:07:00	AAPL	Stock	24.2429	24.2464	24.2429	24.2464	16800.0
2012-08-27 06:09:00	AAPL	Stock	24.2429	24.2429	24.2429	24.2429	8400.0
2012-08-27 06:17:00	AAPL	Stock	24.2443	24.2443	24.2443	24.2443	8400.0
2012-08-27 06:22:00	AAPL	Stock	24.2446	24.2446	24.2446	24.2446	2800.0
2012-08-27 06:26:00	AAPL	Stock	24.2461	24.2461	24.2461	24.2461	4200.0
2012-08-27 06:27:00	AAPL	Stock	24.2475	24.2479	24.2475	24.2479	10164.0
2012-08-27 06:29:00	AAPL	Stock	24.2446	24.2446	24.2446	24.2446	22820.0

> showing 50 of 868,996 rows — these rows as CSV

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