PREVIEW / stock_5min / 2011-09-29

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-29.parquet
  size:    4.8 MB
  rows:    327,020
  symbols: 3,482

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-29 04:00:00	AAPL	Stock	14.2857	14.2857	14.2857	14.2857	25200.0
2011-09-29 04:20:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	2800.0
2011-09-29 04:25:00	AAPL	Stock	14.3211	14.3211	14.3125	14.3125	8400.0
2011-09-29 05:10:00	AAPL	Stock	14.3036	14.3036	14.25	14.25	16800.0
2011-09-29 05:15:00	AAPL	Stock	14.3036	14.3214	14.3036	14.3214	25200.0
2011-09-29 06:10:00	AAPL	Stock	14.3211	14.3214	14.3189	14.3214	19600.0
2011-09-29 06:20:00	AAPL	Stock	14.2857	14.2857	14.2857	14.2857	5600.0
2011-09-29 06:30:00	AAPL	Stock	14.2857	14.2857	14.2857	14.2857	4200.0
2011-09-29 06:55:00	AAPL	Stock	14.2857	14.295	14.2521	14.2521	16800.0
2011-09-29 07:00:00	AAPL	Stock	14.2679	14.2918	14.2639	14.2639	64400.0
2011-09-29 07:05:00	AAPL	Stock	14.2518	14.2586	14.2446	14.2464	26460.0
2011-09-29 07:10:00	AAPL	Stock	14.2479	14.2479	14.2479	14.2479	2800.0
2011-09-29 07:15:00	AAPL	Stock	14.25	14.2679	14.25	14.2629	22400.0
2011-09-29 07:20:00	AAPL	Stock	14.25	14.25	14.2336	14.2336	44800.0
2011-09-29 07:25:00	AAPL	Stock	14.2386	14.2421	14.22	14.2421	121800.0
2011-09-29 07:30:00	AAPL	Stock	14.2439	14.2582	14.2311	14.2346	25200.0
2011-09-29 07:35:00	AAPL	Stock	14.2643	14.2643	14.2361	14.2525	60200.0
2011-09-29 07:40:00	AAPL	Stock	14.2511	14.2518	14.2489	14.2518	58800.0
2011-09-29 07:45:00	AAPL	Stock	14.2621	14.2668	14.2554	14.2571	52556.0
2011-09-29 07:50:00	AAPL	Stock	14.2636	14.2636	14.2368	14.2368	29232.0
2011-09-29 07:55:00	AAPL	Stock	14.2275	14.2275	14.2275	14.2275	2800.0
2011-09-29 08:00:00	AAPL	Stock	14.2457	14.2643	14.2457	14.2625	199024.0
2011-09-29 08:05:00	AAPL	Stock	14.2625	14.2668	14.2561	14.2646	65520.0
2011-09-29 08:10:00	AAPL	Stock	14.2575	14.2575	14.2421	14.2507	75572.0
2011-09-29 08:15:00	AAPL	Stock	14.2536	14.2629	14.2521	14.2536	91028.0
2011-09-29 08:20:00	AAPL	Stock	14.2589	14.2661	14.255	14.2625	185220.0
2011-09-29 08:25:00	AAPL	Stock	14.2664	14.2768	14.2614	14.2625	280840.0
2011-09-29 08:30:00	AAPL	Stock	14.2671	14.3393	14.2671	14.3304	1062768.0
2011-09-29 08:35:00	AAPL	Stock	14.3304	14.3929	14.32	14.3786	1087604.0
2011-09-29 08:40:00	AAPL	Stock	14.3757	14.3929	14.3589	14.385	474516.0
2011-09-29 08:45:00	AAPL	Stock	14.3846	14.3857	14.3596	14.3643	475048.0
2011-09-29 08:50:00	AAPL	Stock	14.3746	14.3882	14.3636	14.3671	498540.0
2011-09-29 08:55:00	AAPL	Stock	14.3725	14.3725	14.3571	14.3582	188300.0
2011-09-29 09:00:00	AAPL	Stock	14.3568	14.3571	14.3407	14.3482	280280.0
2011-09-29 09:05:00	AAPL	Stock	14.3482	14.3571	14.3479	14.3571	196840.0
2011-09-29 09:10:00	AAPL	Stock	14.3586	14.3625	14.3507	14.3539	230636.0
2011-09-29 09:15:00	AAPL	Stock	14.3511	14.375	14.3404	14.3743	497924.0
2011-09-29 09:20:00	AAPL	Stock	14.3732	14.3804	14.3679	14.375	343000.0
2011-09-29 09:25:00	AAPL	Stock	14.3661	14.375	14.3518	14.3575	359716.0
2011-09-29 09:30:00	AAPL	Stock	14.3543	14.3646	14.3075	14.3286	15298080.0
2011-09-29 09:35:00	AAPL	Stock	14.3339	14.3557	14.3114	14.3246	10640672.0
2011-09-29 09:40:00	AAPL	Stock	14.3264	14.3496	14.2943	14.3048	8643824.0
2011-09-29 09:45:00	AAPL	Stock	14.3079	14.3143	14.2711	14.2879	8847356.0
2011-09-29 09:50:00	AAPL	Stock	14.2836	14.2882	14.1982	14.2019	11064340.0
2011-09-29 09:55:00	AAPL	Stock	14.1982	14.25	14.195	14.2464	10802372.0
2011-09-29 10:00:00	AAPL	Stock	14.2461	14.2679	14.23	14.2407	6590724.0
2011-09-29 10:05:00	AAPL	Stock	14.2432	14.2657	14.2082	14.2196	6859076.0
2011-09-29 10:10:00	AAPL	Stock	14.215	14.2321	14.1939	14.2289	5058676.0
2011-09-29 10:15:00	AAPL	Stock	14.2286	14.2307	14.1511	14.1689	11089568.0
2011-09-29 10:20:00	AAPL	Stock	14.1664	14.1692	14.0957	14.1109	14399672.0

> showing 50 of 327,020 rows — these rows as CSV

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