PREVIEW / stock_1hour / 2007-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-10.parquet
  size:    645 KB
  rows:    30,821
  symbols: 2,483

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-01-10 04:00:00	AAPL	Stock	3.3018	3.3018	3.3018	3.3018	14000.0
2007-01-10 05:00:00	AAPL	Stock	3.2975	3.2979	3.2968	3.2971	60340.0
2007-01-10 06:00:00	AAPL	Stock	3.2982	3.3211	3.2982	3.3071	675724.0
2007-01-10 07:00:00	AAPL	Stock	3.3143	3.3468	3.3143	3.3304	7998508.0
2007-01-10 08:00:00	AAPL	Stock	3.3268	3.3664	3.3179	3.365	51038932.0
2007-01-10 09:00:00	AAPL	Stock	3.365	3.3943	3.3375	3.3871	520868656.0
2007-01-10 10:00:00	AAPL	Stock	3.3875	3.4446	3.3764	3.4343	560719544.0
2007-01-10 11:00:00	AAPL	Stock	3.4345	3.4929	3.4321	3.4746	520543660.0
2007-01-10 12:00:00	AAPL	Stock	3.4746	3.4911	3.4632	3.4679	263476668.0
2007-01-10 13:00:00	AAPL	Stock	3.4679	3.4711	3.4179	3.4225	313490632.0
2007-01-10 14:00:00	AAPL	Stock	3.4225	3.4611	3.4204	3.4414	277066720.0
2007-01-10 15:00:00	AAPL	Stock	3.4411	3.47	3.4325	3.4696	350216412.0
2007-01-10 16:00:00	AAPL	Stock	3.4696	3.4732	3.3907	3.4732	12488700.0
2007-01-10 17:00:00	AAPL	Stock	3.4732	3.475	3.4161	3.4393	58545060.0
2007-01-10 18:00:00	AAPL	Stock	3.4382	3.455	3.4361	3.4432	4754316.0
2007-01-10 19:00:00	AAPL	Stock	3.4432	3.45	3.4382	3.45	2603636.0
2007-01-10 05:00:00	MSFT	Stock	29.74	29.74	29.74	29.74	100.0
2007-01-10 06:00:00	MSFT	Stock	29.83	29.83	29.83	29.83	5000.0
2007-01-10 07:00:00	MSFT	Stock	29.76	29.76	29.76	29.76	1300.0
2007-01-10 08:00:00	MSFT	Stock	29.77	29.96	29.76	29.8	198001.0
2007-01-10 09:00:00	MSFT	Stock	29.8	29.89	29.65	29.79	5983026.0
2007-01-10 10:00:00	MSFT	Stock	29.78	29.79	29.56	29.71	8918959.0
2007-01-10 11:00:00	MSFT	Stock	29.71	29.72	29.52	29.628	5555985.0
2007-01-10 12:00:00	MSFT	Stock	29.622	29.63	29.43	29.54	5848871.0
2007-01-10 13:00:00	MSFT	Stock	29.54	29.73	29.53	29.728	11939845.0
2007-01-10 14:00:00	MSFT	Stock	29.73	29.74	29.64	29.651	4769187.0
2007-01-10 15:00:00	MSFT	Stock	29.659	29.7	29.63	29.67	9430198.0
2007-01-10 16:00:00	MSFT	Stock	29.66	29.748	29.66	29.67	538408.0
2007-01-10 17:00:00	MSFT	Stock	29.669	29.67	29.669	29.67	4061.0
2007-01-10 18:00:00	MSFT	Stock	30.0	30.0	29.67	29.67	30904.0
2007-01-10 19:00:00	MSFT	Stock	29.68	29.68	29.68	29.68	500.0
2007-01-10 07:00:00	NVDA	Stock	0.5528	0.553	0.552	0.552	252060.0
2007-01-10 08:00:00	NVDA	Stock	0.5492	0.5503	0.548	0.55	238380.0
2007-01-10 09:00:00	NVDA	Stock	0.55	0.555	0.54	0.554	116221200.0
2007-01-10 10:00:00	NVDA	Stock	0.554	0.5717	0.5522	0.5717	248731140.0
2007-01-10 11:00:00	NVDA	Stock	0.5715	0.579	0.5708	0.578	177528480.0
2007-01-10 12:00:00	NVDA	Stock	0.5778	0.5812	0.5755	0.5807	96262260.0
2007-01-10 13:00:00	NVDA	Stock	0.5805	0.5857	0.5802	0.5805	120576900.0
2007-01-10 14:00:00	NVDA	Stock	0.5805	0.5867	0.5805	0.5855	107403900.0
2007-01-10 15:00:00	NVDA	Stock	0.5855	0.5863	0.5647	0.5815	187804560.0
2007-01-10 16:00:00	NVDA	Stock	0.5815	0.583	0.5808	0.5822	18738000.0
2007-01-10 17:00:00	NVDA	Stock	0.583	0.5865	0.583	0.5858	382620.0
2007-01-10 18:00:00	NVDA	Stock	0.5858	0.5865	0.585	0.585	369000.0
2007-01-10 19:00:00	NVDA	Stock	0.5838	0.5838	0.5838	0.5838	30000.0
2007-01-10 08:00:00	AMZN	Stock	1.8825	1.885	1.8775	1.8775	36000.0
2007-01-10 09:00:00	AMZN	Stock	1.8775	1.88	1.855	1.8715	10277000.0
2007-01-10 10:00:00	AMZN	Stock	1.8715	1.8825	1.862	1.876	14605040.0
2007-01-10 11:00:00	AMZN	Stock	1.8755	1.8765	1.855	1.876	22855460.0
2007-01-10 12:00:00	AMZN	Stock	1.8765	1.881	1.8644	1.876	14958360.0
2007-01-10 13:00:00	AMZN	Stock	1.8755	1.885	1.8735	1.8795	7154080.0

> showing 50 of 30,821 rows — these rows as CSV

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