PREVIEW / stock_1hour / 2008-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-27.parquet
  size:    813 KB
  rows:    39,691
  symbols: 3,299

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-27 07:00:00	AAPL	Stock	6.2036	6.2036	6.1964	6.1968	12320.0
2008-08-27 08:00:00	AAPL	Stock	6.1932	6.2189	6.1764	6.2089	1656564.0
2008-08-27 09:00:00	AAPL	Stock	6.2089	6.2136	6.1497	6.1732	58334024.0
2008-08-27 10:00:00	AAPL	Stock	6.1732	6.2175	6.1646	6.1968	83379408.0
2008-08-27 11:00:00	AAPL	Stock	6.1961	6.2214	6.1861	6.2071	49662172.0
2008-08-27 12:00:00	AAPL	Stock	6.2075	6.2771	6.2043	6.2708	83562500.0
2008-08-27 13:00:00	AAPL	Stock	6.2698	6.2771	6.2507	6.2568	45787672.0
2008-08-27 14:00:00	AAPL	Stock	6.2568	6.2764	6.2475	6.2521	49082908.0
2008-08-27 15:00:00	AAPL	Stock	6.2511	6.2604	6.2179	6.2411	77162064.0
2008-08-27 16:00:00	AAPL	Stock	6.2382	6.2503	6.1658	6.2139	12771808.0
2008-08-27 17:00:00	AAPL	Stock	6.2136	6.2214	6.1879	6.1996	1116696.0
2008-08-27 18:00:00	AAPL	Stock	6.2	6.2136	6.2	6.2136	520716.0
2008-08-27 19:00:00	AAPL	Stock	6.2132	6.2243	6.2104	6.2143	230412.0
2008-08-27 20:00:00	AAPL	Stock	6.2389	6.2389	6.2389	6.2389	8400.0
2008-08-27 07:00:00	MSFT	Stock	27.47	27.47	27.45	27.45	800.0
2008-08-27 08:00:00	MSFT	Stock	27.25	27.37	27.25	27.32	1500.0
2008-08-27 09:00:00	MSFT	Stock	27.33	27.34	27.13	27.29	2238237.0
2008-08-27 10:00:00	MSFT	Stock	27.29	27.54	27.262	27.372	5259601.0
2008-08-27 11:00:00	MSFT	Stock	27.37	27.51	27.36	27.45	3035418.0
2008-08-27 12:00:00	MSFT	Stock	27.45	27.75	27.44	27.71	3472130.0
2008-08-27 13:00:00	MSFT	Stock	27.72	27.76	27.65	27.68	3216456.0
2008-08-27 14:00:00	MSFT	Stock	27.68	27.79	27.63	27.67	3473763.0
2008-08-27 15:00:00	MSFT	Stock	27.68	27.69	27.5	27.57	8630080.0
2008-08-27 16:00:00	MSFT	Stock	27.5	27.666	27.5	27.56	3466981.0
2008-08-27 17:00:00	MSFT	Stock	27.556	27.68	27.556	27.68	8948.0
2008-08-27 18:00:00	MSFT	Stock	27.5	27.5	27.46	27.46	770.0
2008-08-27 19:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	600.0
2008-08-27 20:00:00	MSFT	Stock	27.46	27.46	27.46	27.46	1100.0
2008-08-27 08:00:00	NVDA	Stock	0.3362	0.3362	0.3263	0.3275	372000.0
2008-08-27 09:00:00	NVDA	Stock	0.3295	0.3298	0.3168	0.3255	62974440.0
2008-08-27 10:00:00	NVDA	Stock	0.3253	0.3338	0.3253	0.3313	91213400.0
2008-08-27 11:00:00	NVDA	Stock	0.3313	0.3322	0.3295	0.3298	42399120.0
2008-08-27 12:00:00	NVDA	Stock	0.33	0.3333	0.3295	0.3318	57908880.0
2008-08-27 13:00:00	NVDA	Stock	0.3318	0.332	0.3298	0.331	39123520.0
2008-08-27 14:00:00	NVDA	Stock	0.3308	0.3325	0.3305	0.331	46016160.0
2008-08-27 15:00:00	NVDA	Stock	0.331	0.3315	0.3275	0.3298	79712240.0
2008-08-27 16:00:00	NVDA	Stock	0.3295	0.3313	0.3288	0.3298	20381080.0
2008-08-27 17:00:00	NVDA	Stock	0.3305	0.3305	0.3305	0.3305	17040.0
2008-08-27 18:00:00	NVDA	Stock	0.3295	0.3305	0.3295	0.3305	8000.0
2008-08-27 19:00:00	NVDA	Stock	0.3295	0.3305	0.3295	0.3305	26520.0
2008-08-27 20:00:00	NVDA	Stock	0.3298	0.3298	0.3298	0.3298	5228000.0
2008-08-27 08:00:00	AMZN	Stock	4.087	4.088	4.0845	4.088	28300.0
2008-08-27 09:00:00	AMZN	Stock	4.081	4.1175	4.0595	4.077	13112220.0
2008-08-27 10:00:00	AMZN	Stock	4.0775	4.1315	4.0595	4.078	16863860.0
2008-08-27 11:00:00	AMZN	Stock	4.076	4.08	4.05	4.0645	10798940.0
2008-08-27 12:00:00	AMZN	Stock	4.066	4.137	4.056	4.13	15097400.0
2008-08-27 13:00:00	AMZN	Stock	4.13	4.135	4.105	4.1105	10014660.0
2008-08-27 14:00:00	AMZN	Stock	4.1105	4.1195	4.0915	4.103	13063780.0
2008-08-27 15:00:00	AMZN	Stock	4.1025	4.1075	4.051	4.0835	29003940.0
2008-08-27 16:00:00	AMZN	Stock	4.085	4.0933	4.0745	4.0865	3744640.0

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

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