PREVIEW / stock_1hour / 2007-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-21.parquet
  size:    790 KB
  rows:    39,359
  symbols: 3,193

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
2007-11-21 05:00:00	AAPL	Stock	5.95	5.95	5.95	5.95	11928.0
2007-11-21 06:00:00	AAPL	Stock	5.9314	5.9314	5.9314	5.9314	6328.0
2007-11-21 07:00:00	AAPL	Stock	5.9493	5.9771	5.9071	5.9432	628068.0
2007-11-21 08:00:00	AAPL	Stock	5.9446	5.9643	5.9125	5.9361	6907152.0
2007-11-21 09:00:00	AAPL	Stock	5.9386	5.9946	5.8929	5.9775	161196308.0
2007-11-21 10:00:00	AAPL	Stock	5.9775	6.0	5.8929	5.915	191602404.0
2007-11-21 11:00:00	AAPL	Stock	5.915	5.9643	5.8811	5.9307	144614876.0
2007-11-21 12:00:00	AAPL	Stock	5.9314	6.0607	5.9239	6.0482	179605944.0
2007-11-21 13:00:00	AAPL	Stock	6.047	6.0675	5.9627	6.0482	150780028.0
2007-11-21 14:00:00	AAPL	Stock	6.0471	6.1457	6.0443	6.1386	162578584.0
2007-11-21 15:00:00	AAPL	Stock	6.1386	6.1554	5.9879	6.0104	200794944.0
2007-11-21 16:00:00	AAPL	Stock	6.0143	6.0341	6.0039	6.0239	18137980.0
2007-11-21 17:00:00	AAPL	Stock	6.0214	6.0529	6.0164	6.0529	925176.0
2007-11-21 18:00:00	AAPL	Stock	6.0564	6.0618	6.0429	6.0536	301280.0
2007-11-21 19:00:00	AAPL	Stock	6.0482	6.0643	6.045	6.06	504616.0
2007-11-21 07:00:00	MSFT	Stock	34.17	34.3	34.05	34.23	36400.0
2007-11-21 08:00:00	MSFT	Stock	34.18	34.24	34.15	34.2	59647.0
2007-11-21 09:00:00	MSFT	Stock	34.21	34.67	34.2	34.62	7828618.0
2007-11-21 10:00:00	MSFT	Stock	34.62	34.73	34.29	34.39	17549454.0
2007-11-21 11:00:00	MSFT	Stock	34.39	34.52	34.21	34.4	10322143.0
2007-11-21 12:00:00	MSFT	Stock	34.4	34.52	34.26	34.47	10461488.0
2007-11-21 13:00:00	MSFT	Stock	34.47	34.62	34.4	34.51	9647584.0
2007-11-21 14:00:00	MSFT	Stock	34.51	34.58	34.44	34.54	7185979.0
2007-11-21 15:00:00	MSFT	Stock	34.538	34.57	34.18	34.21	24774845.0
2007-11-21 16:00:00	MSFT	Stock	34.21	34.5	34.13	34.22	2342919.0
2007-11-21 17:00:00	MSFT	Stock	34.2	34.444	34.2	34.25	48088.0
2007-11-21 18:00:00	MSFT	Stock	34.24	34.34	34.24	34.34	3205.0
2007-11-21 19:00:00	MSFT	Stock	34.36	34.36	34.31	34.31	3800.0
2007-11-21 08:00:00	NVDA	Stock	0.7458	0.7458	0.7313	0.7313	190600.0
2007-11-21 09:00:00	NVDA	Stock	0.73	0.7458	0.729	0.7412	54519880.0
2007-11-21 10:00:00	NVDA	Stock	0.7412	0.7492	0.7375	0.7403	89275800.0
2007-11-21 11:00:00	NVDA	Stock	0.74	0.7485	0.7363	0.7463	82517920.0
2007-11-21 12:00:00	NVDA	Stock	0.7463	0.758	0.746	0.7548	84411480.0
2007-11-21 13:00:00	NVDA	Stock	0.7548	0.7563	0.7463	0.7491	91153360.0
2007-11-21 14:00:00	NVDA	Stock	0.7492	0.7593	0.7485	0.759	100198560.0
2007-11-21 15:00:00	NVDA	Stock	0.7593	0.7605	0.742	0.742	122489360.0
2007-11-21 16:00:00	NVDA	Stock	0.742	0.7516	0.7388	0.7428	5615560.0
2007-11-21 17:00:00	NVDA	Stock	0.7438	0.748	0.7388	0.7388	6587040.0
2007-11-21 18:00:00	NVDA	Stock	0.7412	0.7425	0.7412	0.7425	80000.0
2007-11-21 19:00:00	NVDA	Stock	0.7425	0.7425	0.7418	0.7418	58000.0
2007-11-21 08:00:00	AMZN	Stock	4.0045	4.0195	3.9355	3.95	542000.0
2007-11-21 09:00:00	AMZN	Stock	3.95	4.008	3.945	3.9905	20644500.0
2007-11-21 10:00:00	AMZN	Stock	3.9915	3.997	3.942	3.957	22034720.0
2007-11-21 11:00:00	AMZN	Stock	3.957	4.008	3.9325	3.9935	18263540.0
2007-11-21 12:00:00	AMZN	Stock	3.9935	4.04	3.992	4.032	18314420.0
2007-11-21 13:00:00	AMZN	Stock	4.03	4.0305	4.0	4.021	8957060.0
2007-11-21 14:00:00	AMZN	Stock	4.0205	4.0365	3.9945	4.023	15775920.0
2007-11-21 15:00:00	AMZN	Stock	4.022	4.043	3.9815	3.9885	26689160.0
2007-11-21 16:00:00	AMZN	Stock	3.9885	4.0123	3.9875	3.9962	2301960.0
2007-11-21 17:00:00	AMZN	Stock	3.988	3.988	3.988	3.988	32340.0

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

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