PREVIEW / stock_1hour / 2008-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-22.parquet
  size:    800 KB
  rows:    39,212
  symbols: 3,298

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
2008-08-22 07:00:00	AAPL	Stock	6.2346	6.2786	6.2346	6.2771	518756.0
2008-08-22 08:00:00	AAPL	Stock	6.2682	6.2771	6.2593	6.2714	2196768.0
2008-08-22 09:00:00	AAPL	Stock	6.2732	6.3125	6.2704	6.2911	75373228.0
2008-08-22 10:00:00	AAPL	Stock	6.2918	6.3393	6.2821	6.3107	97342112.0
2008-08-22 11:00:00	AAPL	Stock	6.311	6.325	6.294	6.3221	44992136.0
2008-08-22 12:00:00	AAPL	Stock	6.3225	6.3339	6.2964	6.3304	44882068.0
2008-08-22 13:00:00	AAPL	Stock	6.3304	6.3393	6.3107	6.3196	46097016.0
2008-08-22 14:00:00	AAPL	Stock	6.3195	6.3393	6.3004	6.3179	54043724.0
2008-08-22 15:00:00	AAPL	Stock	6.3179	6.325	6.3029	6.3143	60850804.0
2008-08-22 16:00:00	AAPL	Stock	6.3111	6.3214	6.3089	6.3214	9320864.0
2008-08-22 17:00:00	AAPL	Stock	6.3196	6.3286	6.3179	6.3286	268548.0
2008-08-22 18:00:00	AAPL	Stock	6.3214	6.3232	6.3186	6.3186	50540.0
2008-08-22 19:00:00	AAPL	Stock	6.3268	6.3286	6.3214	6.3279	98840.0
2008-08-22 08:00:00	MSFT	Stock	27.28	27.39	27.28	27.28	2642.0
2008-08-22 09:00:00	MSFT	Stock	27.29	27.44	27.22	27.43	3717773.0
2008-08-22 10:00:00	MSFT	Stock	27.43	27.53	27.34	27.5	5594732.0
2008-08-22 11:00:00	MSFT	Stock	27.51	27.64	27.46	27.62	8273904.0
2008-08-22 12:00:00	MSFT	Stock	27.61	27.74	27.582	27.7	6420113.0
2008-08-22 13:00:00	MSFT	Stock	27.69	27.81	27.68	27.78	5722772.0
2008-08-22 14:00:00	MSFT	Stock	27.78	27.88	27.72	27.82	5702119.0
2008-08-22 15:00:00	MSFT	Stock	27.83	27.86	27.76	27.82	9439727.0
2008-08-22 16:00:00	MSFT	Stock	27.81	27.87	27.281	27.84	2251012.0
2008-08-22 17:00:00	MSFT	Stock	27.79	27.8	27.43	27.8	38778.0
2008-08-22 08:00:00	NVDA	Stock	0.3442	0.3445	0.3418	0.3442	328000.0
2008-08-22 09:00:00	NVDA	Stock	0.3442	0.347	0.3388	0.3413	68269320.0
2008-08-22 10:00:00	NVDA	Stock	0.3415	0.3435	0.34	0.34	54872160.0
2008-08-22 11:00:00	NVDA	Stock	0.34	0.3402	0.3353	0.3358	75992600.0
2008-08-22 12:00:00	NVDA	Stock	0.3355	0.3375	0.333	0.3375	65010040.0
2008-08-22 13:00:00	NVDA	Stock	0.3374	0.34	0.3373	0.3398	39885760.0
2008-08-22 14:00:00	NVDA	Stock	0.3397	0.3418	0.3375	0.3396	44594400.0
2008-08-22 15:00:00	NVDA	Stock	0.3395	0.3408	0.3388	0.3395	74807720.0
2008-08-22 16:00:00	NVDA	Stock	0.3395	0.3414	0.3388	0.3388	14237520.0
2008-08-22 18:00:00	NVDA	Stock	0.3385	0.3385	0.3385	0.3385	9960.0
2008-08-22 19:00:00	NVDA	Stock	0.34	0.34	0.34	0.34	114360.0
2008-08-22 08:00:00	AMZN	Stock	4.2	4.2	4.175	4.175	47400.0
2008-08-22 09:00:00	AMZN	Stock	4.1855	4.2435	4.185	4.2335	9958900.0
2008-08-22 10:00:00	AMZN	Stock	4.232	4.262	4.2185	4.2245	16975620.0
2008-08-22 11:00:00	AMZN	Stock	4.224	4.2375	4.212	4.2375	8473020.0
2008-08-22 12:00:00	AMZN	Stock	4.2365	4.237	4.2055	4.2345	10493500.0
2008-08-22 13:00:00	AMZN	Stock	4.234	4.245	4.223	4.244	7101060.0
2008-08-22 14:00:00	AMZN	Stock	4.2425	4.2675	4.2195	4.265	12809640.0
2008-08-22 15:00:00	AMZN	Stock	4.2655	4.273	4.2455	4.2605	20925100.0
2008-08-22 16:00:00	AMZN	Stock	4.2605	4.2665	4.2326	4.263	4735420.0
2008-08-22 17:00:00	AMZN	Stock	4.2695	4.2695	4.267	4.267	24000.0
2008-08-22 18:00:00	AMZN	Stock	4.267	4.267	4.267	4.267	5000.0
2008-08-22 19:00:00	AMZN	Stock	4.256	4.2595	4.255	4.2595	20540.0
2008-08-22 08:00:00	TLT	Stock	92.99	93.08	92.99	93.0	16700.0
2008-08-22 09:00:00	TLT	Stock	93.11	93.11	92.9	92.98	168055.0
2008-08-22 10:00:00	TLT	Stock	92.97	93.08	92.64	92.74	687071.0
2008-08-22 11:00:00	TLT	Stock	92.73	92.83	92.66	92.71	234558.0

> showing 50 of 39,212 rows — these rows as CSV

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