PREVIEW / stock_5min / 2005-06-27

all stock 5-min files

  file:    by_date/stock_5min/2005/2005-06-27.parquet
  size:    2.7 MB
  rows:    201,996
  symbols: 2,007

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
2005-06-27 07:00:00	AAPL	Stock	1.3211	1.3211	1.3211	1.3211	14000.0
2005-06-27 07:05:00	AAPL	Stock	1.3204	1.3204	1.3204	1.3204	14000.0
2005-06-27 07:50:00	AAPL	Stock	1.3204	1.3204	1.3204	1.3204	19600.0
2005-06-27 07:55:00	AAPL	Stock	1.3125	1.3125	1.3125	1.3125	265440.0
2005-06-27 08:00:00	AAPL	Stock	1.3161	1.3321	1.3107	1.3143	2023252.0
2005-06-27 08:05:00	AAPL	Stock	1.3161	1.3179	1.3154	1.3161	818636.0
2005-06-27 08:10:00	AAPL	Stock	1.3143	1.3161	1.3061	1.3114	539896.0
2005-06-27 08:15:00	AAPL	Stock	1.3114	1.3139	1.3089	1.3125	778400.0
2005-06-27 08:20:00	AAPL	Stock	1.3125	1.3125	1.3071	1.3104	553840.0
2005-06-27 08:25:00	AAPL	Stock	1.3096	1.3107	1.3089	1.3104	221760.0
2005-06-27 08:30:00	AAPL	Stock	1.3093	1.3093	1.3046	1.3079	470400.0
2005-06-27 08:35:00	AAPL	Stock	1.3079	1.31	1.3079	1.31	218400.0
2005-06-27 08:40:00	AAPL	Stock	1.31	1.3104	1.3054	1.3079	568288.0
2005-06-27 08:45:00	AAPL	Stock	1.3071	1.3125	1.3061	1.3125	1305892.0
2005-06-27 08:50:00	AAPL	Stock	1.3125	1.3211	1.3107	1.3179	741468.0
2005-06-27 08:55:00	AAPL	Stock	1.3182	1.3182	1.3168	1.3168	196000.0
2005-06-27 09:00:00	AAPL	Stock	1.3171	1.3196	1.3171	1.3179	632548.0
2005-06-27 09:05:00	AAPL	Stock	1.3179	1.3182	1.3168	1.3168	541100.0
2005-06-27 09:10:00	AAPL	Stock	1.3175	1.3179	1.3168	1.3168	570752.0
2005-06-27 09:15:00	AAPL	Stock	1.3168	1.3218	1.3168	1.3214	484400.0
2005-06-27 09:20:00	AAPL	Stock	1.3211	1.3214	1.3179	1.3179	144200.0
2005-06-27 09:25:00	AAPL	Stock	1.3204	1.325	1.3154	1.3154	1044540.0
2005-06-27 09:30:00	AAPL	Stock	1.3157	1.3261	1.3143	1.3243	29175524.0
2005-06-27 09:35:00	AAPL	Stock	1.3243	1.3293	1.32	1.3279	14271376.0
2005-06-27 09:40:00	AAPL	Stock	1.3279	1.3311	1.3254	1.3275	15088248.0
2005-06-27 09:45:00	AAPL	Stock	1.3275	1.3339	1.325	1.3304	13232296.0
2005-06-27 09:50:00	AAPL	Stock	1.3307	1.3311	1.3261	1.3261	9106720.0
2005-06-27 09:55:00	AAPL	Stock	1.3264	1.3268	1.3229	1.3264	9927008.0
2005-06-27 10:00:00	AAPL	Stock	1.3261	1.3307	1.3218	1.3293	7501228.0
2005-06-27 10:05:00	AAPL	Stock	1.3289	1.3289	1.3218	1.3257	5702844.0
2005-06-27 10:10:00	AAPL	Stock	1.3257	1.3271	1.3196	1.32	7847896.0
2005-06-27 10:15:00	AAPL	Stock	1.32	1.3232	1.3184	1.3232	10569132.0
2005-06-27 10:20:00	AAPL	Stock	1.3232	1.3232	1.3189	1.3218	4994696.0
2005-06-27 10:25:00	AAPL	Stock	1.3218	1.3311	1.3218	1.3304	10443272.0
2005-06-27 10:30:00	AAPL	Stock	1.3304	1.3332	1.3275	1.3311	14309484.0
2005-06-27 10:35:00	AAPL	Stock	1.3311	1.3371	1.3311	1.3364	11761260.0
2005-06-27 10:40:00	AAPL	Stock	1.3361	1.3446	1.3343	1.3443	12928664.0
2005-06-27 10:45:00	AAPL	Stock	1.3439	1.3546	1.3411	1.3529	20996584.0
2005-06-27 10:50:00	AAPL	Stock	1.3525	1.3607	1.3486	1.3532	30104900.0
2005-06-27 10:55:00	AAPL	Stock	1.3529	1.355	1.3482	1.3496	13836480.0
2005-06-27 11:00:00	AAPL	Stock	1.3496	1.3511	1.345	1.3507	10732120.0
2005-06-27 11:05:00	AAPL	Stock	1.3507	1.3511	1.345	1.3464	6700988.0
2005-06-27 11:10:00	AAPL	Stock	1.3468	1.3482	1.34	1.3421	9310868.0
2005-06-27 11:15:00	AAPL	Stock	1.3418	1.3468	1.3404	1.3464	13804420.0
2005-06-27 11:20:00	AAPL	Stock	1.3461	1.3475	1.3439	1.3457	5527872.0
2005-06-27 11:25:00	AAPL	Stock	1.3454	1.3471	1.3432	1.3446	2998128.0
2005-06-27 11:30:00	AAPL	Stock	1.3443	1.345	1.3393	1.34	4937352.0
2005-06-27 11:35:00	AAPL	Stock	1.34	1.3429	1.3368	1.3371	5049744.0
2005-06-27 11:40:00	AAPL	Stock	1.3375	1.34	1.3364	1.3389	4572848.0
2005-06-27 11:45:00	AAPL	Stock	1.3393	1.3425	1.3389	1.3414	4524212.0

> showing 50 of 201,996 rows — these rows as CSV

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