PREVIEW / stock_1hour / 2009-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-27.parquet
  size:    796 KB
  rows:    39,800
  symbols: 3,300

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-27 04:00:00	AAPL	Stock	3.2143	3.2143	3.2121	3.2121	16800.0
2009-01-27 05:00:00	AAPL	Stock	3.2121	3.2121	3.2121	3.2121	5600.0
2009-01-27 06:00:00	AAPL	Stock	3.2111	3.2111	3.2111	3.2111	2800.0
2009-01-27 08:00:00	AAPL	Stock	3.2	3.2357	3.1982	3.2318	2255484.0
2009-01-27 09:00:00	AAPL	Stock	3.2318	3.2454	3.205	3.2296	77410424.0
2009-01-27 10:00:00	AAPL	Stock	3.2293	3.2318	3.205	3.2157	96203296.0
2009-01-27 11:00:00	AAPL	Stock	3.2161	3.2307	3.2093	3.2239	64024268.0
2009-01-27 12:00:00	AAPL	Stock	3.2243	3.2318	3.2182	3.2218	56269136.0
2009-01-27 13:00:00	AAPL	Stock	3.2207	3.2489	3.2143	3.2382	70166964.0
2009-01-27 14:00:00	AAPL	Stock	3.2375	3.2436	3.2214	3.2396	70670712.0
2009-01-27 15:00:00	AAPL	Stock	3.24	3.2696	3.2339	3.2393	149597308.0
2009-01-27 16:00:00	AAPL	Stock	3.2393	3.2464	3.2239	3.2457	18935756.0
2009-01-27 17:00:00	AAPL	Stock	3.2457	3.2679	3.2421	3.2643	790860.0
2009-01-27 18:00:00	AAPL	Stock	3.2404	3.2679	3.2404	3.2571	8559068.0
2009-01-27 19:00:00	AAPL	Stock	3.265	3.2661	3.2571	3.2611	388472.0
2009-01-27 07:00:00	MSFT	Stock	17.55	17.68	17.55	17.68	1698.0
2009-01-27 08:00:00	MSFT	Stock	17.63	17.75	17.6	17.74	33175.0
2009-01-27 09:00:00	MSFT	Stock	17.74	17.87	17.56	17.63	8046811.0
2009-01-27 10:00:00	MSFT	Stock	17.63	17.85	17.43	17.84	12849147.0
2009-01-27 11:00:00	MSFT	Stock	17.84	17.89	17.77	17.822	5967430.0
2009-01-27 12:00:00	MSFT	Stock	17.83	17.97	17.8	17.88	6932553.0
2009-01-27 13:00:00	MSFT	Stock	17.878	17.913	17.75	17.77	5936381.0
2009-01-27 14:00:00	MSFT	Stock	17.77	17.782	17.64	17.77	6738156.0
2009-01-27 15:00:00	MSFT	Stock	17.762	17.88	17.62	17.67	11705083.0
2009-01-27 16:00:00	MSFT	Stock	17.67	17.93	17.61	17.66	2626291.0
2009-01-27 17:00:00	MSFT	Stock	17.62	17.75	17.62	17.74	41315.0
2009-01-27 18:00:00	MSFT	Stock	17.77	17.8	17.72	17.79	15607.0
2009-01-27 19:00:00	MSFT	Stock	17.76	17.84	17.74	17.8	7670.0
2009-01-27 09:00:00	NVDA	Stock	0.201	0.2125	0.201	0.2118	152755480.0
2009-01-27 10:00:00	NVDA	Stock	0.2118	0.2122	0.2072	0.209	111742720.0
2009-01-27 11:00:00	NVDA	Stock	0.2088	0.2115	0.2082	0.2095	116414040.0
2009-01-27 12:00:00	NVDA	Stock	0.2095	0.2125	0.209	0.2118	71499880.0
2009-01-27 13:00:00	NVDA	Stock	0.212	0.2125	0.2102	0.2108	68110080.0
2009-01-27 14:00:00	NVDA	Stock	0.2105	0.2122	0.2082	0.212	64267760.0
2009-01-27 15:00:00	NVDA	Stock	0.2118	0.2125	0.2105	0.2112	103747560.0
2009-01-27 16:00:00	NVDA	Stock	0.211	0.2112	0.209	0.2102	25063400.0
2009-01-27 17:00:00	NVDA	Stock	0.211	0.2115	0.2102	0.2115	619240.0
2009-01-27 18:00:00	NVDA	Stock	0.2115	0.2115	0.21	0.211	333880.0
2009-01-27 08:00:00	AMZN	Stock	2.4875	2.494	2.4875	2.494	18000.0
2009-01-27 09:00:00	AMZN	Stock	2.494	2.521	2.456	2.498	13080220.0
2009-01-27 10:00:00	AMZN	Stock	2.496	2.5	2.413	2.447	31196360.0
2009-01-27 11:00:00	AMZN	Stock	2.447	2.447	2.3945	2.3996	26582940.0
2009-01-27 12:00:00	AMZN	Stock	2.4	2.4235	2.386	2.41	19368520.0
2009-01-27 13:00:00	AMZN	Stock	2.4105	2.4325	2.404	2.404	14514280.0
2009-01-27 14:00:00	AMZN	Stock	2.404	2.415	2.392	2.4065	21795940.0
2009-01-27 15:00:00	AMZN	Stock	2.4075	2.4415	2.4025	2.4165	44509840.0
2009-01-27 16:00:00	AMZN	Stock	2.415	2.445	2.413	2.4405	1505600.0
2009-01-27 17:00:00	AMZN	Stock	2.426	2.445	2.426	2.4375	53360.0
2009-01-27 18:00:00	AMZN	Stock	2.4485	2.4525	2.4485	2.4525	24000.0
2009-01-27 19:00:00	AMZN	Stock	2.4505	2.4625	2.45	2.462	32600.0

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

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