PREVIEW / stock_5min / 2011-09-23

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-23.parquet
  size:    4.9 MB
  rows:    331,842
  symbols: 3,512

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
2011-09-23 04:00:00	AAPL	Stock	14.4286	14.4286	14.4286	14.4286	2800.0
2011-09-23 04:30:00	AAPL	Stock	14.4986	14.5	14.4986	14.5	8400.0
2011-09-23 04:35:00	AAPL	Stock	14.5	14.5	14.5	14.5	2800.0
2011-09-23 04:40:00	AAPL	Stock	14.5	14.5	14.4821	14.4821	25200.0
2011-09-23 04:45:00	AAPL	Stock	14.4643	14.4643	14.4529	14.4529	16520.0
2011-09-23 04:50:00	AAPL	Stock	14.4518	14.4607	14.4518	14.4571	16800.0
2011-09-23 04:55:00	AAPL	Stock	14.4518	14.4518	14.4464	14.4464	8400.0
2011-09-23 05:00:00	AAPL	Stock	14.4464	14.4464	14.4307	14.4307	8400.0
2011-09-23 05:05:00	AAPL	Stock	14.4321	14.4339	14.4286	14.4286	8400.0
2011-09-23 05:15:00	AAPL	Stock	14.4339	14.4375	14.4339	14.4375	8400.0
2011-09-23 05:20:00	AAPL	Stock	14.4375	14.4375	14.4375	14.4375	2800.0
2011-09-23 05:25:00	AAPL	Stock	14.4521	14.4521	14.4518	14.4518	8400.0
2011-09-23 05:30:00	AAPL	Stock	14.4393	14.4393	14.4375	14.4375	14000.0
2011-09-23 05:40:00	AAPL	Stock	14.4157	14.4157	14.4125	14.4125	5600.0
2011-09-23 05:50:00	AAPL	Stock	14.4096	14.4096	14.3929	14.3929	11200.0
2011-09-23 06:00:00	AAPL	Stock	14.3939	14.3939	14.3904	14.3911	19600.0
2011-09-23 06:05:00	AAPL	Stock	14.3693	14.3693	14.3661	14.3661	11200.0
2011-09-23 06:20:00	AAPL	Stock	14.3304	14.3304	14.3304	14.3304	2800.0
2011-09-23 06:25:00	AAPL	Stock	14.3036	14.3036	14.3036	14.3036	11200.0
2011-09-23 06:30:00	AAPL	Stock	14.2807	14.2807	14.2807	14.2807	2800.0
2011-09-23 06:35:00	AAPL	Stock	14.2771	14.2771	14.25	14.25	11620.0
2011-09-23 06:45:00	AAPL	Stock	14.2314	14.2314	14.2314	14.2314	2800.0
2011-09-23 06:50:00	AAPL	Stock	14.2161	14.2457	14.2154	14.2154	28308.0
2011-09-23 06:55:00	AAPL	Stock	14.2232	14.25	14.2146	14.25	11200.0
2011-09-23 07:00:00	AAPL	Stock	14.2857	14.2857	14.2221	14.25	82600.0
2011-09-23 07:05:00	AAPL	Stock	14.2404	14.2854	14.24	14.2854	81200.0
2011-09-23 07:10:00	AAPL	Stock	14.2839	14.2996	14.2618	14.275	206500.0
2011-09-23 07:15:00	AAPL	Stock	14.275	14.2857	14.2571	14.2571	234612.0
2011-09-23 07:20:00	AAPL	Stock	14.2564	14.2564	14.2325	14.2325	56196.0
2011-09-23 07:25:00	AAPL	Stock	14.2236	14.25	14.2168	14.25	123116.0
2011-09-23 07:30:00	AAPL	Stock	14.2479	14.25	14.2218	14.2218	120400.0
2011-09-23 07:35:00	AAPL	Stock	14.2218	14.2218	14.1911	14.2136	36400.0
2011-09-23 07:40:00	AAPL	Stock	14.21	14.2321	14.2075	14.2075	60340.0
2011-09-23 07:45:00	AAPL	Stock	14.2082	14.2193	14.2071	14.2107	42616.0
2011-09-23 07:50:00	AAPL	Stock	14.2193	14.2286	14.1964	14.1964	125300.0
2011-09-23 07:55:00	AAPL	Stock	14.1964	14.2111	14.1786	14.2018	294616.0
2011-09-23 08:00:00	AAPL	Stock	14.2071	14.3507	14.1571	14.1571	769244.0
2011-09-23 08:05:00	AAPL	Stock	14.1525	14.1679	14.1271	14.1636	579152.0
2011-09-23 08:10:00	AAPL	Stock	14.1614	14.1679	14.1446	14.1643	707252.0
2011-09-23 08:15:00	AAPL	Stock	14.1518	14.1882	14.1507	14.1882	561176.0
2011-09-23 08:20:00	AAPL	Stock	14.1893	14.2289	14.1893	14.2214	438424.0
2011-09-23 08:25:00	AAPL	Stock	14.2164	14.2857	14.2111	14.2518	617820.0
2011-09-23 08:30:00	AAPL	Stock	14.2561	14.2814	14.2482	14.2589	495320.0
2011-09-23 08:35:00	AAPL	Stock	14.2625	14.27	14.2207	14.2225	768264.0
2011-09-23 08:40:00	AAPL	Stock	14.2339	14.2386	14.2143	14.2175	307972.0
2011-09-23 08:45:00	AAPL	Stock	14.2164	14.2571	14.2164	14.2504	223720.0
2011-09-23 08:50:00	AAPL	Stock	14.2561	14.2782	14.2561	14.2714	483784.0
2011-09-23 08:55:00	AAPL	Stock	14.2639	14.2696	14.2496	14.25	406420.0
2011-09-23 09:00:00	AAPL	Stock	14.25	14.3079	14.25	14.3036	863128.0
2011-09-23 09:05:00	AAPL	Stock	14.3079	14.3818	14.3079	14.3454	1309980.0

> showing 50 of 331,842 rows — these rows as CSV

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