PREVIEW / stock_1hour / 2009-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-08.parquet
  size:    803 KB
  rows:    39,748
  symbols: 3,295

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
2009-01-08 07:00:00	AAPL	Stock	3.2161	3.2286	3.2161	3.2282	39452.0
2009-01-08 08:00:00	AAPL	Stock	3.2304	3.2318	3.2143	3.2261	1517376.0
2009-01-08 09:00:00	AAPL	Stock	3.2236	3.2757	3.2236	3.2439	81045944.0
2009-01-08 10:00:00	AAPL	Stock	3.2439	3.26	3.2157	3.2564	108400208.0
2009-01-08 11:00:00	AAPL	Stock	3.2571	3.2679	3.2339	3.2421	71110704.0
2009-01-08 12:00:00	AAPL	Stock	3.2425	3.2793	3.2379	3.2721	56333060.0
2009-01-08 13:00:00	AAPL	Stock	3.2716	3.2746	3.2446	3.2661	66327800.0
2009-01-08 14:00:00	AAPL	Stock	3.2657	3.3236	3.2611	3.3157	121444596.0
2009-01-08 15:00:00	AAPL	Stock	3.3157	3.3268	3.2871	3.3143	140671048.0
2009-01-08 16:00:00	AAPL	Stock	3.3143	3.3207	3.2708	3.32	7795200.0
2009-01-08 17:00:00	AAPL	Stock	3.3186	3.3186	3.3107	3.3175	6965588.0
2009-01-08 18:00:00	AAPL	Stock	3.3164	3.3164	3.3107	3.3161	3707844.0
2009-01-08 19:00:00	AAPL	Stock	3.3143	3.3211	3.3139	3.3196	198660.0
2009-01-08 07:00:00	MSFT	Stock	19.44	19.45	19.44	19.45	800.0
2009-01-08 08:00:00	MSFT	Stock	19.49	19.6	19.36	19.52	133413.0
2009-01-08 09:00:00	MSFT	Stock	19.55	19.8	19.53	19.66	7939602.0
2009-01-08 10:00:00	MSFT	Stock	19.66	19.99	19.65	19.93	15028182.0
2009-01-08 11:00:00	MSFT	Stock	19.93	19.99	19.86	19.93	5663967.0
2009-01-08 12:00:00	MSFT	Stock	19.93	20.11	19.7	20.01	6464389.0
2009-01-08 13:00:00	MSFT	Stock	20.01	20.02	19.8	19.88	4413165.0
2009-01-08 14:00:00	MSFT	Stock	19.88	20.16	19.87	20.13	6615535.0
2009-01-08 15:00:00	MSFT	Stock	20.13	20.19	19.87	20.12	17866421.0
2009-01-08 16:00:00	MSFT	Stock	20.12	20.12	19.79	20.05	5061346.0
2009-01-08 17:00:00	MSFT	Stock	20.09	20.13	20.09	20.13	596100.0
2009-01-08 18:00:00	MSFT	Stock	19.9	20.13	19.9	20.11	22291.0
2009-01-08 19:00:00	MSFT	Stock	20.12	20.13	20.06	20.06	1883.0
2009-01-08 08:00:00	NVDA	Stock	0.212	0.213	0.212	0.2122	98000.0
2009-01-08 09:00:00	NVDA	Stock	0.212	0.2148	0.203	0.2043	87619960.0
2009-01-08 10:00:00	NVDA	Stock	0.2043	0.2098	0.2033	0.208	117871280.0
2009-01-08 11:00:00	NVDA	Stock	0.2081	0.2124	0.2078	0.2101	81731800.0
2009-01-08 12:00:00	NVDA	Stock	0.2102	0.2108	0.2023	0.2043	248190600.0
2009-01-08 13:00:00	NVDA	Stock	0.2043	0.2047	0.197	0.2035	152533720.0
2009-01-08 14:00:00	NVDA	Stock	0.2035	0.2092	0.2035	0.208	97550080.0
2009-01-08 15:00:00	NVDA	Stock	0.208	0.2112	0.2058	0.2098	207165120.0
2009-01-08 16:00:00	NVDA	Stock	0.21	0.2108	0.2058	0.21	7397960.0
2009-01-08 17:00:00	NVDA	Stock	0.21	0.21	0.21	0.21	4168000.0
2009-01-08 19:00:00	NVDA	Stock	0.2118	0.212	0.2088	0.2118	96000.0
2009-01-08 07:00:00	AMZN	Stock	2.786	2.786	2.786	2.786	2000.0
2009-01-08 08:00:00	AMZN	Stock	2.795	2.795	2.7355	2.75	200100.0
2009-01-08 09:00:00	AMZN	Stock	2.7575	2.789	2.729	2.7515	15682400.0
2009-01-08 10:00:00	AMZN	Stock	2.7525	2.8035	2.7445	2.7895	21457180.0
2009-01-08 11:00:00	AMZN	Stock	2.79	2.8035	2.745	2.753	12838380.0
2009-01-08 12:00:00	AMZN	Stock	2.7515	2.775	2.7505	2.7655	8142260.0
2009-01-08 13:00:00	AMZN	Stock	2.7645	2.772	2.7505	2.772	9333860.0
2009-01-08 14:00:00	AMZN	Stock	2.771	2.844	2.765	2.8385	18162520.0
2009-01-08 15:00:00	AMZN	Stock	2.838	2.866	2.824	2.8575	35966780.0
2009-01-08 16:00:00	AMZN	Stock	2.8575	2.86	2.791	2.858	1659660.0
2009-01-08 17:00:00	AMZN	Stock	2.858	2.858	2.858	2.858	1107200.0
2009-01-08 18:00:00	AMZN	Stock	2.857	2.857	2.85	2.85	33600.0
2009-01-08 19:00:00	AMZN	Stock	2.85	2.85	2.85	2.85	20000.0

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

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