PREVIEW / stock_1hour / 2007-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-30.parquet
  size:    744 KB
  rows:    37,018
  symbols: 3,089

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-08-30 09:00:00	AAPL	Stock	4.7357	4.8982	4.725	4.8871	233033528.0
2007-08-30 10:00:00	AAPL	Stock	4.8857	4.9318	4.8571	4.9218	306283852.0
2007-08-30 11:00:00	AAPL	Stock	4.9218	4.9375	4.8986	4.9004	145530140.0
2007-08-30 12:00:00	AAPL	Stock	4.8999	4.9161	4.8596	4.9075	148644748.0
2007-08-30 13:00:00	AAPL	Stock	4.9071	4.9146	4.8732	4.8975	83050604.0
2007-08-30 14:00:00	AAPL	Stock	4.8982	4.9018	4.8071	4.8357	191627912.0
2007-08-30 15:00:00	AAPL	Stock	4.835	4.8796	4.8321	4.8668	192896284.0
2007-08-30 16:00:00	AAPL	Stock	4.8668	4.8671	4.8639	4.8661	10856804.0
2007-08-30 09:00:00	MSFT	Stock	28.42	28.5	28.32	28.42	2230105.0
2007-08-30 10:00:00	MSFT	Stock	28.42	28.77	28.4	28.69	4528406.0
2007-08-30 11:00:00	MSFT	Stock	28.69	28.93	28.67	28.852	3244548.0
2007-08-30 12:00:00	MSFT	Stock	28.85	28.86	28.63	28.75	3449908.0
2007-08-30 13:00:00	MSFT	Stock	28.74	28.8	28.56	28.62	2663596.0
2007-08-30 14:00:00	MSFT	Stock	28.61	28.68	28.33	28.38	4228033.0
2007-08-30 15:00:00	MSFT	Stock	28.38	28.57	28.36	28.45	6158993.0
2007-08-30 16:00:00	MSFT	Stock	28.45	28.45	28.45	28.45	1458526.0
2007-08-30 08:00:00	NVDA	Stock	0.8092	0.81	0.807	0.807	335940.0
2007-08-30 09:00:00	NVDA	Stock	0.8063	0.825	0.806	0.822	70141200.0
2007-08-30 10:00:00	NVDA	Stock	0.8218	0.8315	0.8187	0.8213	91893360.0
2007-08-30 11:00:00	NVDA	Stock	0.8215	0.8263	0.8208	0.8227	40415520.0
2007-08-30 12:00:00	NVDA	Stock	0.8225	0.8235	0.8113	0.8223	57189060.0
2007-08-30 13:00:00	NVDA	Stock	0.822	0.8222	0.815	0.8195	38076240.0
2007-08-30 14:00:00	NVDA	Stock	0.8197	0.8205	0.8078	0.8103	61978920.0
2007-08-30 15:00:00	NVDA	Stock	0.8103	0.8176	0.8085	0.8113	72886860.0
2007-08-30 16:00:00	NVDA	Stock	0.8113	0.8115	0.8113	0.8113	132000.0
2007-08-30 17:00:00	NVDA	Stock	0.8142	0.8143	0.8108	0.8113	147600.0
2007-08-30 18:00:00	NVDA	Stock	0.8115	0.8148	0.8115	0.8148	36000.0
2007-08-30 19:00:00	NVDA	Stock	0.8115	0.8115	0.8108	0.8108	154800.0
2007-08-30 07:00:00	AMZN	Stock	3.9275	3.9275	3.9275	3.9275	4000.0
2007-08-30 08:00:00	AMZN	Stock	3.935	3.9375	3.928	3.933	146020.0
2007-08-30 09:00:00	AMZN	Stock	3.9325	3.95	3.915	3.9275	9978520.0
2007-08-30 10:00:00	AMZN	Stock	3.926	4.0055	3.922	3.9945	15851060.0
2007-08-30 11:00:00	AMZN	Stock	3.995	4.002	3.985	3.9965	11067600.0
2007-08-30 12:00:00	AMZN	Stock	3.996	3.997	3.949	3.99	10421360.0
2007-08-30 13:00:00	AMZN	Stock	3.99	3.9925	3.9635	3.988	5429700.0
2007-08-30 14:00:00	AMZN	Stock	3.9885	3.993	3.9195	3.9225	12839080.0
2007-08-30 15:00:00	AMZN	Stock	3.9225	3.955	3.9225	3.934	16088240.0
2007-08-30 16:00:00	AMZN	Stock	3.934	3.9495	3.934	3.9375	3636980.0
2007-08-30 17:00:00	AMZN	Stock	3.9385	3.9395	3.9385	3.9385	10000.0
2007-08-30 18:00:00	AMZN	Stock	3.945	3.945	3.945	3.945	4000.0
2007-08-30 19:00:00	AMZN	Stock	3.9435	3.9435	3.9435	3.9435	2000.0
2007-08-30 09:00:00	TLT	Stock	88.61	88.63	88.47	88.52	210800.0
2007-08-30 10:00:00	TLT	Stock	88.52	88.85	88.49	88.84	244900.0
2007-08-30 11:00:00	TLT	Stock	88.85	88.88	88.76	88.81	255000.0
2007-08-30 12:00:00	TLT	Stock	88.81	88.88	88.75	88.84	129900.0
2007-08-30 13:00:00	TLT	Stock	88.84	88.92	88.78	88.78	176200.0
2007-08-30 14:00:00	TLT	Stock	88.78	88.94	88.75	88.93	256000.0
2007-08-30 15:00:00	TLT	Stock	88.93	88.96	88.79	88.8	446700.0
2007-08-30 16:00:00	TLT	Stock	88.8	88.81	88.79	88.81	17600.0
2007-08-30 09:00:00	CL	Stock	32.92	33.04	32.855	32.88	297000.0

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

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