PREVIEW / stock_5min / 2010-09-23

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-09-23.parquet
  size:    4.7 MB
  rows:    319,004
  symbols: 3,458

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-09-23 04:50:00	AAPL	Stock	10.2411	10.2411	10.2411	10.2411	2800.0
2010-09-23 05:50:00	AAPL	Stock	10.2286	10.2286	10.2286	10.2286	2800.0
2010-09-23 06:55:00	AAPL	Stock	10.2286	10.2286	10.2286	10.2286	2800.0
2010-09-23 07:00:00	AAPL	Stock	10.2321	10.2411	10.2196	10.2196	55440.0
2010-09-23 07:05:00	AAPL	Stock	10.2182	10.2196	10.2179	10.2196	16800.0
2010-09-23 07:15:00	AAPL	Stock	10.2318	10.2318	10.2318	10.2318	25200.0
2010-09-23 07:20:00	AAPL	Stock	10.2232	10.2232	10.2161	10.2161	27160.0
2010-09-23 07:25:00	AAPL	Stock	10.2157	10.2321	10.2157	10.2321	81200.0
2010-09-23 07:35:00	AAPL	Stock	10.2268	10.2268	10.2232	10.2268	60060.0
2010-09-23 07:40:00	AAPL	Stock	10.2264	10.2268	10.2264	10.2268	9100.0
2010-09-23 07:45:00	AAPL	Stock	10.2307	10.2321	10.2307	10.2321	14000.0
2010-09-23 07:50:00	AAPL	Stock	10.2307	10.2357	10.2279	10.2289	55300.0
2010-09-23 08:00:00	AAPL	Stock	10.2343	10.2479	10.2304	10.2321	428120.0
2010-09-23 08:05:00	AAPL	Stock	10.2321	10.235	10.2268	10.2268	271684.0
2010-09-23 08:10:00	AAPL	Stock	10.2286	10.2307	10.2271	10.2307	123900.0
2010-09-23 08:15:00	AAPL	Stock	10.2321	10.2493	10.2307	10.2493	268100.0
2010-09-23 08:20:00	AAPL	Stock	10.2482	10.2607	10.2382	10.2586	587524.0
2010-09-23 08:25:00	AAPL	Stock	10.2625	10.2625	10.2446	10.25	356104.0
2010-09-23 08:30:00	AAPL	Stock	10.2454	10.2543	10.2232	10.2375	2147348.0
2010-09-23 08:35:00	AAPL	Stock	10.2379	10.2479	10.2286	10.24	663208.0
2010-09-23 08:40:00	AAPL	Stock	10.2461	10.2464	10.2286	10.2464	290556.0
2010-09-23 08:45:00	AAPL	Stock	10.2404	10.2564	10.2357	10.2507	369124.0
2010-09-23 08:50:00	AAPL	Stock	10.2536	10.2543	10.2393	10.2464	362432.0
2010-09-23 08:55:00	AAPL	Stock	10.2432	10.245	10.2321	10.2321	449512.0
2010-09-23 09:00:00	AAPL	Stock	10.2321	10.2382	10.2286	10.2321	425936.0
2010-09-23 09:05:00	AAPL	Stock	10.2325	10.2386	10.2325	10.2339	240100.0
2010-09-23 09:10:00	AAPL	Stock	10.2386	10.2479	10.2364	10.2475	730380.0
2010-09-23 09:15:00	AAPL	Stock	10.2475	10.25	10.2429	10.2429	519848.0
2010-09-23 09:20:00	AAPL	Stock	10.2446	10.2446	10.2393	10.2393	107464.0
2010-09-23 09:25:00	AAPL	Stock	10.24	10.2511	10.2214	10.2339	747796.0
2010-09-23 09:30:00	AAPL	Stock	10.235	10.2657	10.2143	10.2471	23493680.0
2010-09-23 09:35:00	AAPL	Stock	10.2491	10.2929	10.2446	10.2807	18809588.0
2010-09-23 09:40:00	AAPL	Stock	10.2811	10.3029	10.2536	10.2689	21087332.0
2010-09-23 09:45:00	AAPL	Stock	10.2711	10.2857	10.2657	10.2725	9527532.0
2010-09-23 09:50:00	AAPL	Stock	10.2714	10.2989	10.265	10.2918	12124868.0
2010-09-23 09:55:00	AAPL	Stock	10.2918	10.2989	10.2714	10.2793	10091536.0
2010-09-23 10:00:00	AAPL	Stock	10.2804	10.3011	10.2782	10.2854	14950320.0
2010-09-23 10:05:00	AAPL	Stock	10.2879	10.3368	10.2857	10.3261	20063624.0
2010-09-23 10:10:00	AAPL	Stock	10.3264	10.3354	10.3179	10.3271	9436364.0
2010-09-23 10:15:00	AAPL	Stock	10.3271	10.3304	10.315	10.3254	8877792.0
2010-09-23 10:20:00	AAPL	Stock	10.3264	10.3432	10.3246	10.3293	11874912.0
2010-09-23 10:25:00	AAPL	Stock	10.3296	10.3486	10.3261	10.3471	9226616.0
2010-09-23 10:30:00	AAPL	Stock	10.3481	10.3571	10.3425	10.3539	13338080.0
2010-09-23 10:35:00	AAPL	Stock	10.3545	10.3786	10.3529	10.3782	17730916.0
2010-09-23 10:40:00	AAPL	Stock	10.3782	10.4057	10.3761	10.3889	17184076.0
2010-09-23 10:45:00	AAPL	Stock	10.3897	10.3982	10.3718	10.3718	9644404.0
2010-09-23 10:50:00	AAPL	Stock	10.3743	10.3746	10.3575	10.3717	10064544.0
2010-09-23 10:55:00	AAPL	Stock	10.3711	10.375	10.3625	10.3696	6897828.0
2010-09-23 11:00:00	AAPL	Stock	10.3689	10.3886	10.3636	10.3879	5932500.0
2010-09-23 11:05:00	AAPL	Stock	10.3882	10.3921	10.3761	10.3907	7060480.0

> showing 50 of 319,004 rows — these rows as CSV

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