PREVIEW / stock_1min / 2012-01-18

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-01-18.parquet
  size:    12.9 MB
  rows:    954,326
  symbols: 2,847

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-01-18 04:05:00	AAPL	Stock	15.1921	15.1921	15.1921	15.1921	2800.0
2012-01-18 04:19:00	AAPL	Stock	15.2207	15.2207	15.2207	15.2207	2800.0
2012-01-18 04:21:00	AAPL	Stock	15.2168	15.2168	15.2154	15.2154	16800.0
2012-01-18 04:42:00	AAPL	Stock	15.2218	15.2218	15.2218	15.2218	2800.0
2012-01-18 05:13:00	AAPL	Stock	15.2321	15.2321	15.2321	15.2321	22400.0
2012-01-18 05:14:00	AAPL	Stock	15.2321	15.2321	15.2321	15.2321	5600.0
2012-01-18 05:15:00	AAPL	Stock	15.25	15.25	15.25	15.25	5600.0
2012-01-18 05:17:00	AAPL	Stock	15.25	15.25	15.25	15.25	2800.0
2012-01-18 05:19:00	AAPL	Stock	15.25	15.25	15.25	15.25	5600.0
2012-01-18 06:02:00	AAPL	Stock	15.2321	15.2321	15.2286	15.2286	8400.0
2012-01-18 06:05:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	5600.0
2012-01-18 06:25:00	AAPL	Stock	15.2036	15.2036	15.2036	15.2036	2800.0
2012-01-18 06:26:00	AAPL	Stock	15.2036	15.2036	15.2036	15.2036	8400.0
2012-01-18 07:01:00	AAPL	Stock	15.2143	15.2179	15.2143	15.2179	21840.0
2012-01-18 07:02:00	AAPL	Stock	15.2268	15.2268	15.2268	15.2268	5600.0
2012-01-18 07:03:00	AAPL	Stock	15.2321	15.2321	15.2143	15.2143	12992.0
2012-01-18 07:06:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	9100.0
2012-01-18 07:07:00	AAPL	Stock	15.2071	15.2071	15.2071	15.2071	5600.0
2012-01-18 07:09:00	AAPL	Stock	15.2096	15.2136	15.2057	15.2057	19600.0
2012-01-18 07:10:00	AAPL	Stock	15.1986	15.1986	15.1982	15.1982	8400.0
2012-01-18 07:17:00	AAPL	Stock	15.205	15.205	15.205	15.205	2800.0
2012-01-18 07:22:00	AAPL	Stock	15.1982	15.1982	15.1982	15.1982	5600.0
2012-01-18 07:32:00	AAPL	Stock	15.2054	15.2054	15.2054	15.2054	2800.0
2012-01-18 07:39:00	AAPL	Stock	15.1964	15.2054	15.1964	15.2054	8400.0
2012-01-18 07:44:00	AAPL	Stock	15.2243	15.2243	15.2243	15.2243	2800.0
2012-01-18 07:49:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	8400.0
2012-01-18 07:53:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	28000.0
2012-01-18 07:59:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	11200.0
2012-01-18 08:00:00	AAPL	Stock	15.2093	15.2136	15.2054	15.2054	193760.0
2012-01-18 08:01:00	AAPL	Stock	15.2054	15.2071	15.2054	15.2071	15260.0
2012-01-18 08:02:00	AAPL	Stock	15.2054	15.2071	15.2054	15.2071	21168.0
2012-01-18 08:03:00	AAPL	Stock	15.21	15.2104	15.21	15.2104	12096.0
2012-01-18 08:04:00	AAPL	Stock	15.2057	15.2057	15.1964	15.1986	75292.0
2012-01-18 08:05:00	AAPL	Stock	15.2021	15.2021	15.2021	15.2021	2800.0
2012-01-18 08:06:00	AAPL	Stock	15.2	15.2	15.2	15.2	5600.0
2012-01-18 08:07:00	AAPL	Stock	15.2	15.2018	15.1982	15.1982	31388.0
2012-01-18 08:08:00	AAPL	Stock	15.1996	15.2	15.1996	15.2	28000.0
2012-01-18 08:09:00	AAPL	Stock	15.205	15.2054	15.1289	15.1289	54600.0
2012-01-18 08:11:00	AAPL	Stock	15.2054	15.2071	15.2014	15.2014	21560.0
2012-01-18 08:13:00	AAPL	Stock	15.2036	15.2036	15.2036	15.2036	19600.0
2012-01-18 08:15:00	AAPL	Stock	15.2079	15.2079	15.2079	15.2079	2800.0
2012-01-18 08:17:00	AAPL	Stock	15.21	15.2136	15.21	15.2136	26600.0
2012-01-18 08:18:00	AAPL	Stock	15.21	15.2143	15.21	15.2143	65716.0
2012-01-18 08:19:00	AAPL	Stock	15.2179	15.2179	15.2179	15.2179	5992.0
2012-01-18 08:20:00	AAPL	Stock	15.2179	15.2179	15.2179	15.2179	4200.0
2012-01-18 08:21:00	AAPL	Stock	15.2179	15.2179	15.2143	15.2143	85960.0
2012-01-18 08:22:00	AAPL	Stock	15.2179	15.2179	15.2179	15.2179	47180.0
2012-01-18 08:25:00	AAPL	Stock	15.2161	15.2196	15.2143	15.2143	269108.0
2012-01-18 08:26:00	AAPL	Stock	15.2154	15.2179	15.2154	15.2179	22400.0
2012-01-18 08:27:00	AAPL	Stock	15.2179	15.2214	15.2179	15.2214	54628.0

> showing 50 of 954,326 rows — these rows as CSV

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