PREVIEW / stock_30min / 2005-06-27

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-06-27.parquet
  size:    854 KB
  rows:    46,490
  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.3204	1.3204	28000.0
2005-06-27 07:30:00	AAPL	Stock	1.3204	1.3204	1.3125	1.3125	285040.0
2005-06-27 08:00:00	AAPL	Stock	1.3161	1.3321	1.3061	1.3104	4935784.0
2005-06-27 08:30:00	AAPL	Stock	1.3093	1.3211	1.3046	1.3168	3500448.0
2005-06-27 09:00:00	AAPL	Stock	1.3171	1.325	1.3154	1.3154	3417540.0
2005-06-27 09:30:00	AAPL	Stock	1.3157	1.3339	1.3143	1.3264	90801172.0
2005-06-27 10:00:00	AAPL	Stock	1.3261	1.3311	1.3184	1.3304	47059068.0
2005-06-27 10:30:00	AAPL	Stock	1.3304	1.3607	1.3275	1.3496	103937372.0
2005-06-27 11:00:00	AAPL	Stock	1.3496	1.3511	1.34	1.3446	49074396.0
2005-06-27 11:30:00	AAPL	Stock	1.3443	1.345	1.3311	1.3321	29659420.0
2005-06-27 12:00:00	AAPL	Stock	1.3321	1.3354	1.3271	1.33	33514208.0
2005-06-27 12:30:00	AAPL	Stock	1.33	1.3318	1.3204	1.3221	25608184.0
2005-06-27 13:00:00	AAPL	Stock	1.3214	1.325	1.3143	1.3196	38150336.0
2005-06-27 13:30:00	AAPL	Stock	1.3196	1.3204	1.31	1.3107	31215884.0
2005-06-27 14:00:00	AAPL	Stock	1.3107	1.3196	1.3104	1.3161	24836252.0
2005-06-27 14:30:00	AAPL	Stock	1.3164	1.3229	1.3157	1.3214	20217036.0
2005-06-27 15:00:00	AAPL	Stock	1.3211	1.325	1.3175	1.3214	27403740.0
2005-06-27 15:30:00	AAPL	Stock	1.3214	1.3304	1.3207	1.325	51367876.0
2005-06-27 16:00:00	AAPL	Stock	1.325	1.3318	1.3239	1.3318	3969728.0
2005-06-27 16:30:00	AAPL	Stock	1.33	1.33	1.3293	1.3293	33600.0
2005-06-27 17:00:00	AAPL	Stock	1.3293	1.3293	1.3249	1.325	111076.0
2005-06-27 17:30:00	AAPL	Stock	1.3296	1.3304	1.3286	1.3286	175840.0
2005-06-27 18:00:00	AAPL	Stock	1.3293	1.3304	1.3243	1.3243	171164.0
2005-06-27 07:30:00	MSFT	Stock	25.03	25.03	25.03	25.03	2200.0
2005-06-27 08:00:00	MSFT	Stock	25.03	25.08	25.03	25.08	36183.0
2005-06-27 08:30:00	MSFT	Stock	25.06	25.06	25.05	25.05	1170.0
2005-06-27 09:00:00	MSFT	Stock	25.05	25.07	25.04	25.07	49681.0
2005-06-27 09:30:00	MSFT	Stock	25.07	25.23	25.03	25.13	8032124.0
2005-06-27 10:00:00	MSFT	Stock	25.13	25.19	25.06	25.18	4654143.0
2005-06-27 10:30:00	MSFT	Stock	25.18	25.25	25.13	25.14	4979449.0
2005-06-27 11:00:00	MSFT	Stock	25.14	25.21	25.13	25.19	2992099.0
2005-06-27 11:30:00	MSFT	Stock	25.19	25.2	25.12	25.19	2912317.0
2005-06-27 12:00:00	MSFT	Stock	25.19	25.25	25.14	25.14	3166339.0
2005-06-27 12:30:00	MSFT	Stock	25.14	25.15	25.07	25.08	3111587.0
2005-06-27 13:00:00	MSFT	Stock	25.08	25.13	25.06	25.11	2640342.0
2005-06-27 13:30:00	MSFT	Stock	25.11	25.14	25.07	25.09	4812863.0
2005-06-27 14:00:00	MSFT	Stock	25.09	25.11	25.03	25.06	3646299.0
2005-06-27 14:30:00	MSFT	Stock	25.06	25.09	25.05	25.07	3216276.0
2005-06-27 15:00:00	MSFT	Stock	25.07	25.11	25.05	25.08	5758102.0
2005-06-27 15:30:00	MSFT	Stock	25.08	25.1	25.03	25.07	7774382.0
2005-06-27 16:00:00	MSFT	Stock	25.06	25.08	25.04	25.04	443320.0
2005-06-27 16:30:00	MSFT	Stock	25.05	25.07	25.05	25.07	4693.0
2005-06-27 17:00:00	MSFT	Stock	25.05	25.05	25.049	25.05	136737.0
2005-06-27 17:30:00	MSFT	Stock	25.127	25.127	25.07	25.07	8800.0
2005-06-27 18:00:00	MSFT	Stock	25.05	25.12	25.04	25.12	64698.0
2005-06-27 08:30:00	NVDA	Stock	0.2271	0.2271	0.2271	0.2271	156000.0
2005-06-27 09:00:00	NVDA	Stock	0.2249	0.2257	0.2241	0.2241	948000.0
2005-06-27 09:30:00	NVDA	Stock	0.2243	0.2262	0.2237	0.2238	31229760.0
2005-06-27 10:00:00	NVDA	Stock	0.2238	0.2242	0.2226	0.2231	25957320.0
2005-06-27 10:30:00	NVDA	Stock	0.2232	0.2255	0.2231	0.2244	33313800.0

> showing 50 of 46,490 rows — these rows as CSV

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