PREVIEW / stock_1hour / 2007-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-31.parquet
  size:    780 KB
  rows:    38,042
  symbols: 3,012

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-31 09:00:00	AAPL	Stock	4.2882	4.3125	4.2729	4.2864	221660096.0
2007-05-31 10:00:00	AAPL	Stock	4.2857	4.2993	4.2693	4.2832	195104056.0
2007-05-31 11:00:00	AAPL	Stock	4.2829	4.3029	4.2718	4.2979	115282776.0
2007-05-31 12:00:00	AAPL	Stock	4.2979	4.3632	4.2911	4.3445	218924496.0
2007-05-31 13:00:00	AAPL	Stock	4.3443	4.3554	4.3043	4.3256	150479980.0
2007-05-31 14:00:00	AAPL	Stock	4.325	4.3579	4.3225	4.3393	126606704.0
2007-05-31 15:00:00	AAPL	Stock	4.3396	4.3454	4.3	4.3336	191249156.0
2007-05-31 16:00:00	AAPL	Stock	4.3346	4.3414	4.3282	4.3282	37493036.0
2007-05-31 09:00:00	MSFT	Stock	31.12	31.16	30.96	30.96	6524388.0
2007-05-31 10:00:00	MSFT	Stock	30.96	31.03	30.87	30.89	7688678.0
2007-05-31 11:00:00	MSFT	Stock	30.9	30.91	30.78	30.85	5124606.0
2007-05-31 12:00:00	MSFT	Stock	30.86	30.9	30.82	30.87	5194018.0
2007-05-31 13:00:00	MSFT	Stock	30.87	30.87	30.64	30.67	8665823.0
2007-05-31 14:00:00	MSFT	Stock	30.67	30.79	30.66	30.74	6183467.0
2007-05-31 15:00:00	MSFT	Stock	30.75	30.91	30.61	30.68	16185416.0
2007-05-31 16:00:00	MSFT	Stock	30.68	30.72	30.67	30.69	9820404.0
2007-05-31 08:00:00	NVDA	Stock	0.5723	0.5723	0.5687	0.5687	70500.0
2007-05-31 09:00:00	NVDA	Stock	0.5703	0.5773	0.5698	0.5765	42660960.0
2007-05-31 10:00:00	NVDA	Stock	0.5765	0.5808	0.574	0.5808	80340900.0
2007-05-31 11:00:00	NVDA	Stock	0.5808	0.5808	0.5777	0.578	64018860.0
2007-05-31 12:00:00	NVDA	Stock	0.578	0.5783	0.574	0.5758	48188100.0
2007-05-31 13:00:00	NVDA	Stock	0.5758	0.5775	0.5733	0.5753	53595060.0
2007-05-31 14:00:00	NVDA	Stock	0.5753	0.5775	0.575	0.5755	49582560.0
2007-05-31 15:00:00	NVDA	Stock	0.5755	0.5782	0.5752	0.5772	100303200.0
2007-05-31 16:00:00	NVDA	Stock	0.5778	0.58	0.5772	0.58	1258380.0
2007-05-31 17:00:00	NVDA	Stock	0.5773	0.5773	0.5773	0.5773	93032760.0
2007-05-31 18:00:00	NVDA	Stock	0.5773	0.5798	0.5773	0.5798	200020980.0
2007-05-31 19:00:00	NVDA	Stock	0.58	0.58	0.5792	0.5792	35580.0
2007-05-31 06:00:00	AMZN	Stock	3.5425	3.5425	3.5425	3.5425	2000.0
2007-05-31 07:00:00	AMZN	Stock	3.518	3.5375	3.518	3.5375	12000.0
2007-05-31 08:00:00	AMZN	Stock	3.52	3.533	3.506	3.5175	576000.0
2007-05-31 09:00:00	AMZN	Stock	3.5165	3.537	3.4705	3.4885	34746320.0
2007-05-31 10:00:00	AMZN	Stock	3.4895	3.495	3.4625	3.4735	29884740.0
2007-05-31 11:00:00	AMZN	Stock	3.4735	3.48	3.465	3.475	21463540.0
2007-05-31 12:00:00	AMZN	Stock	3.4745	3.481	3.4685	3.4735	18066240.0
2007-05-31 13:00:00	AMZN	Stock	3.4735	3.475	3.4285	3.444	26498540.0
2007-05-31 14:00:00	AMZN	Stock	3.4435	3.4685	3.4415	3.4605	20487020.0
2007-05-31 15:00:00	AMZN	Stock	3.46	3.4695	3.444	3.4545	26604120.0
2007-05-31 16:00:00	AMZN	Stock	3.457	3.4635	3.4536	3.457	4631620.0
2007-05-31 17:00:00	AMZN	Stock	3.4605	3.464	3.457	3.464	49000.0
2007-05-31 18:00:00	AMZN	Stock	3.464	3.4695	3.4605	3.4695	78320.0
2007-05-31 19:00:00	AMZN	Stock	3.461	3.461	3.4575	3.4575	54920.0
2007-05-31 09:00:00	TLT	Stock	86.56	86.58	86.26	86.27	214900.0
2007-05-31 10:00:00	TLT	Stock	86.26	86.26	86.04	86.14	397400.0
2007-05-31 11:00:00	TLT	Stock	86.15	86.31	86.15	86.22	356500.0
2007-05-31 12:00:00	TLT	Stock	86.22	86.26	86.19	86.22	37900.0
2007-05-31 13:00:00	TLT	Stock	86.24	86.32	86.2	86.3	159300.0
2007-05-31 14:00:00	TLT	Stock	86.28	86.47	86.28	86.46	183700.0
2007-05-31 15:00:00	TLT	Stock	86.46	86.49	86.37	86.37	333200.0
2007-05-31 16:00:00	TLT	Stock	86.38	86.38	86.38	86.38	1300.0

> showing 50 of 38,042 rows — these rows as CSV

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