PREVIEW / stock_5min / 2010-07-27

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-27.parquet
  size:    4.8 MB
  rows:    330,224
  symbols: 3,465

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-07-27 05:15:00	AAPL	Stock	9.2718	9.2718	9.2718	9.2718	3556.0
2010-07-27 05:20:00	AAPL	Stock	9.2661	9.2661	9.25	9.25	8792.0
2010-07-27 05:55:00	AAPL	Stock	9.26	9.26	9.26	9.26	14000.0
2010-07-27 06:10:00	AAPL	Stock	9.2507	9.2679	9.2507	9.2679	12600.0
2010-07-27 06:40:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	8400.0
2010-07-27 07:00:00	AAPL	Stock	9.2689	9.2689	9.2689	9.2689	5600.0
2010-07-27 07:05:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	5600.0
2010-07-27 07:10:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	11200.0
2010-07-27 07:15:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	8400.0
2010-07-27 07:25:00	AAPL	Stock	9.2579	9.2579	9.2321	9.2321	40600.0
2010-07-27 07:30:00	AAPL	Stock	9.2339	9.2339	9.2321	9.2321	46200.0
2010-07-27 07:35:00	AAPL	Stock	9.2318	9.2321	9.215	9.215	63448.0
2010-07-27 07:40:00	AAPL	Stock	9.2254	9.2254	9.2254	9.2254	2800.0
2010-07-27 07:45:00	AAPL	Stock	9.2186	9.2186	9.2104	9.2143	134792.0
2010-07-27 07:50:00	AAPL	Stock	9.2143	9.225	9.2139	9.215	36400.0
2010-07-27 07:55:00	AAPL	Stock	9.2271	9.2321	9.2271	9.2282	15960.0
2010-07-27 08:00:00	AAPL	Stock	9.2282	9.2482	9.2143	9.2457	87752.0
2010-07-27 08:05:00	AAPL	Stock	9.2425	9.2536	9.2425	9.2536	72800.0
2010-07-27 08:10:00	AAPL	Stock	9.2539	9.2646	9.2539	9.2646	75628.0
2010-07-27 08:15:00	AAPL	Stock	9.2675	9.2818	9.2604	9.2675	331940.0
2010-07-27 08:20:00	AAPL	Stock	9.2618	9.275	9.2571	9.2643	243880.0
2010-07-27 08:25:00	AAPL	Stock	9.2643	9.2732	9.2643	9.2679	178108.0
2010-07-27 08:30:00	AAPL	Stock	9.2711	9.2839	9.2704	9.2732	541520.0
2010-07-27 08:35:00	AAPL	Stock	9.2775	9.3136	9.2768	9.3125	997696.0
2010-07-27 08:40:00	AAPL	Stock	9.3125	9.3193	9.3043	9.3107	579880.0
2010-07-27 08:45:00	AAPL	Stock	9.3107	9.3186	9.305	9.305	389172.0
2010-07-27 08:50:00	AAPL	Stock	9.305	9.305	9.2975	9.3025	235200.0
2010-07-27 08:55:00	AAPL	Stock	9.3032	9.3036	9.2971	9.2979	229404.0
2010-07-27 09:00:00	AAPL	Stock	9.2982	9.3036	9.2904	9.3014	434980.0
2010-07-27 09:05:00	AAPL	Stock	9.3018	9.3143	9.3014	9.3014	460572.0
2010-07-27 09:10:00	AAPL	Stock	9.3018	9.3018	9.2879	9.3007	486332.0
2010-07-27 09:15:00	AAPL	Stock	9.2989	9.3032	9.2943	9.3021	156800.0
2010-07-27 09:20:00	AAPL	Stock	9.3021	9.3157	9.3021	9.3146	314748.0
2010-07-27 09:25:00	AAPL	Stock	9.3129	9.3339	9.3129	9.3171	1461880.0
2010-07-27 09:30:00	AAPL	Stock	9.3168	9.3525	9.2964	9.3393	22962072.0
2010-07-27 09:35:00	AAPL	Stock	9.3393	9.3636	9.3193	9.3629	16757412.0
2010-07-27 09:40:00	AAPL	Stock	9.3618	9.3793	9.355	9.3611	17173156.0
2010-07-27 09:45:00	AAPL	Stock	9.3589	9.3846	9.3568	9.3668	16284240.0
2010-07-27 09:50:00	AAPL	Stock	9.3661	9.3925	9.3568	9.3829	17532032.0
2010-07-27 09:55:00	AAPL	Stock	9.3832	9.4071	9.3771	9.3979	16907660.0
2010-07-27 10:00:00	AAPL	Stock	9.3954	9.4193	9.3893	9.4011	18309508.0
2010-07-27 10:05:00	AAPL	Stock	9.4021	9.4039	9.3518	9.3571	17411380.0
2010-07-27 10:10:00	AAPL	Stock	9.3568	9.3729	9.3464	9.3579	12981668.0
2010-07-27 10:15:00	AAPL	Stock	9.3586	9.3771	9.3521	9.3771	10960600.0
2010-07-27 10:20:00	AAPL	Stock	9.3764	9.3929	9.3671	9.3825	8412488.0
2010-07-27 10:25:00	AAPL	Stock	9.3829	9.4014	9.3704	9.4004	8226624.0
2010-07-27 10:30:00	AAPL	Stock	9.4014	9.4054	9.38	9.3821	9736132.0
2010-07-27 10:35:00	AAPL	Stock	9.3818	9.3936	9.3714	9.3721	6764016.0
2010-07-27 10:40:00	AAPL	Stock	9.3721	9.3829	9.3668	9.3692	5547976.0
2010-07-27 10:45:00	AAPL	Stock	9.3675	9.3899	9.3636	9.3743	6960968.0

> showing 50 of 330,224 rows — these rows as CSV

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