PREVIEW / stock_1hour / 2007-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-18.parquet
  size:    759 KB
  rows:    37,365
  symbols: 3,000

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-05-18 09:00:00	AAPL	Stock	3.9368	3.9482	3.9239	3.9389	152926928.0
2007-05-18 10:00:00	AAPL	Stock	3.9393	3.9514	3.9261	3.9279	127981252.0
2007-05-18 11:00:00	AAPL	Stock	3.9279	3.9325	3.9221	3.9282	58495752.0
2007-05-18 12:00:00	AAPL	Stock	3.9282	3.9375	3.9204	3.9314	60556076.0
2007-05-18 13:00:00	AAPL	Stock	3.9318	3.935	3.9264	3.9314	33603276.0
2007-05-18 14:00:00	AAPL	Stock	3.9314	3.9343	3.9225	3.9278	60065824.0
2007-05-18 15:00:00	AAPL	Stock	3.9275	3.9325	3.9221	3.9293	76584144.0
2007-05-18 16:00:00	AAPL	Stock	3.9293	3.9293	3.9279	3.9293	7091280.0
2007-05-18 09:00:00	MSFT	Stock	30.97	30.99	30.58	30.63	14580995.0
2007-05-18 10:00:00	MSFT	Stock	30.63	30.76	30.59	30.719	7402297.0
2007-05-18 11:00:00	MSFT	Stock	30.71	30.736	30.62	30.63	4005755.0
2007-05-18 12:00:00	MSFT	Stock	30.63	30.74	30.6	30.73	4887473.0
2007-05-18 13:00:00	MSFT	Stock	30.72	30.79	30.69	30.7	3324181.0
2007-05-18 14:00:00	MSFT	Stock	30.71	30.73	30.61	30.64	5150429.0
2007-05-18 15:00:00	MSFT	Stock	30.64	30.84	30.62	30.84	9479489.0
2007-05-18 16:00:00	MSFT	Stock	30.83	30.83	30.83	30.83	2060926.0
2007-05-18 08:00:00	NVDA	Stock	0.5763	0.5767	0.5757	0.5767	468900.0
2007-05-18 09:00:00	NVDA	Stock	0.5767	0.578	0.5725	0.578	79001400.0
2007-05-18 10:00:00	NVDA	Stock	0.578	0.5792	0.5723	0.5732	86931660.0
2007-05-18 11:00:00	NVDA	Stock	0.5728	0.5775	0.5718	0.5774	53784960.0
2007-05-18 12:00:00	NVDA	Stock	0.5773	0.583	0.5773	0.5817	71821080.0
2007-05-18 13:00:00	NVDA	Stock	0.5816	0.585	0.5815	0.5847	75963720.0
2007-05-18 14:00:00	NVDA	Stock	0.5848	0.5853	0.5808	0.5828	71712120.0
2007-05-18 15:00:00	NVDA	Stock	0.5828	0.5847	0.5803	0.584	123005220.0
2007-05-18 16:00:00	NVDA	Stock	0.584	0.584	0.5827	0.5833	26974620.0
2007-05-18 17:00:00	NVDA	Stock	0.5785	0.5785	0.5785	0.5785	192000.0
2007-05-18 18:00:00	NVDA	Stock	0.5828	0.5837	0.5828	0.5837	102000.0
2007-05-18 19:00:00	NVDA	Stock	0.5837	0.5838	0.5837	0.5838	72000.0
2007-05-18 07:00:00	AMZN	Stock	3.1155	3.1155	3.1155	3.1155	2000.0
2007-05-18 08:00:00	AMZN	Stock	3.1205	3.1275	3.1195	3.1275	268600.0
2007-05-18 09:00:00	AMZN	Stock	3.129	3.129	3.1165	3.124	24042080.0
2007-05-18 10:00:00	AMZN	Stock	3.1245	3.14	3.114	3.123	39667240.0
2007-05-18 11:00:00	AMZN	Stock	3.1235	3.127	3.118	3.1215	18450320.0
2007-05-18 12:00:00	AMZN	Stock	3.1215	3.144	3.12	3.136	18660800.0
2007-05-18 13:00:00	AMZN	Stock	3.1365	3.148	3.135	3.142	18246680.0
2007-05-18 14:00:00	AMZN	Stock	3.142	3.145	3.1335	3.137	23607500.0
2007-05-18 15:00:00	AMZN	Stock	3.137	3.165	3.1345	3.163	41492400.0
2007-05-18 16:00:00	AMZN	Stock	3.165	3.1665	3.1282	3.1635	6684820.0
2007-05-18 17:00:00	AMZN	Stock	3.1635	3.1655	3.1302	3.1302	264000.0
2007-05-18 18:00:00	AMZN	Stock	3.163	3.165	3.1435	3.1435	591120.0
2007-05-18 19:00:00	AMZN	Stock	3.1435	3.149	3.1435	3.1485	381000.0
2007-05-18 09:00:00	TLT	Stock	87.35	87.36	87.16	87.35	93400.0
2007-05-18 10:00:00	TLT	Stock	87.36	87.5	87.3	87.34	52300.0
2007-05-18 11:00:00	TLT	Stock	87.34	87.4	87.34	87.36	49200.0
2007-05-18 12:00:00	TLT	Stock	87.36	87.36	87.25	87.27	54900.0
2007-05-18 13:00:00	TLT	Stock	87.26	87.3	87.07	87.09	158234.0
2007-05-18 14:00:00	TLT	Stock	87.1	87.1	86.88	87.01	199100.0
2007-05-18 15:00:00	TLT	Stock	87.0	87.01	86.92	86.99	247200.0
2007-05-18 16:00:00	TLT	Stock	86.99	86.99	86.93	86.93	1100.0
2007-05-18 09:00:00	CL	Stock	33.745	33.75	33.61	33.68	931800.0

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

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