PREVIEW / stock_5min / 2009-04-14

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-14.parquet
  size:    4.5 MB
  rows:    312,501
  symbols: 3,328

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-14 04:10:00	AAPL	Stock	4.2696	4.2696	4.2696	4.2696	14000.0
2009-04-14 05:55:00	AAPL	Stock	4.3011	4.3011	4.3011	4.3011	2800.0
2009-04-14 06:20:00	AAPL	Stock	4.3129	4.3129	4.3129	4.3129	2800.0
2009-04-14 06:30:00	AAPL	Stock	4.2896	4.2896	4.2896	4.2896	2800.0
2009-04-14 07:25:00	AAPL	Stock	4.2936	4.2936	4.2929	4.2929	11200.0
2009-04-14 07:45:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	8400.0
2009-04-14 08:00:00	AAPL	Stock	4.2929	4.2929	4.2857	4.2918	50120.0
2009-04-14 08:05:00	AAPL	Stock	4.2961	4.2964	4.2957	4.2961	42700.0
2009-04-14 08:10:00	AAPL	Stock	4.3025	4.3054	4.3025	4.3025	33600.0
2009-04-14 08:15:00	AAPL	Stock	4.3011	4.3143	4.3011	4.3143	115556.0
2009-04-14 08:20:00	AAPL	Stock	4.3107	4.3143	4.3032	4.3071	280616.0
2009-04-14 08:25:00	AAPL	Stock	4.3071	4.3107	4.3071	4.3107	32956.0
2009-04-14 08:30:00	AAPL	Stock	4.3061	4.3061	4.2861	4.2861	216160.0
2009-04-14 08:35:00	AAPL	Stock	4.2875	4.2875	4.28	4.28	100520.0
2009-04-14 08:40:00	AAPL	Stock	4.2804	4.2821	4.2768	4.2768	105812.0
2009-04-14 08:45:00	AAPL	Stock	4.27	4.27	4.2696	4.2696	14000.0
2009-04-14 08:50:00	AAPL	Stock	4.2711	4.2711	4.2614	4.2614	192668.0
2009-04-14 08:55:00	AAPL	Stock	4.2614	4.2704	4.2593	4.2661	91000.0
2009-04-14 09:00:00	AAPL	Stock	4.2657	4.2679	4.2607	4.2661	78400.0
2009-04-14 09:05:00	AAPL	Stock	4.2661	4.2693	4.2661	4.2693	14000.0
2009-04-14 09:10:00	AAPL	Stock	4.2693	4.2693	4.2586	4.2589	125160.0
2009-04-14 09:15:00	AAPL	Stock	4.2607	4.2643	4.2607	4.2643	72520.0
2009-04-14 09:20:00	AAPL	Stock	4.2679	4.2732	4.2621	4.2643	94640.0
2009-04-14 09:25:00	AAPL	Stock	4.2675	4.2704	4.2636	4.2704	70000.0
2009-04-14 09:30:00	AAPL	Stock	4.2704	4.2732	4.25	4.2568	11038916.0
2009-04-14 09:35:00	AAPL	Stock	4.2575	4.2839	4.2536	4.2832	14204316.0
2009-04-14 09:40:00	AAPL	Stock	4.2768	4.2918	4.2739	4.28	10145716.0
2009-04-14 09:45:00	AAPL	Stock	4.2807	4.2807	4.2643	4.2746	9190412.0
2009-04-14 09:50:00	AAPL	Stock	4.2754	4.2768	4.2643	4.2671	8469748.0
2009-04-14 09:55:00	AAPL	Stock	4.2673	4.28	4.2625	4.2718	7365176.0
2009-04-14 10:00:00	AAPL	Stock	4.2714	4.2718	4.255	4.2564	10025624.0
2009-04-14 10:05:00	AAPL	Stock	4.2571	4.2571	4.2321	4.2367	13861652.0
2009-04-14 10:10:00	AAPL	Stock	4.2371	4.2446	4.2289	4.2421	9172968.0
2009-04-14 10:15:00	AAPL	Stock	4.2425	4.2571	4.2367	4.2475	6546372.0
2009-04-14 10:20:00	AAPL	Stock	4.2468	4.2571	4.2457	4.2546	5210016.0
2009-04-14 10:25:00	AAPL	Stock	4.2546	4.2575	4.2521	4.2571	3830120.0
2009-04-14 10:30:00	AAPL	Stock	4.2564	4.2675	4.2543	4.2621	8169868.0
2009-04-14 10:35:00	AAPL	Stock	4.2629	4.2643	4.2532	4.2554	4775876.0
2009-04-14 10:40:00	AAPL	Stock	4.2557	4.2604	4.2457	4.2536	5812100.0
2009-04-14 10:45:00	AAPL	Stock	4.2539	4.255	4.2421	4.2471	3821944.0
2009-04-14 10:50:00	AAPL	Stock	4.2461	4.2475	4.2364	4.2421	3333232.0
2009-04-14 10:55:00	AAPL	Stock	4.2429	4.2457	4.2375	4.2439	2533384.0
2009-04-14 11:00:00	AAPL	Stock	4.2436	4.2525	4.2414	4.2493	3586604.0
2009-04-14 11:05:00	AAPL	Stock	4.2489	4.25	4.2382	4.2486	4155648.0
2009-04-14 11:10:00	AAPL	Stock	4.2489	4.25	4.2418	4.2486	2279928.0
2009-04-14 11:15:00	AAPL	Stock	4.2486	4.2561	4.2439	4.2445	4349968.0
2009-04-14 11:20:00	AAPL	Stock	4.245	4.245	4.2346	4.24	4626524.0
2009-04-14 11:25:00	AAPL	Stock	4.24	4.2421	4.2232	4.2254	5934964.0
2009-04-14 11:30:00	AAPL	Stock	4.2268	4.2368	4.2243	4.2364	5447540.0
2009-04-14 11:35:00	AAPL	Stock	4.2368	4.2393	4.2332	4.2386	2930816.0

> showing 50 of 312,501 rows — these rows as CSV

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