PREVIEW / stock_1hour / 2008-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-09.parquet
  size:    824 KB
  rows:    39,915
  symbols: 3,318

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-07-09 05:00:00	AAPL	Stock	6.4357	6.4357	6.4357	6.4357	2800.0
2008-07-09 06:00:00	AAPL	Stock	6.4564	6.4739	6.4286	6.4286	14000.0
2008-07-09 07:00:00	AAPL	Stock	6.4161	6.4479	6.375	6.4464	755188.0
2008-07-09 08:00:00	AAPL	Stock	6.4429	6.4707	6.4282	6.4536	7783972.0
2008-07-09 09:00:00	AAPL	Stock	6.4536	6.4607	6.3932	6.4321	122524640.0
2008-07-09 10:00:00	AAPL	Stock	6.4321	6.4611	6.3979	6.4232	145299476.0
2008-07-09 11:00:00	AAPL	Stock	6.4236	6.4554	6.4129	6.4218	94624880.0
2008-07-09 12:00:00	AAPL	Stock	6.4225	6.4254	6.38	6.4064	88611880.0
2008-07-09 13:00:00	AAPL	Stock	6.4061	6.4239	6.3768	6.41	75628952.0
2008-07-09 14:00:00	AAPL	Stock	6.4104	6.4318	6.3154	6.3411	116770304.0
2008-07-09 15:00:00	AAPL	Stock	6.3404	6.3411	6.2193	6.2236	207560108.0
2008-07-09 16:00:00	AAPL	Stock	6.2239	6.4357	6.2225	6.2364	22819524.0
2008-07-09 17:00:00	AAPL	Stock	6.2357	6.4175	6.2336	6.2446	323652.0
2008-07-09 18:00:00	AAPL	Stock	6.2429	6.2479	6.2232	6.245	829556.0
2008-07-09 19:00:00	AAPL	Stock	6.2446	6.2446	6.2346	6.2446	284424.0
2008-07-09 08:00:00	MSFT	Stock	25.85	25.92	25.78	25.88	11675.0
2008-07-09 09:00:00	MSFT	Stock	25.88	25.88	25.51	25.52	4310464.0
2008-07-09 10:00:00	MSFT	Stock	25.52	25.67	25.46	25.62	10080856.0
2008-07-09 11:00:00	MSFT	Stock	25.61	25.76	25.53	25.66	6197147.0
2008-07-09 12:00:00	MSFT	Stock	25.65	25.7	25.55	25.61	3889415.0
2008-07-09 13:00:00	MSFT	Stock	25.618	25.67	25.51	25.61	3811359.0
2008-07-09 14:00:00	MSFT	Stock	25.61	25.72	25.51	25.58	6057171.0
2008-07-09 15:00:00	MSFT	Stock	25.58	25.58	25.19	25.2	15689061.0
2008-07-09 16:00:00	MSFT	Stock	25.19	25.85	25.18	25.23	3035971.0
2008-07-09 17:00:00	MSFT	Stock	25.25	25.85	25.25	25.28	55780.0
2008-07-09 18:00:00	MSFT	Stock	25.27	25.27	25.23	25.25	59172.0
2008-07-09 19:00:00	MSFT	Stock	25.26	25.26	25.25	25.26	3353.0
2008-07-09 08:00:00	NVDA	Stock	0.3022	0.3045	0.3008	0.3038	1497120.0
2008-07-09 09:00:00	NVDA	Stock	0.3042	0.306	0.3	0.3008	119926520.0
2008-07-09 10:00:00	NVDA	Stock	0.3008	0.304	0.2982	0.303	169440920.0
2008-07-09 11:00:00	NVDA	Stock	0.3028	0.3048	0.2982	0.299	139050280.0
2008-07-09 12:00:00	NVDA	Stock	0.299	0.3005	0.2982	0.299	145742400.0
2008-07-09 13:00:00	NVDA	Stock	0.299	0.2998	0.297	0.2992	111381680.0
2008-07-09 14:00:00	NVDA	Stock	0.2992	0.3029	0.297	0.2978	166087960.0
2008-07-09 15:00:00	NVDA	Stock	0.298	0.2982	0.296	0.2965	526529880.0
2008-07-09 16:00:00	NVDA	Stock	0.2955	0.3008	0.2955	0.2955	11789480.0
2008-07-09 17:00:00	NVDA	Stock	0.2975	0.2978	0.2972	0.2978	40000.0
2008-07-09 18:00:00	NVDA	Stock	0.2978	0.298	0.2968	0.298	148600.0
2008-07-09 19:00:00	NVDA	Stock	0.2982	0.2985	0.2968	0.2968	38400.0
2008-07-09 20:00:00	NVDA	Stock	0.2955	0.2955	0.2955	0.2955	212000.0
2008-07-09 08:00:00	AMZN	Stock	3.7505	3.762	3.7505	3.762	10600.0
2008-07-09 09:00:00	AMZN	Stock	3.753	3.753	3.671	3.703	19082980.0
2008-07-09 10:00:00	AMZN	Stock	3.7025	3.7315	3.6805	3.7065	17680000.0
2008-07-09 11:00:00	AMZN	Stock	3.7065	3.7155	3.65	3.657	12023400.0
2008-07-09 12:00:00	AMZN	Stock	3.657	3.664	3.6205	3.6305	8894020.0
2008-07-09 13:00:00	AMZN	Stock	3.63	3.653	3.605	3.647	10589740.0
2008-07-09 14:00:00	AMZN	Stock	3.6485	3.659	3.6	3.606	16495880.0
2008-07-09 15:00:00	AMZN	Stock	3.6065	3.6105	3.524	3.525	45368940.0
2008-07-09 16:00:00	AMZN	Stock	3.524	3.752	3.513	3.53	6148600.0
2008-07-09 17:00:00	AMZN	Stock	3.752	3.752	3.53	3.53	93000.0

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

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