PREVIEW / stock_5min / 2009-04-09

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-09.parquet
  size:    4.6 MB
  rows:    319,171
  symbols: 3,364

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
2009-04-09 07:55:00	AAPL	Stock	4.1643	4.1643	4.1643	4.1643	2800.0
2009-04-09 08:00:00	AAPL	Stock	4.1779	4.1911	4.1779	4.1911	291508.0
2009-04-09 08:05:00	AAPL	Stock	4.1904	4.2043	4.1904	4.2043	211400.0
2009-04-09 08:10:00	AAPL	Stock	4.2057	4.2143	4.2057	4.2143	247940.0
2009-04-09 08:15:00	AAPL	Stock	4.2143	4.2214	4.2143	4.2211	184156.0
2009-04-09 08:20:00	AAPL	Stock	4.2225	4.235	4.2225	4.235	489804.0
2009-04-09 08:25:00	AAPL	Stock	4.235	4.2357	4.22	4.2232	112056.0
2009-04-09 08:30:00	AAPL	Stock	4.2232	4.2339	4.2214	4.2339	442736.0
2009-04-09 08:35:00	AAPL	Stock	4.2321	4.2321	4.2232	4.2268	318080.0
2009-04-09 08:40:00	AAPL	Stock	4.2268	4.2339	4.2268	4.2293	261100.0
2009-04-09 08:45:00	AAPL	Stock	4.2268	4.2268	4.2236	4.2243	130396.0
2009-04-09 08:50:00	AAPL	Stock	4.2243	4.2393	4.2243	4.2332	307636.0
2009-04-09 08:55:00	AAPL	Stock	4.2379	4.245	4.2375	4.2429	170268.0
2009-04-09 09:00:00	AAPL	Stock	4.2443	4.2443	4.2357	4.2357	171220.0
2009-04-09 09:05:00	AAPL	Stock	4.2321	4.2357	4.2243	4.2243	255388.0
2009-04-09 09:10:00	AAPL	Stock	4.2275	4.2429	4.2243	4.2429	743148.0
2009-04-09 09:15:00	AAPL	Stock	4.2321	4.235	4.2282	4.2318	329504.0
2009-04-09 09:20:00	AAPL	Stock	4.2318	4.2318	4.2293	4.2293	40124.0
2009-04-09 09:25:00	AAPL	Stock	4.2293	4.2375	4.2282	4.2321	452200.0
2009-04-09 09:30:00	AAPL	Stock	4.2318	4.2332	4.2129	4.2271	16672712.0
2009-04-09 09:35:00	AAPL	Stock	4.2279	4.2411	4.225	4.2343	14465976.0
2009-04-09 09:40:00	AAPL	Stock	4.2346	4.2632	4.2325	4.2596	14410312.0
2009-04-09 09:45:00	AAPL	Stock	4.2575	4.2671	4.2468	4.2489	16776032.0
2009-04-09 09:50:00	AAPL	Stock	4.2504	4.2632	4.2504	4.2589	11689188.0
2009-04-09 09:55:00	AAPL	Stock	4.2586	4.2643	4.2511	4.2586	11041464.0
2009-04-09 10:00:00	AAPL	Stock	4.2589	4.2643	4.2482	4.2514	9483432.0
2009-04-09 10:05:00	AAPL	Stock	4.2514	4.2739	4.2514	4.2668	12050304.0
2009-04-09 10:10:00	AAPL	Stock	4.2668	4.2671	4.2586	4.2621	8532552.0
2009-04-09 10:15:00	AAPL	Stock	4.2619	4.2661	4.26	4.2639	5828032.0
2009-04-09 10:20:00	AAPL	Stock	4.2639	4.2721	4.2618	4.2664	6879908.0
2009-04-09 10:25:00	AAPL	Stock	4.2663	4.2771	4.265	4.2679	7370720.0
2009-04-09 10:30:00	AAPL	Stock	4.2679	4.2689	4.2625	4.2686	6287036.0
2009-04-09 10:35:00	AAPL	Stock	4.2686	4.2814	4.2668	4.2721	8519756.0
2009-04-09 10:40:00	AAPL	Stock	4.2729	4.2729	4.2596	4.26	6167000.0
2009-04-09 10:45:00	AAPL	Stock	4.2604	4.2679	4.2575	4.2679	6502636.0
2009-04-09 10:50:00	AAPL	Stock	4.2679	4.2711	4.2639	4.2707	4558512.0
2009-04-09 10:55:00	AAPL	Stock	4.2707	4.2739	4.2639	4.2661	4986436.0
2009-04-09 11:00:00	AAPL	Stock	4.2664	4.2714	4.2571	4.2675	7602252.0
2009-04-09 11:05:00	AAPL	Stock	4.2668	4.2675	4.2618	4.2643	2559200.0
2009-04-09 11:10:00	AAPL	Stock	4.2638	4.2732	4.2629	4.2661	4529644.0
2009-04-09 11:15:00	AAPL	Stock	4.2654	4.2739	4.2654	4.2696	3782380.0
2009-04-09 11:20:00	AAPL	Stock	4.2704	4.2718	4.2639	4.2643	3622640.0
2009-04-09 11:25:00	AAPL	Stock	4.2646	4.2654	4.2518	4.2554	6129424.0
2009-04-09 11:30:00	AAPL	Stock	4.2554	4.2668	4.2543	4.2625	4561452.0
2009-04-09 11:35:00	AAPL	Stock	4.2618	4.2625	4.2543	4.2568	3467604.0
2009-04-09 11:40:00	AAPL	Stock	4.2566	4.2579	4.25	4.2504	8045380.0
2009-04-09 11:45:00	AAPL	Stock	4.2511	4.2646	4.25	4.2614	5049212.0
2009-04-09 11:50:00	AAPL	Stock	4.2621	4.2621	4.2554	4.2561	2459884.0
2009-04-09 11:55:00	AAPL	Stock	4.2564	4.2661	4.255	4.265	4554312.0
2009-04-09 12:00:00	AAPL	Stock	4.2643	4.2661	4.2564	4.2564	4518528.0

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

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