PREVIEW / stock_5min / 2010-07-12

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-12.parquet
  size:    4.5 MB
  rows:    313,362
  symbols: 3,468

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-12 04:15:00	AAPL	Stock	9.2507	9.2507	9.2507	9.2507	5236.0
2010-07-12 04:25:00	AAPL	Stock	9.2286	9.2286	9.2286	9.2286	2800.0
2010-07-12 07:10:00	AAPL	Stock	9.245	9.245	9.2429	9.2429	27440.0
2010-07-12 07:15:00	AAPL	Stock	9.25	9.25	9.25	9.25	2800.0
2010-07-12 07:25:00	AAPL	Stock	9.25	9.25	9.25	9.25	2800.0
2010-07-12 07:40:00	AAPL	Stock	9.25	9.25	9.25	9.25	2800.0
2010-07-12 07:50:00	AAPL	Stock	9.25	9.2571	9.25	9.2571	11200.0
2010-07-12 08:00:00	AAPL	Stock	9.2586	9.2643	9.2496	9.25	137480.0
2010-07-12 08:05:00	AAPL	Stock	9.25	9.2579	9.245	9.2571	40740.0
2010-07-12 08:10:00	AAPL	Stock	9.2586	9.2586	9.2539	9.2539	37800.0
2010-07-12 08:15:00	AAPL	Stock	9.2571	9.2571	9.2482	9.2482	66248.0
2010-07-12 08:20:00	AAPL	Stock	9.2482	9.2554	9.2482	9.2554	14000.0
2010-07-12 08:25:00	AAPL	Stock	9.2525	9.2561	9.2525	9.2546	72800.0
2010-07-12 08:30:00	AAPL	Stock	9.2514	9.2521	9.2514	9.2518	11200.0
2010-07-12 08:35:00	AAPL	Stock	9.2536	9.2561	9.2536	9.2546	16520.0
2010-07-12 08:40:00	AAPL	Stock	9.2757	9.2757	9.2546	9.2664	178808.0
2010-07-12 08:45:00	AAPL	Stock	9.2654	9.2818	9.2654	9.275	101080.0
2010-07-12 08:50:00	AAPL	Stock	9.2764	9.2818	9.2714	9.275	92400.0
2010-07-12 08:55:00	AAPL	Stock	9.2696	9.2739	9.2679	9.2679	16800.0
2010-07-12 09:05:00	AAPL	Stock	9.2668	9.2668	9.2586	9.2618	26096.0
2010-07-12 09:10:00	AAPL	Stock	9.2618	9.2625	9.26	9.2621	112000.0
2010-07-12 09:15:00	AAPL	Stock	9.2607	9.2607	9.2375	9.2429	431704.0
2010-07-12 09:20:00	AAPL	Stock	9.2411	9.2411	9.2386	9.2393	11200.0
2010-07-12 09:25:00	AAPL	Stock	9.2361	9.2414	9.2232	9.2321	166964.0
2010-07-12 09:30:00	AAPL	Stock	9.2357	9.2657	9.2002	9.2598	16877056.0
2010-07-12 09:35:00	AAPL	Stock	9.2582	9.28	9.2536	9.2614	13006224.0
2010-07-12 09:40:00	AAPL	Stock	9.2611	9.3132	9.2593	9.3086	13117160.0
2010-07-12 09:45:00	AAPL	Stock	9.3082	9.3486	9.3082	9.3343	13613796.0
2010-07-12 09:50:00	AAPL	Stock	9.3352	9.3429	9.3079	9.3161	10920336.0
2010-07-12 09:55:00	AAPL	Stock	9.3157	9.3375	9.3139	9.3268	7491400.0
2010-07-12 10:00:00	AAPL	Stock	9.3279	9.3518	9.3225	9.325	13249544.0
2010-07-12 10:05:00	AAPL	Stock	9.3246	9.3321	9.3089	9.3105	8291640.0
2010-07-12 10:10:00	AAPL	Stock	9.3105	9.3164	9.2964	9.3058	8570072.0
2010-07-12 10:15:00	AAPL	Stock	9.3061	9.3257	9.3004	9.325	5818428.0
2010-07-12 10:20:00	AAPL	Stock	9.3254	9.3254	9.2857	9.29	10059644.0
2010-07-12 10:25:00	AAPL	Stock	9.29	9.2954	9.2736	9.2768	8677060.0
2010-07-12 10:30:00	AAPL	Stock	9.2761	9.2769	9.2454	9.2503	11736564.0
2010-07-12 10:35:00	AAPL	Stock	9.2489	9.2707	9.2457	9.2689	7450492.0
2010-07-12 10:40:00	AAPL	Stock	9.2671	9.2707	9.2321	9.2446	7002576.0
2010-07-12 10:45:00	AAPL	Stock	9.2432	9.2589	9.2396	9.2471	3944696.0
2010-07-12 10:50:00	AAPL	Stock	9.2464	9.2636	9.2411	9.25	3494064.0
2010-07-12 10:55:00	AAPL	Stock	9.2504	9.2711	9.2454	9.2704	4659032.0
2010-07-12 11:00:00	AAPL	Stock	9.2696	9.2697	9.2418	9.25	5668516.0
2010-07-12 11:05:00	AAPL	Stock	9.2503	9.2543	9.2361	9.245	4535132.0
2010-07-12 11:10:00	AAPL	Stock	9.24	9.2529	9.225	9.2518	5252996.0
2010-07-12 11:15:00	AAPL	Stock	9.2529	9.2529	9.2393	9.2439	3354288.0
2010-07-12 11:20:00	AAPL	Stock	9.2432	9.25	9.2164	9.2229	10079020.0
2010-07-12 11:25:00	AAPL	Stock	9.2214	9.2332	9.2071	9.2071	6233444.0
2010-07-12 11:30:00	AAPL	Stock	9.2071	9.2232	9.2029	9.21	7472892.0
2010-07-12 11:35:00	AAPL	Stock	9.21	9.2121	9.195	9.1964	7611716.0

> showing 50 of 313,362 rows — these rows as CSV

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