PREVIEW / stock_1hour / 2009-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-13.parquet
  size:    804 KB
  rows:    39,630
  symbols: 3,325

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-03-13 04:00:00	AAPL	Stock	3.4621	3.4621	3.4621	3.4621	5600.0
2009-03-13 05:00:00	AAPL	Stock	3.4336	3.4336	3.4336	3.4336	12600.0
2009-03-13 06:00:00	AAPL	Stock	3.4307	3.4307	3.4307	3.4307	2800.0
2009-03-13 07:00:00	AAPL	Stock	3.4554	3.4732	3.4411	3.4411	294616.0
2009-03-13 08:00:00	AAPL	Stock	3.4625	3.4707	3.4286	3.4304	1732304.0
2009-03-13 09:00:00	AAPL	Stock	3.4304	3.4714	3.4111	3.4661	106892520.0
2009-03-13 10:00:00	AAPL	Stock	3.4661	3.4686	3.4036	3.4089	118145608.0
2009-03-13 11:00:00	AAPL	Stock	3.4096	3.4221	3.3932	3.4129	74932900.0
2009-03-13 12:00:00	AAPL	Stock	3.4132	3.4236	3.3986	3.4211	54862948.0
2009-03-13 13:00:00	AAPL	Stock	3.4211	3.4286	3.4125	3.4186	42805028.0
2009-03-13 14:00:00	AAPL	Stock	3.4182	3.4286	3.4018	3.4107	77510188.0
2009-03-13 15:00:00	AAPL	Stock	3.4107	3.4261	3.4057	3.4261	99597316.0
2009-03-13 16:00:00	AAPL	Stock	3.42	3.4411	3.4149	3.4275	15277416.0
2009-03-13 17:00:00	AAPL	Stock	3.4286	3.4286	3.4243	3.4246	44240.0
2009-03-13 18:00:00	AAPL	Stock	3.425	3.4286	3.425	3.4286	412944.0
2009-03-13 19:00:00	AAPL	Stock	3.4254	3.4286	3.4254	3.4254	80528.0
2009-03-13 06:00:00	MSFT	Stock	17.24	17.24	17.24	17.24	250.0
2009-03-13 07:00:00	MSFT	Stock	17.15	17.15	17.14	17.15	1925.0
2009-03-13 08:00:00	MSFT	Stock	17.16	17.17	16.98	16.98	28579.0
2009-03-13 09:00:00	MSFT	Stock	16.95	17.05	16.632	16.725	8018633.0
2009-03-13 10:00:00	MSFT	Stock	16.73	16.89	16.48	16.52	17842683.0
2009-03-13 11:00:00	MSFT	Stock	16.52	16.58	16.21	16.27	12930286.0
2009-03-13 12:00:00	MSFT	Stock	16.26	16.34	16.18	16.3	7895273.0
2009-03-13 13:00:00	MSFT	Stock	16.3	16.47	16.28	16.36	6126793.0
2009-03-13 14:00:00	MSFT	Stock	16.369	16.5	16.27	16.47	9194982.0
2009-03-13 15:00:00	MSFT	Stock	16.46	16.68	16.41	16.63	15455615.0
2009-03-13 16:00:00	MSFT	Stock	16.65	16.68	16.428	16.65	3996615.0
2009-03-13 17:00:00	MSFT	Stock	16.64	16.65	16.23	16.64	19350.0
2009-03-13 18:00:00	MSFT	Stock	16.65	16.65	16.61	16.61	127233.0
2009-03-13 19:00:00	MSFT	Stock	16.61	16.64	16.61	16.64	4875.0
2009-03-13 08:00:00	NVDA	Stock	0.2462	0.25	0.2462	0.2488	372600.0
2009-03-13 09:00:00	NVDA	Stock	0.2462	0.2485	0.2422	0.2475	110978200.0
2009-03-13 10:00:00	NVDA	Stock	0.2475	0.2482	0.242	0.243	263791920.0
2009-03-13 11:00:00	NVDA	Stock	0.2428	0.2445	0.2388	0.2405	192642600.0
2009-03-13 12:00:00	NVDA	Stock	0.2405	0.2435	0.2398	0.2435	124954200.0
2009-03-13 13:00:00	NVDA	Stock	0.2435	0.2448	0.2412	0.2415	83218240.0
2009-03-13 14:00:00	NVDA	Stock	0.2412	0.2435	0.239	0.2418	154447560.0
2009-03-13 15:00:00	NVDA	Stock	0.2415	0.2453	0.2415	0.245	227189640.0
2009-03-13 16:00:00	NVDA	Stock	0.245	0.2462	0.243	0.245	11200800.0
2009-03-13 17:00:00	NVDA	Stock	0.245	0.2455	0.245	0.2455	177400.0
2009-03-13 18:00:00	NVDA	Stock	0.24	0.2455	0.24	0.244	40000.0
2009-03-13 07:00:00	AMZN	Stock	3.5	3.5	3.4875	3.4875	78400.0
2009-03-13 08:00:00	AMZN	Stock	3.47	3.4875	3.47	3.4715	424380.0
2009-03-13 09:00:00	AMZN	Stock	3.463	3.487	3.4075	3.427	28128320.0
2009-03-13 10:00:00	AMZN	Stock	3.427	3.4685	3.4075	3.425	35176540.0
2009-03-13 11:00:00	AMZN	Stock	3.4235	3.441	3.3765	3.387	29759600.0
2009-03-13 12:00:00	AMZN	Stock	3.3875	3.4095	3.387	3.406	14271560.0
2009-03-13 13:00:00	AMZN	Stock	3.4065	3.441	3.4025	3.426	12757100.0
2009-03-13 14:00:00	AMZN	Stock	3.4255	3.443	3.4075	3.4145	16245720.0
2009-03-13 15:00:00	AMZN	Stock	3.414	3.4345	3.3895	3.4245	34272260.0

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

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