PREVIEW / stock_1hour / 2006-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-26.parquet
  size:    619 KB
  rows:    29,498
  symbols: 2,320

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
2006-07-26 05:00:00	AAPL	Stock	2.2118	2.2118	2.2118	2.2118	8400.0
2006-07-26 08:00:00	AAPL	Stock	2.2164	2.2164	2.2014	2.2125	534716.0
2006-07-26 09:00:00	AAPL	Stock	2.2121	2.2264	2.2029	2.225	84711844.0
2006-07-26 10:00:00	AAPL	Stock	2.2254	2.2339	2.2129	2.2179	120313424.0
2006-07-26 11:00:00	AAPL	Stock	2.2179	2.2514	2.2139	2.2475	122604524.0
2006-07-26 12:00:00	AAPL	Stock	2.2475	2.2779	2.2439	2.2621	129230220.0
2006-07-26 13:00:00	AAPL	Stock	2.2621	2.2925	2.2621	2.2893	112046788.0
2006-07-26 14:00:00	AAPL	Stock	2.29	2.3054	2.2854	2.3007	140100996.0
2006-07-26 15:00:00	AAPL	Stock	2.3011	2.3086	2.2793	2.2814	172998112.0
2006-07-26 16:00:00	AAPL	Stock	2.2814	2.2857	2.2811	2.2857	785036.0
2006-07-26 17:00:00	AAPL	Stock	2.2811	2.2857	2.2804	2.2811	5117420.0
2006-07-26 18:00:00	AAPL	Stock	2.2811	2.2811	2.2786	2.2807	200480.0
2006-07-26 07:00:00	MSFT	Stock	24.19	24.19	24.18	24.18	300.0
2006-07-26 08:00:00	MSFT	Stock	24.22	24.22	24.04	24.15	25735.0
2006-07-26 09:00:00	MSFT	Stock	24.18	24.28	24.11	24.25	4413651.0
2006-07-26 10:00:00	MSFT	Stock	24.25	24.27	24.14	24.21	6628511.0
2006-07-26 11:00:00	MSFT	Stock	24.21	24.28	24.14	24.23	6525772.0
2006-07-26 12:00:00	MSFT	Stock	24.23	24.28	24.1	24.21	3405257.0
2006-07-26 13:00:00	MSFT	Stock	24.21	24.35	24.21	24.33	7718109.0
2006-07-26 14:00:00	MSFT	Stock	24.32	24.5	24.25	24.473	9350862.0
2006-07-26 15:00:00	MSFT	Stock	24.47	24.53	24.34	24.38	14849614.0
2006-07-26 16:00:00	MSFT	Stock	24.36	24.5	24.3	24.38	987618.0
2006-07-26 17:00:00	MSFT	Stock	24.38	24.39	24.38	24.39	2658.0
2006-07-26 18:00:00	MSFT	Stock	24.38	24.38	24.366	24.37	5961.0
2006-07-26 08:00:00	NVDA	Stock	0.3425	0.3425	0.3425	0.3425	11280.0
2006-07-26 09:00:00	NVDA	Stock	0.335	0.3392	0.3295	0.3352	48873360.0
2006-07-26 10:00:00	NVDA	Stock	0.3352	0.3352	0.3275	0.328	77741760.0
2006-07-26 11:00:00	NVDA	Stock	0.3282	0.3328	0.328	0.3328	54029220.0
2006-07-26 12:00:00	NVDA	Stock	0.3328	0.336	0.3317	0.3325	54271680.0
2006-07-26 13:00:00	NVDA	Stock	0.3327	0.3375	0.3325	0.3362	50522820.0
2006-07-26 14:00:00	NVDA	Stock	0.3363	0.3415	0.3327	0.3403	78181740.0
2006-07-26 15:00:00	NVDA	Stock	0.3402	0.3413	0.3372	0.3377	83636040.0
2006-07-26 16:00:00	NVDA	Stock	0.3382	0.3383	0.3375	0.3375	8264220.0
2006-07-26 17:00:00	NVDA	Stock	0.3383	0.3385	0.3383	0.3385	60000.0
2006-07-26 18:00:00	NVDA	Stock	0.3375	0.3393	0.3375	0.3393	50280.0
2006-07-26 04:00:00	AMZN	Stock	1.5825	1.5825	1.5825	1.5825	10000.0
2006-07-26 05:00:00	AMZN	Stock	1.455	1.455	1.455	1.455	19420.0
2006-07-26 06:00:00	AMZN	Stock	1.4555	1.457	1.4475	1.4475	75580.0
2006-07-26 07:00:00	AMZN	Stock	1.4475	1.46	1.4375	1.4525	604400.0
2006-07-26 08:00:00	AMZN	Stock	1.4555	1.4555	1.362	1.419	62614760.0
2006-07-26 09:00:00	AMZN	Stock	1.419	1.4505	1.4035	1.406	247709220.0
2006-07-26 10:00:00	AMZN	Stock	1.406	1.4065	1.376	1.3895	244167740.0
2006-07-26 11:00:00	AMZN	Stock	1.389	1.3895	1.348	1.35	182715800.0
2006-07-26 12:00:00	AMZN	Stock	1.3498	1.3535	1.3225	1.3305	187276300.0
2006-07-26 13:00:00	AMZN	Stock	1.3305	1.3325	1.31	1.3205	147280780.0
2006-07-26 14:00:00	AMZN	Stock	1.3205	1.325	1.305	1.313	164956880.0
2006-07-26 15:00:00	AMZN	Stock	1.3135	1.3235	1.298	1.311	266862360.0
2006-07-26 16:00:00	AMZN	Stock	1.309	1.3135	1.3075	1.311	3046060.0
2006-07-26 17:00:00	AMZN	Stock	1.313	1.3135	1.3065	1.3075	12368520.0
2006-07-26 18:00:00	AMZN	Stock	1.312	1.3128	1.3065	1.31	86380.0

> showing 50 of 29,498 rows — these rows as CSV

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