PREVIEW / stock_1hour / 2007-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-04.parquet
  size:    654 KB
  rows:    31,222
  symbols: 2,486

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-04 06:00:00	AAPL	Stock	2.9989	2.9989	2.9989	2.9989	11200.0
2007-01-04 07:00:00	AAPL	Stock	2.9993	3.0	2.9925	3.0	51800.0
2007-01-04 08:00:00	AAPL	Stock	3.0032	3.0032	2.9804	2.9893	2299612.0
2007-01-04 09:00:00	AAPL	Stock	2.9893	3.035	2.9825	3.0243	132911548.0
2007-01-04 10:00:00	AAPL	Stock	3.0239	3.0639	3.0039	3.0589	200118016.0
2007-01-04 11:00:00	AAPL	Stock	3.0589	3.0679	3.0432	3.0536	127583680.0
2007-01-04 12:00:00	AAPL	Stock	3.0546	3.06	3.0379	3.05	60720660.0
2007-01-04 13:00:00	AAPL	Stock	3.05	3.0568	3.0271	3.0311	89875156.0
2007-01-04 14:00:00	AAPL	Stock	3.0311	3.0589	3.0311	3.0536	94558240.0
2007-01-04 15:00:00	AAPL	Stock	3.0539	3.0696	3.0471	3.0586	119816200.0
2007-01-04 16:00:00	AAPL	Stock	3.0582	3.0607	3.0557	3.0593	1054396.0
2007-01-04 17:00:00	AAPL	Stock	3.0571	3.0593	2.9914	3.0593	343280.0
2007-01-04 18:00:00	AAPL	Stock	3.0593	3.0711	3.0589	3.0675	6144964.0
2007-01-04 19:00:00	AAPL	Stock	3.0679	3.0754	3.0654	3.0707	531020.0
2007-01-04 06:00:00	MSFT	Stock	29.78	29.78	29.78	29.78	154.0
2007-01-04 07:00:00	MSFT	Stock	29.78	29.78	29.77	29.77	3000.0
2007-01-04 08:00:00	MSFT	Stock	29.77	29.8	29.77	29.78	6110.0
2007-01-04 09:00:00	MSFT	Stock	29.8	29.86	29.54	29.59	7336736.0
2007-01-04 10:00:00	MSFT	Stock	29.59	29.82	29.44	29.74	9890058.0
2007-01-04 11:00:00	MSFT	Stock	29.74	29.85	29.7	29.8	5255149.0
2007-01-04 12:00:00	MSFT	Stock	29.79	29.85	29.76	29.83	3721372.0
2007-01-04 13:00:00	MSFT	Stock	29.822	29.85	29.7	29.78	3770220.0
2007-01-04 14:00:00	MSFT	Stock	29.78	29.94	29.73	29.91	6331651.0
2007-01-04 15:00:00	MSFT	Stock	29.9	29.97	29.8	29.81	7382186.0
2007-01-04 16:00:00	MSFT	Stock	29.82	29.82	29.73	29.81	60607.0
2007-01-04 17:00:00	MSFT	Stock	29.81	30.049	29.81	29.81	79690.0
2007-01-04 18:00:00	MSFT	Stock	29.79	29.83	29.78	29.8	53281.0
2007-01-04 19:00:00	MSFT	Stock	29.84	29.84	29.84	29.84	944.0
2007-01-04 08:00:00	NVDA	Stock	0.6015	0.6015	0.5978	0.5978	72000.0
2007-01-04 09:00:00	NVDA	Stock	0.5973	0.6013	0.592	0.593	123970980.0
2007-01-04 10:00:00	NVDA	Stock	0.5927	0.5947	0.5838	0.5917	207607680.0
2007-01-04 11:00:00	NVDA	Stock	0.5917	0.5942	0.5913	0.594	73584360.0
2007-01-04 12:00:00	NVDA	Stock	0.594	0.596	0.5917	0.5953	73233000.0
2007-01-04 13:00:00	NVDA	Stock	0.5953	0.5958	0.5907	0.5933	69514380.0
2007-01-04 14:00:00	NVDA	Stock	0.5932	0.5952	0.5877	0.5937	98428680.0
2007-01-04 15:00:00	NVDA	Stock	0.5938	0.6	0.5927	0.5985	132979680.0
2007-01-04 16:00:00	NVDA	Stock	0.5987	0.5992	0.598	0.5992	164520.0
2007-01-04 17:00:00	NVDA	Stock	0.5992	0.6013	0.5992	0.5998	216000.0
2007-01-04 18:00:00	NVDA	Stock	0.5985	0.5993	0.5972	0.5972	156000.0
2007-01-04 08:00:00	AMZN	Stock	1.925	1.932	1.925	1.932	24000.0
2007-01-04 09:00:00	AMZN	Stock	1.925	1.9365	1.913	1.929	11708140.0
2007-01-04 10:00:00	AMZN	Stock	1.9275	1.952	1.9145	1.947	19136340.0
2007-01-04 11:00:00	AMZN	Stock	1.9465	1.957	1.938	1.939	13832420.0
2007-01-04 12:00:00	AMZN	Stock	1.938	1.95	1.926	1.937	12631480.0
2007-01-04 13:00:00	AMZN	Stock	1.9375	1.9375	1.917	1.9235	12016880.0
2007-01-04 14:00:00	AMZN	Stock	1.9235	1.9445	1.919	1.9435	16817660.0
2007-01-04 15:00:00	AMZN	Stock	1.944	1.951	1.9405	1.9455	28313460.0
2007-01-04 16:00:00	AMZN	Stock	1.9465	1.9495	1.945	1.945	317760.0
2007-01-04 17:00:00	AMZN	Stock	1.935	1.945	1.935	1.945	512000.0
2007-01-04 18:00:00	AMZN	Stock	1.945	1.945	1.942	1.942	18800.0

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

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