PREVIEW / stock_5min / 2007-01-18

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-01-18.parquet
  size:    3.4 MB
  rows:    246,197
  symbols: 2,490

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
2007-01-18 04:00:00	AAPL	Stock	3.3604	3.3604	3.3571	3.3571	148400.0
2007-01-18 04:05:00	AAPL	Stock	3.3504	3.3582	3.35	3.3582	134400.0
2007-01-18 04:10:00	AAPL	Stock	3.3596	3.3596	3.3596	3.3596	2800.0
2007-01-18 04:15:00	AAPL	Stock	3.3571	3.3571	3.3471	3.3471	72800.0
2007-01-18 04:25:00	AAPL	Stock	3.3518	3.3518	3.3518	3.3518	5600.0
2007-01-18 04:35:00	AAPL	Stock	3.3511	3.3511	3.3511	3.3511	14000.0
2007-01-18 04:40:00	AAPL	Stock	3.3525	3.3564	3.3518	3.3564	159600.0
2007-01-18 04:45:00	AAPL	Stock	3.3536	3.3536	3.3514	3.3536	89600.0
2007-01-18 04:50:00	AAPL	Stock	3.3536	3.3536	3.3536	3.3536	72800.0
2007-01-18 05:00:00	AAPL	Stock	3.3507	3.3507	3.3507	3.3507	19600.0
2007-01-18 05:05:00	AAPL	Stock	3.3536	3.3536	3.3507	3.3529	30800.0
2007-01-18 05:10:00	AAPL	Stock	3.3486	3.3493	3.3486	3.3486	56000.0
2007-01-18 05:15:00	AAPL	Stock	3.3493	3.3493	3.3479	3.3479	72800.0
2007-01-18 05:20:00	AAPL	Stock	3.3479	3.3479	3.3468	3.3468	23380.0
2007-01-18 05:25:00	AAPL	Stock	3.3471	3.3471	3.3471	3.3471	2800.0
2007-01-18 05:35:00	AAPL	Stock	3.3468	3.3468	3.3457	3.3457	42000.0
2007-01-18 05:55:00	AAPL	Stock	3.3429	3.3429	3.3429	3.3429	8400.0
2007-01-18 06:00:00	AAPL	Stock	3.3432	3.3432	3.3432	3.3432	2800.0
2007-01-18 06:15:00	AAPL	Stock	3.3421	3.3421	3.3368	3.3368	106400.0
2007-01-18 06:20:00	AAPL	Stock	3.3357	3.3357	3.325	3.325	108920.0
2007-01-18 06:25:00	AAPL	Stock	3.3286	3.3286	3.3286	3.3286	28000.0
2007-01-18 06:30:00	AAPL	Stock	3.3286	3.3286	3.3286	3.3286	8400.0
2007-01-18 06:35:00	AAPL	Stock	3.3286	3.3286	3.3232	3.3268	50400.0
2007-01-18 06:40:00	AAPL	Stock	3.3179	3.3179	3.3179	3.3179	2800.0
2007-01-18 06:45:00	AAPL	Stock	3.3161	3.3161	3.3161	3.3161	2800.0
2007-01-18 06:50:00	AAPL	Stock	3.3196	3.3261	3.3196	3.3261	39200.0
2007-01-18 06:55:00	AAPL	Stock	3.3268	3.3339	3.3268	3.3339	190400.0
2007-01-18 07:00:00	AAPL	Stock	3.3354	3.3357	3.3286	3.3357	453964.0
2007-01-18 07:05:00	AAPL	Stock	3.3414	3.3518	3.3393	3.3464	412580.0
2007-01-18 07:10:00	AAPL	Stock	3.3436	3.3518	3.3436	3.3468	254352.0
2007-01-18 07:15:00	AAPL	Stock	3.3439	3.3489	3.3396	3.3489	168168.0
2007-01-18 07:20:00	AAPL	Stock	3.3482	3.3496	3.3443	3.3443	19600.0
2007-01-18 07:25:00	AAPL	Stock	3.3464	3.3518	3.3461	3.3518	842800.0
2007-01-18 07:30:00	AAPL	Stock	3.3518	3.3543	3.3464	3.3536	1232588.0
2007-01-18 07:35:00	AAPL	Stock	3.3536	3.3536	3.3429	3.3429	814072.0
2007-01-18 07:40:00	AAPL	Stock	3.3429	3.3429	3.3339	3.34	589344.0
2007-01-18 07:45:00	AAPL	Stock	3.3411	3.3461	3.3304	3.3304	1045828.0
2007-01-18 07:50:00	AAPL	Stock	3.3304	3.3393	3.3304	3.3357	905632.0
2007-01-18 07:55:00	AAPL	Stock	3.3357	3.3357	3.3232	3.325	1224720.0
2007-01-18 08:00:00	AAPL	Stock	3.3286	3.3357	3.3161	3.3168	8877680.0
2007-01-18 08:05:00	AAPL	Stock	3.3179	3.3214	3.305	3.3139	8038268.0
2007-01-18 08:10:00	AAPL	Stock	3.3139	3.3164	3.3071	3.3143	4962608.0
2007-01-18 08:15:00	AAPL	Stock	3.3139	3.3389	3.3139	3.3389	6075524.0
2007-01-18 08:20:00	AAPL	Stock	3.3389	3.3393	3.3268	3.3282	6164340.0
2007-01-18 08:25:00	AAPL	Stock	3.3275	3.3386	3.3239	3.3282	3014648.0
2007-01-18 08:30:00	AAPL	Stock	3.3279	3.3304	3.3193	3.32	4492068.0
2007-01-18 08:35:00	AAPL	Stock	3.3207	3.3304	3.3207	3.3218	2646560.0
2007-01-18 08:40:00	AAPL	Stock	3.3218	3.3275	3.3214	3.3275	1625960.0
2007-01-18 08:45:00	AAPL	Stock	3.3279	3.3304	3.3196	3.3218	3243492.0
2007-01-18 08:50:00	AAPL	Stock	3.3218	3.3286	3.3204	3.3257	2080148.0

> showing 50 of 246,197 rows — these rows as CSV

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