PREVIEW / stock_1hour / 2008-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-27.parquet
  size:    797 KB
  rows:    39,660
  symbols: 3,243

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-02-27 04:00:00	AAPL	Stock	4.2464	4.2464	4.2418	4.2429	22400.0
2008-02-27 05:00:00	AAPL	Stock	4.2429	4.2429	4.2429	4.2429	2800.0
2008-02-27 06:00:00	AAPL	Stock	4.25	4.25	4.25	4.25	2800.0
2008-02-27 07:00:00	AAPL	Stock	4.2446	4.2518	4.2325	4.2325	64596.0
2008-02-27 08:00:00	AAPL	Stock	4.2379	4.2379	4.1929	4.2093	2901248.0
2008-02-27 09:00:00	AAPL	Stock	4.2082	4.2993	4.2046	4.2684	209816376.0
2008-02-27 10:00:00	AAPL	Stock	4.2686	4.3214	4.2407	4.2854	269422160.0
2008-02-27 11:00:00	AAPL	Stock	4.2854	4.335	4.2786	4.3325	171100104.0
2008-02-27 12:00:00	AAPL	Stock	4.3321	4.3657	4.3021	4.35	174275920.0
2008-02-27 13:00:00	AAPL	Stock	4.35	4.3661	4.3182	4.3368	163675484.0
2008-02-27 14:00:00	AAPL	Stock	4.3364	4.3529	4.2961	4.3486	143644396.0
2008-02-27 15:00:00	AAPL	Stock	4.3493	4.3946	4.3329	4.3893	249331040.0
2008-02-27 16:00:00	AAPL	Stock	4.3893	4.5118	4.3164	4.5018	44187276.0
2008-02-27 17:00:00	AAPL	Stock	4.5036	4.5696	4.2911	4.5471	38394356.0
2008-02-27 18:00:00	AAPL	Stock	4.5468	4.5593	4.5304	4.555	6232828.0
2008-02-27 19:00:00	AAPL	Stock	4.5518	4.5529	4.5393	4.5464	2084180.0
2008-02-27 06:00:00	MSFT	Stock	28.28	28.28	28.28	28.28	600.0
2008-02-27 07:00:00	MSFT	Stock	28.21	28.3	28.15	28.26	2616.0
2008-02-27 08:00:00	MSFT	Stock	28.21	28.22	28.11	28.2	67835.0
2008-02-27 09:00:00	MSFT	Stock	28.21	28.44	28.1	28.43	7150677.0
2008-02-27 10:00:00	MSFT	Stock	28.44	28.68	28.17	28.46	13372295.0
2008-02-27 11:00:00	MSFT	Stock	28.45	28.53	28.36	28.48	8321377.0
2008-02-27 12:00:00	MSFT	Stock	28.47	28.48	28.26	28.305	9938929.0
2008-02-27 13:00:00	MSFT	Stock	28.3	28.33	28.17	28.18	7754154.0
2008-02-27 14:00:00	MSFT	Stock	28.19	28.29	28.1	28.28	10590062.0
2008-02-27 15:00:00	MSFT	Stock	28.29	28.41	28.2	28.3	15823194.0
2008-02-27 16:00:00	MSFT	Stock	28.3	28.54	28.23	28.33	2413997.0
2008-02-27 17:00:00	MSFT	Stock	28.33	28.44	28.3	28.3	26138.0
2008-02-27 18:00:00	MSFT	Stock	28.28	28.35	28.28	28.28	5932.0
2008-02-27 19:00:00	MSFT	Stock	28.28	28.28	28.26	28.28	4406.0
2008-02-27 08:00:00	NVDA	Stock	0.5562	0.5622	0.5562	0.5575	116000.0
2008-02-27 09:00:00	NVDA	Stock	0.5575	0.5692	0.5562	0.567	56806280.0
2008-02-27 10:00:00	NVDA	Stock	0.5668	0.574	0.562	0.567	110871400.0
2008-02-27 11:00:00	NVDA	Stock	0.567	0.5758	0.567	0.5738	76137360.0
2008-02-27 12:00:00	NVDA	Stock	0.5738	0.575	0.5688	0.5718	51246960.0
2008-02-27 13:00:00	NVDA	Stock	0.5715	0.5745	0.5662	0.5688	42936680.0
2008-02-27 14:00:00	NVDA	Stock	0.5688	0.5735	0.5635	0.5732	69197160.0
2008-02-27 15:00:00	NVDA	Stock	0.573	0.575	0.5702	0.5725	110535760.0
2008-02-27 16:00:00	NVDA	Stock	0.5722	0.5732	0.5689	0.5715	2898880.0
2008-02-27 17:00:00	NVDA	Stock	0.5712	0.5718	0.5712	0.5718	7528800.0
2008-02-27 18:00:00	NVDA	Stock	0.5702	0.5718	0.5702	0.5712	30720.0
2008-02-27 19:00:00	NVDA	Stock	0.5712	0.5742	0.5712	0.5742	287360.0
2008-02-27 08:00:00	AMZN	Stock	3.5845	3.5845	3.5265	3.535	203000.0
2008-02-27 09:00:00	AMZN	Stock	3.53	3.5575	3.5015	3.5218	26266460.0
2008-02-27 10:00:00	AMZN	Stock	3.521	3.556	3.4785	3.5215	42111900.0
2008-02-27 11:00:00	AMZN	Stock	3.523	3.57	3.523	3.5695	25390160.0
2008-02-27 12:00:00	AMZN	Stock	3.5695	3.574	3.5405	3.544	15260120.0
2008-02-27 13:00:00	AMZN	Stock	3.5455	3.5625	3.516	3.52	15565080.0
2008-02-27 14:00:00	AMZN	Stock	3.52	3.53	3.4855	3.5295	20312300.0
2008-02-27 15:00:00	AMZN	Stock	3.5295	3.5495	3.5125	3.5435	29011740.0

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

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