PREVIEW / stock_5min / 2012-07-23

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-23.parquet
  size:    4.7 MB
  rows:    315,249
  symbols: 3,476

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
2012-07-23 04:00:00	AAPL	Stock	21.6071	21.6071	21.4282	21.4282	5600.0
2012-07-23 04:05:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	11200.0
2012-07-23 04:10:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	2800.0
2012-07-23 04:15:00	AAPL	Stock	21.3968	21.3968	21.3968	21.3968	8400.0
2012-07-23 04:20:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	8400.0
2012-07-23 04:25:00	AAPL	Stock	21.395	21.3964	21.395	21.3964	8960.0
2012-07-23 04:30:00	AAPL	Stock	21.3964	21.3964	21.3946	21.3946	8400.0
2012-07-23 04:40:00	AAPL	Stock	21.3932	21.3932	21.3932	21.3932	2800.0
2012-07-23 04:45:00	AAPL	Stock	21.3607	21.3607	21.3607	21.3607	5600.0
2012-07-23 04:50:00	AAPL	Stock	21.3607	21.3607	21.3607	21.3607	18200.0
2012-07-23 04:55:00	AAPL	Stock	21.3429	21.3429	21.3429	21.3429	12908.0
2012-07-23 05:30:00	AAPL	Stock	21.3661	21.3818	21.3661	21.3754	8400.0
2012-07-23 05:45:00	AAPL	Stock	21.3625	21.3625	21.3625	21.3625	2800.0
2012-07-23 06:15:00	AAPL	Stock	21.375	21.3821	21.375	21.3821	11200.0
2012-07-23 06:20:00	AAPL	Stock	21.375	21.375	21.375	21.375	5600.0
2012-07-23 06:30:00	AAPL	Stock	21.375	21.375	21.375	21.375	2800.0
2012-07-23 06:45:00	AAPL	Stock	21.3893	21.3929	21.3893	21.3929	27636.0
2012-07-23 06:55:00	AAPL	Stock	21.3929	21.3929	21.3929	21.3929	8512.0
2012-07-23 07:00:00	AAPL	Stock	21.3929	21.4286	21.3807	21.4196	92400.0
2012-07-23 07:05:00	AAPL	Stock	21.4193	21.4196	21.4039	21.4039	22260.0
2012-07-23 07:10:00	AAPL	Stock	21.4043	21.4168	21.3929	21.3964	45556.0
2012-07-23 07:15:00	AAPL	Stock	21.3929	21.3929	21.3711	21.3711	14000.0
2012-07-23 07:20:00	AAPL	Stock	21.375	21.375	21.3732	21.3732	19852.0
2012-07-23 07:25:00	AAPL	Stock	21.3714	21.3714	21.3214	21.3546	61460.0
2012-07-23 07:30:00	AAPL	Stock	21.3311	21.3521	21.3111	21.3521	62580.0
2012-07-23 07:35:00	AAPL	Stock	21.3146	21.3482	21.3089	21.3318	40544.0
2012-07-23 07:40:00	AAPL	Stock	21.3321	21.3446	21.3321	21.3446	18284.0
2012-07-23 07:45:00	AAPL	Stock	21.3446	21.3475	21.3321	21.3393	44744.0
2012-07-23 07:50:00	AAPL	Stock	21.3371	21.3375	21.3218	21.3218	35588.0
2012-07-23 07:55:00	AAPL	Stock	21.3214	21.3214	21.3214	21.3214	17220.0
2012-07-23 08:00:00	AAPL	Stock	21.3214	21.395	21.2804	21.2857	652708.0
2012-07-23 08:05:00	AAPL	Stock	21.2804	21.2804	21.1543	21.1714	965496.0
2012-07-23 08:10:00	AAPL	Stock	21.1696	21.2225	21.1611	21.2225	410396.0
2012-07-23 08:15:00	AAPL	Stock	21.225	21.25	21.2	21.2143	563024.0
2012-07-23 08:20:00	AAPL	Stock	21.22	21.2775	21.2143	21.2643	173852.0
2012-07-23 08:25:00	AAPL	Stock	21.2557	21.2611	21.2436	21.2607	166124.0
2012-07-23 08:30:00	AAPL	Stock	21.2507	21.2821	21.25	21.25	354256.0
2012-07-23 08:35:00	AAPL	Stock	21.25	21.2679	21.225	21.2393	249536.0
2012-07-23 08:40:00	AAPL	Stock	21.2439	21.2554	21.2304	21.2357	262640.0
2012-07-23 08:45:00	AAPL	Stock	21.2321	21.2368	21.2143	21.2286	223608.0
2012-07-23 08:50:00	AAPL	Stock	21.2214	21.2457	21.2214	21.2457	277732.0
2012-07-23 08:55:00	AAPL	Stock	21.2425	21.2618	21.2375	21.2518	128380.0
2012-07-23 09:00:00	AAPL	Stock	21.25	21.2607	21.25	21.25	116396.0
2012-07-23 09:05:00	AAPL	Stock	21.2464	21.25	21.2232	21.2232	207816.0
2012-07-23 09:10:00	AAPL	Stock	21.2279	21.2282	21.2143	21.2164	314496.0
2012-07-23 09:15:00	AAPL	Stock	21.2168	21.2225	21.2071	21.2204	518504.0
2012-07-23 09:20:00	AAPL	Stock	21.2175	21.2286	21.215	21.2286	152936.0
2012-07-23 09:25:00	AAPL	Stock	21.2311	21.2679	21.2161	21.25	626696.0
2012-07-23 09:30:00	AAPL	Stock	21.2286	21.2604	21.115	21.1439	25269832.0
2012-07-23 09:35:00	AAPL	Stock	21.145	21.1582	21.0871	21.0896	15888684.0

> showing 50 of 315,249 rows — these rows as CSV

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