PREVIEW / stock_5min / 2011-01-14

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-14.parquet
  size:    4.9 MB
  rows:    335,368
  symbols: 3,524

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
2011-01-14 05:20:00	AAPL	Stock	12.3929	12.3929	12.3875	12.3925	8400.0
2011-01-14 05:25:00	AAPL	Stock	12.3929	12.3929	12.3929	12.3929	12600.0
2011-01-14 05:40:00	AAPL	Stock	12.3929	12.3929	12.3929	12.3929	26712.0
2011-01-14 06:00:00	AAPL	Stock	12.3964	12.3964	12.3964	12.3964	5600.0
2011-01-14 06:10:00	AAPL	Stock	12.3932	12.3932	12.3929	12.3929	33600.0
2011-01-14 07:00:00	AAPL	Stock	12.3854	12.3854	12.3854	12.3854	64400.0
2011-01-14 07:05:00	AAPL	Stock	12.3711	12.3711	12.345	12.345	55720.0
2011-01-14 07:10:00	AAPL	Stock	12.3529	12.3529	12.3529	12.3529	2800.0
2011-01-14 07:15:00	AAPL	Stock	12.3482	12.3482	12.34	12.3464	25844.0
2011-01-14 07:20:00	AAPL	Stock	12.3482	12.3496	12.3396	12.3496	36400.0
2011-01-14 07:25:00	AAPL	Stock	12.3496	12.3639	12.3489	12.3571	63700.0
2011-01-14 07:30:00	AAPL	Stock	12.3568	12.3568	12.3439	12.3446	42588.0
2011-01-14 07:35:00	AAPL	Stock	12.3375	12.3443	12.3375	12.3443	14000.0
2011-01-14 07:40:00	AAPL	Stock	12.3446	12.3496	12.3446	12.3464	33600.0
2011-01-14 07:45:00	AAPL	Stock	12.3525	12.3525	12.3486	12.3486	16800.0
2011-01-14 07:50:00	AAPL	Stock	12.3464	12.3464	12.3429	12.3429	28504.0
2011-01-14 07:55:00	AAPL	Stock	12.3375	12.3411	12.3218	12.3357	149128.0
2011-01-14 08:00:00	AAPL	Stock	12.3393	12.3421	12.3304	12.3339	167020.0
2011-01-14 08:05:00	AAPL	Stock	12.3286	12.3382	12.3232	12.3382	190400.0
2011-01-14 08:10:00	AAPL	Stock	12.3339	12.3339	12.3339	12.3339	8400.0
2011-01-14 08:15:00	AAPL	Stock	12.3321	12.3339	12.3268	12.3286	50400.0
2011-01-14 08:20:00	AAPL	Stock	12.3286	12.3286	12.3154	12.3264	190260.0
2011-01-14 08:25:00	AAPL	Stock	12.3232	12.3304	12.3182	12.3286	143556.0
2011-01-14 08:30:00	AAPL	Stock	12.3214	12.3286	12.3154	12.3214	98028.0
2011-01-14 08:35:00	AAPL	Stock	12.3232	12.3257	12.3168	12.3257	18116.0
2011-01-14 08:40:00	AAPL	Stock	12.325	12.3364	12.3214	12.3364	116200.0
2011-01-14 08:45:00	AAPL	Stock	12.3304	12.3321	12.3268	12.3286	67200.0
2011-01-14 08:50:00	AAPL	Stock	12.3271	12.3286	12.3214	12.3286	301672.0
2011-01-14 08:55:00	AAPL	Stock	12.3268	12.3307	12.325	12.3289	89460.0
2011-01-14 09:00:00	AAPL	Stock	12.3268	12.3457	12.325	12.3457	266588.0
2011-01-14 09:05:00	AAPL	Stock	12.3429	12.3429	12.3339	12.3418	71568.0
2011-01-14 09:10:00	AAPL	Stock	12.3411	12.3418	12.3411	12.3418	126000.0
2011-01-14 09:15:00	AAPL	Stock	12.3429	12.3429	12.3429	12.3429	2800.0
2011-01-14 09:20:00	AAPL	Stock	12.3471	12.3536	12.3471	12.35	176512.0
2011-01-14 09:25:00	AAPL	Stock	12.3446	12.3589	12.3414	12.3532	668780.0
2011-01-14 09:30:00	AAPL	Stock	12.3532	12.3596	12.3121	12.3206	14700840.0
2011-01-14 09:35:00	AAPL	Stock	12.3207	12.3507	12.3175	12.3271	7537124.0
2011-01-14 09:40:00	AAPL	Stock	12.3282	12.3282	12.3129	12.3129	8891064.0
2011-01-14 09:45:00	AAPL	Stock	12.315	12.3221	12.3129	12.3186	5004748.0
2011-01-14 09:50:00	AAPL	Stock	12.3182	12.3225	12.3071	12.31	7608916.0
2011-01-14 09:55:00	AAPL	Stock	12.3111	12.325	12.3014	12.3211	7681408.0
2011-01-14 10:00:00	AAPL	Stock	12.3207	12.3382	12.3207	12.3286	7752948.0
2011-01-14 10:05:00	AAPL	Stock	12.3286	12.3354	12.3207	12.3339	5043080.0
2011-01-14 10:10:00	AAPL	Stock	12.3329	12.3582	12.3296	12.355	6857956.0
2011-01-14 10:15:00	AAPL	Stock	12.3561	12.3571	12.3393	12.3443	5652416.0
2011-01-14 10:20:00	AAPL	Stock	12.3457	12.3525	12.345	12.3457	3751328.0
2011-01-14 10:25:00	AAPL	Stock	12.3454	12.3589	12.34	12.35	8605996.0
2011-01-14 10:30:00	AAPL	Stock	12.35	12.3725	12.3393	12.3682	9282420.0
2011-01-14 10:35:00	AAPL	Stock	12.3664	12.3682	12.3611	12.3661	3077368.0
2011-01-14 10:40:00	AAPL	Stock	12.3666	12.3775	12.3643	12.3757	4319868.0

> showing 50 of 335,368 rows — these rows as CSV

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