PREVIEW / stock_5min / 2009-04-17

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-17.parquet
  size:    4.5 MB
  rows:    308,912
  symbols: 3,330

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-17 07:00:00	AAPL	Stock	4.3182	4.3182	4.3182	4.3182	16800.0
2009-04-17 07:25:00	AAPL	Stock	4.3193	4.3193	4.3193	4.3193	2800.0
2009-04-17 07:55:00	AAPL	Stock	4.3375	4.3375	4.3375	4.3375	11480.0
2009-04-17 08:00:00	AAPL	Stock	4.3339	4.35	4.3339	4.3496	101920.0
2009-04-17 08:05:00	AAPL	Stock	4.3396	4.3511	4.3379	4.3393	136864.0
2009-04-17 08:10:00	AAPL	Stock	4.3393	4.3464	4.3254	4.3332	87192.0
2009-04-17 08:15:00	AAPL	Stock	4.3332	4.3332	4.325	4.3268	55692.0
2009-04-17 08:20:00	AAPL	Stock	4.325	4.325	4.3214	4.3214	25200.0
2009-04-17 08:25:00	AAPL	Stock	4.32	4.3214	4.3196	4.3196	50400.0
2009-04-17 08:30:00	AAPL	Stock	4.3182	4.32	4.3179	4.32	144480.0
2009-04-17 08:35:00	AAPL	Stock	4.3196	4.3214	4.3196	4.3214	17640.0
2009-04-17 08:40:00	AAPL	Stock	4.3236	4.325	4.3214	4.3243	47600.0
2009-04-17 08:45:00	AAPL	Stock	4.3239	4.3239	4.3179	4.3179	15008.0
2009-04-17 08:50:00	AAPL	Stock	4.3179	4.3179	4.3107	4.3107	68600.0
2009-04-17 08:55:00	AAPL	Stock	4.3104	4.3104	4.2968	4.3025	165620.0
2009-04-17 09:00:00	AAPL	Stock	4.3025	4.3025	4.2975	4.2982	101864.0
2009-04-17 09:05:00	AAPL	Stock	4.3	4.3	4.2986	4.3	49952.0
2009-04-17 09:10:00	AAPL	Stock	4.3007	4.3007	4.2904	4.2929	193900.0
2009-04-17 09:15:00	AAPL	Stock	4.2929	4.2929	4.2875	4.2893	190680.0
2009-04-17 09:20:00	AAPL	Stock	4.2904	4.3071	4.2904	4.2964	270480.0
2009-04-17 09:25:00	AAPL	Stock	4.2975	4.3179	4.2964	4.3179	526960.0
2009-04-17 09:30:00	AAPL	Stock	4.3161	4.3314	4.2946	4.3139	12516840.0
2009-04-17 09:35:00	AAPL	Stock	4.3143	4.3268	4.2986	4.3171	11375392.0
2009-04-17 09:40:00	AAPL	Stock	4.3171	4.3357	4.3104	4.3236	13523944.0
2009-04-17 09:45:00	AAPL	Stock	4.3246	4.3411	4.3093	4.3389	11932788.0
2009-04-17 09:50:00	AAPL	Stock	4.3393	4.3407	4.325	4.3371	6769140.0
2009-04-17 09:55:00	AAPL	Stock	4.3371	4.3482	4.3296	4.3476	10984120.0
2009-04-17 10:00:00	AAPL	Stock	4.3479	4.3661	4.3439	4.3661	8396192.0
2009-04-17 10:05:00	AAPL	Stock	4.3661	4.3707	4.3536	4.3679	9230844.0
2009-04-17 10:10:00	AAPL	Stock	4.3682	4.3689	4.3536	4.36	7277984.0
2009-04-17 10:15:00	AAPL	Stock	4.3607	4.3671	4.3482	4.3587	5844860.0
2009-04-17 10:20:00	AAPL	Stock	4.3586	4.3589	4.3521	4.3568	4254656.0
2009-04-17 10:25:00	AAPL	Stock	4.3561	4.3682	4.355	4.36	4342268.0
2009-04-17 10:30:00	AAPL	Stock	4.36	4.36	4.345	4.3514	7008344.0
2009-04-17 10:35:00	AAPL	Stock	4.3514	4.3518	4.3404	4.3439	4761008.0
2009-04-17 10:40:00	AAPL	Stock	4.3432	4.3514	4.3418	4.348	3857868.0
2009-04-17 10:45:00	AAPL	Stock	4.3482	4.3625	4.3468	4.3621	4821292.0
2009-04-17 10:50:00	AAPL	Stock	4.3618	4.365	4.3607	4.3621	3607520.0
2009-04-17 10:55:00	AAPL	Stock	4.3621	4.3639	4.3529	4.3539	4500888.0
2009-04-17 11:00:00	AAPL	Stock	4.3546	4.3568	4.3464	4.3489	3103128.0
2009-04-17 11:05:00	AAPL	Stock	4.3486	4.3636	4.3471	4.3632	2470356.0
2009-04-17 11:10:00	AAPL	Stock	4.3636	4.375	4.3612	4.3721	5674592.0
2009-04-17 11:15:00	AAPL	Stock	4.3736	4.3809	4.3704	4.371	5184424.0
2009-04-17 11:20:00	AAPL	Stock	4.3711	4.3771	4.3643	4.3771	3880212.0
2009-04-17 11:25:00	AAPL	Stock	4.3771	4.3839	4.3746	4.3804	4497136.0
2009-04-17 11:30:00	AAPL	Stock	4.3807	4.3886	4.3754	4.385	3499384.0
2009-04-17 11:35:00	AAPL	Stock	4.3857	4.3911	4.3821	4.3821	5336968.0
2009-04-17 11:40:00	AAPL	Stock	4.3821	4.3857	4.3775	4.3793	3602032.0
2009-04-17 11:45:00	AAPL	Stock	4.3793	4.3814	4.375	4.3786	2465624.0
2009-04-17 11:50:00	AAPL	Stock	4.3779	4.3821	4.3775	4.3807	4044656.0

> showing 50 of 308,912 rows — these rows as CSV

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