PREVIEW / stock_1hour / 2007-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-31.parquet
  size:    662 KB
  rows:    31,467
  symbols: 2,505

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-31 06:00:00	AAPL	Stock	3.0554	3.0554	3.0468	3.0468	8400.0
2007-01-31 07:00:00	AAPL	Stock	3.0436	3.0446	3.0321	3.0446	29680.0
2007-01-31 08:00:00	AAPL	Stock	3.0464	3.05	3.0357	3.0421	2224068.0
2007-01-31 09:00:00	AAPL	Stock	3.0411	3.0457	3.0125	3.0193	138417916.0
2007-01-31 10:00:00	AAPL	Stock	3.0196	3.0443	3.0182	3.0371	155831508.0
2007-01-31 11:00:00	AAPL	Stock	3.0371	3.0375	3.0232	3.0286	59853584.0
2007-01-31 12:00:00	AAPL	Stock	3.0286	3.0296	3.0175	3.0232	59441788.0
2007-01-31 13:00:00	AAPL	Stock	3.0232	3.025	3.0179	3.0204	42664888.0
2007-01-31 14:00:00	AAPL	Stock	3.02	3.0554	3.0161	3.0461	188916504.0
2007-01-31 15:00:00	AAPL	Stock	3.0461	3.0714	3.0414	3.0614	185980564.0
2007-01-31 16:00:00	AAPL	Stock	3.0639	3.0696	3.0425	3.0564	4191768.0
2007-01-31 17:00:00	AAPL	Stock	3.0546	3.0607	3.0532	3.0571	622440.0
2007-01-31 18:00:00	AAPL	Stock	3.0571	3.0636	3.0554	3.0625	237776.0
2007-01-31 19:00:00	AAPL	Stock	3.0617	3.0625	3.0532	3.0607	119336.0
2007-01-31 07:00:00	MSFT	Stock	30.36	30.38	30.36	30.38	300.0
2007-01-31 08:00:00	MSFT	Stock	30.35	30.38	30.31	30.38	17154.0
2007-01-31 09:00:00	MSFT	Stock	30.37	30.463	30.32	30.403	5954142.0
2007-01-31 10:00:00	MSFT	Stock	30.4	30.94	30.37	30.64	14305956.0
2007-01-31 11:00:00	MSFT	Stock	30.64	30.68	30.474	30.66	6971034.0
2007-01-31 12:00:00	MSFT	Stock	30.66	30.671	30.474	30.65	9105917.0
2007-01-31 13:00:00	MSFT	Stock	30.64	30.68	30.58	30.62	4543637.0
2007-01-31 14:00:00	MSFT	Stock	30.62	30.96	30.6	30.94	12485438.0
2007-01-31 15:00:00	MSFT	Stock	30.95	31.1	30.8	30.86	15879862.0
2007-01-31 16:00:00	MSFT	Stock	30.87	31.0	30.76	30.8	292804.0
2007-01-31 17:00:00	MSFT	Stock	30.8	30.86	30.79	30.8	36554.0
2007-01-31 18:00:00	MSFT	Stock	30.86	30.86	30.86	30.86	200.0
2007-01-31 19:00:00	MSFT	Stock	30.86	30.86	30.83	30.86	6259.0
2007-01-31 08:00:00	NVDA	Stock	0.5117	0.5117	0.51	0.5117	264360.0
2007-01-31 09:00:00	NVDA	Stock	0.5102	0.5118	0.5038	0.5058	51664020.0
2007-01-31 10:00:00	NVDA	Stock	0.506	0.5157	0.5057	0.5112	76670400.0
2007-01-31 11:00:00	NVDA	Stock	0.5112	0.5112	0.5068	0.509	36367080.0
2007-01-31 12:00:00	NVDA	Stock	0.509	0.5093	0.5052	0.5073	33403680.0
2007-01-31 13:00:00	NVDA	Stock	0.5073	0.5087	0.5063	0.5068	32886240.0
2007-01-31 14:00:00	NVDA	Stock	0.507	0.5132	0.5038	0.5108	85677900.0
2007-01-31 15:00:00	NVDA	Stock	0.511	0.515	0.5103	0.5113	92254980.0
2007-01-31 16:00:00	NVDA	Stock	0.5113	0.512	0.5042	0.5108	2897700.0
2007-01-31 17:00:00	NVDA	Stock	0.5082	0.5082	0.5082	0.5082	60000.0
2007-01-31 19:00:00	NVDA	Stock	0.5108	0.5108	0.5108	0.5108	11580.0
2007-01-31 08:00:00	AMZN	Stock	1.8565	1.8575	1.8565	1.8575	12000.0
2007-01-31 09:00:00	AMZN	Stock	1.8515	1.8515	1.838	1.843	9616700.0
2007-01-31 10:00:00	AMZN	Stock	1.843	1.8695	1.84	1.8655	18267560.0
2007-01-31 11:00:00	AMZN	Stock	1.865	1.87	1.8585	1.869	12809600.0
2007-01-31 12:00:00	AMZN	Stock	1.8695	1.8745	1.8655	1.8715	10960140.0
2007-01-31 13:00:00	AMZN	Stock	1.871	1.877	1.8675	1.8745	9503080.0
2007-01-31 14:00:00	AMZN	Stock	1.8745	1.9	1.87	1.8965	22903580.0
2007-01-31 15:00:00	AMZN	Stock	1.897	1.9095	1.87	1.8835	46209480.0
2007-01-31 16:00:00	AMZN	Stock	1.882	1.8875	1.879	1.886	1772580.0
2007-01-31 17:00:00	AMZN	Stock	1.885	1.8855	1.885	1.8855	64000.0
2007-01-31 18:00:00	AMZN	Stock	1.8865	1.8865	1.8855	1.8855	28040.0
2007-01-31 19:00:00	AMZN	Stock	1.8835	1.89	1.8835	1.89	9340.0

> showing 50 of 31,467 rows — these rows as CSV

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