PREVIEW / stock_1hour / 2007-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-11.parquet
  size:    749 KB
  rows:    37,229
  symbols: 3,125

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-09-11 09:00:00	AAPL	Stock	4.925	4.9393	4.8421	4.8564	159810756.0
2007-09-11 10:00:00	AAPL	Stock	4.8568	4.8754	4.8357	4.8454	156159668.0
2007-09-11 11:00:00	AAPL	Stock	4.8454	4.8629	4.8229	4.8454	106282988.0
2007-09-11 12:00:00	AAPL	Stock	4.8461	4.8571	4.8261	4.8561	76580280.0
2007-09-11 13:00:00	AAPL	Stock	4.8568	4.8661	4.8404	4.8507	66908772.0
2007-09-11 14:00:00	AAPL	Stock	4.85	4.8655	4.8379	4.8464	98170296.0
2007-09-11 15:00:00	AAPL	Stock	4.8461	4.855	4.7768	4.8389	201697440.0
2007-09-11 16:00:00	AAPL	Stock	4.8389	4.8389	4.8384	4.8389	6589632.0
2007-09-11 09:00:00	MSFT	Stock	28.63	28.77	28.58	28.74	3088296.0
2007-09-11 10:00:00	MSFT	Stock	28.74	28.95	28.7	28.84	5154582.0
2007-09-11 11:00:00	MSFT	Stock	28.83	28.91	28.76	28.78	3050726.0
2007-09-11 12:00:00	MSFT	Stock	28.79	28.88	28.76	28.86	2272556.0
2007-09-11 13:00:00	MSFT	Stock	28.87	28.95	28.83	28.91	2923118.0
2007-09-11 14:00:00	MSFT	Stock	28.92	28.95	28.83	28.88	4343950.0
2007-09-11 15:00:00	MSFT	Stock	28.89	28.95	28.81	28.95	6996049.0
2007-09-11 16:00:00	MSFT	Stock	28.95	28.95	28.93	28.93	1443432.0
2007-09-11 07:00:00	NVDA	Stock	0.85	0.85	0.85	0.85	20000.0
2007-09-11 08:00:00	NVDA	Stock	0.8622	0.8625	0.8538	0.8612	670640.0
2007-09-11 09:00:00	NVDA	Stock	0.8552	0.8655	0.8478	0.8538	43388920.0
2007-09-11 10:00:00	NVDA	Stock	0.854	0.865	0.8512	0.8638	60508520.0
2007-09-11 11:00:00	NVDA	Stock	0.864	0.869	0.8628	0.867	57980840.0
2007-09-11 12:00:00	NVDA	Stock	0.8672	0.871	0.8632	0.866	52605640.0
2007-09-11 13:00:00	NVDA	Stock	0.866	0.8688	0.8615	0.865	51338760.0
2007-09-11 14:00:00	NVDA	Stock	0.865	0.8695	0.863	0.864	37585920.0
2007-09-11 15:00:00	NVDA	Stock	0.864	0.8665	0.8562	0.8645	68732320.0
2007-09-11 16:00:00	NVDA	Stock	0.8645	0.8645	0.8612	0.8615	8015560.0
2007-09-11 17:00:00	NVDA	Stock	0.8645	0.8645	0.8635	0.8645	1324000.0
2007-09-11 18:00:00	NVDA	Stock	0.8645	0.8658	0.8612	0.8648	57160.0
2007-09-11 19:00:00	NVDA	Stock	0.8612	0.8612	0.8612	0.8612	20000.0
2007-09-11 07:00:00	AMZN	Stock	4.21	4.215	4.21	4.215	12000.0
2007-09-11 08:00:00	AMZN	Stock	4.204	4.21	4.2	4.2015	398660.0
2007-09-11 09:00:00	AMZN	Stock	4.201	4.2145	4.1765	4.195	11504800.0
2007-09-11 10:00:00	AMZN	Stock	4.195	4.26	4.189	4.2385	19830560.0
2007-09-11 11:00:00	AMZN	Stock	4.238	4.2596	4.2255	4.242	12980560.0
2007-09-11 12:00:00	AMZN	Stock	4.2405	4.2805	4.231	4.2735	16852140.0
2007-09-11 13:00:00	AMZN	Stock	4.273	4.3	4.2575	4.287	14283500.0
2007-09-11 14:00:00	AMZN	Stock	4.287	4.3305	4.287	4.2989	25146040.0
2007-09-11 15:00:00	AMZN	Stock	4.3	4.319	4.2825	4.3185	28704820.0
2007-09-11 16:00:00	AMZN	Stock	4.318	4.318	4.31	4.3105	2694540.0
2007-09-11 17:00:00	AMZN	Stock	4.314	4.314	4.3065	4.311	85200.0
2007-09-11 18:00:00	AMZN	Stock	4.309	4.3115	4.307	4.311	16000.0
2007-09-11 19:00:00	AMZN	Stock	4.3075	4.309	4.3065	4.3065	15760.0
2007-09-11 09:00:00	TLT	Stock	90.88	90.88	90.7	90.81	1111100.0
2007-09-11 10:00:00	TLT	Stock	90.82	91.03	90.8	90.96	480000.0
2007-09-11 11:00:00	TLT	Stock	90.95	91.22	90.91	91.17	700000.0
2007-09-11 12:00:00	TLT	Stock	91.19	91.27	91.09	91.1	476500.0
2007-09-11 13:00:00	TLT	Stock	91.11	91.12	90.89	90.93	112700.0
2007-09-11 14:00:00	TLT	Stock	90.92	90.92	90.79	90.89	379339.0
2007-09-11 15:00:00	TLT	Stock	90.88	90.94	90.85	90.9	533000.0
2007-09-11 16:00:00	TLT	Stock	90.89	90.93	90.88	90.93	35500.0

> showing 50 of 37,229 rows — these rows as CSV

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