PREVIEW / stock_1hour / 2006-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-28.parquet
  size:    657 KB
  rows:    31,728
  symbols: 2,484

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
2006-12-28 04:00:00	AAPL	Stock	2.8282	2.8282	2.8282	2.8282	5600.0
2006-12-28 06:00:00	AAPL	Stock	2.8143	2.8268	2.8143	2.8143	587636.0
2006-12-28 07:00:00	AAPL	Stock	2.8161	2.8321	2.7579	2.825	11364752.0
2006-12-28 08:00:00	AAPL	Stock	2.8236	2.8618	2.8125	2.8557	35712180.0
2006-12-28 09:00:00	AAPL	Stock	2.8554	2.8864	2.8446	2.8614	225278284.0
2006-12-28 10:00:00	AAPL	Stock	2.8611	2.8786	2.8579	2.8668	199603432.0
2006-12-28 11:00:00	AAPL	Stock	2.8668	2.8668	2.8468	2.8536	164973396.0
2006-12-28 12:00:00	AAPL	Stock	2.8536	2.8693	2.8507	2.8635	97053460.0
2006-12-28 13:00:00	AAPL	Stock	2.8636	2.8661	2.8561	2.8621	62492696.0
2006-12-28 14:00:00	AAPL	Stock	2.8618	2.8857	2.8614	2.8818	127806000.0
2006-12-28 15:00:00	AAPL	Stock	2.8818	2.9018	2.8814	2.8884	187683944.0
2006-12-28 16:00:00	AAPL	Stock	2.8868	2.8921	2.8861	2.8871	2549176.0
2006-12-28 17:00:00	AAPL	Stock	2.8882	2.89	2.8846	2.8857	309400.0
2006-12-28 18:00:00	AAPL	Stock	2.8879	2.8879	2.8839	2.8857	561036.0
2006-12-28 19:00:00	AAPL	Stock	2.8843	2.8921	2.8839	2.8921	506184.0
2006-12-28 07:00:00	MSFT	Stock	29.84	29.84	29.84	29.84	300.0
2006-12-28 08:00:00	MSFT	Stock	29.9	29.93	29.9	29.93	3200.0
2006-12-28 09:00:00	MSFT	Stock	29.9	29.96	29.81	29.925	3077217.0
2006-12-28 10:00:00	MSFT	Stock	29.93	29.99	29.9	29.91	3456779.0
2006-12-28 11:00:00	MSFT	Stock	29.91	30.01	29.9	29.909	2134296.0
2006-12-28 12:00:00	MSFT	Stock	29.9	29.96	29.86	29.91	3011653.0
2006-12-28 13:00:00	MSFT	Stock	29.91	29.94	29.91	29.91	1340398.0
2006-12-28 14:00:00	MSFT	Stock	29.912	30.02	29.9	30.0	3520098.0
2006-12-28 15:00:00	MSFT	Stock	30.0	30.03	29.89	29.98	5665245.0
2006-12-28 16:00:00	MSFT	Stock	29.96	29.98	29.91	29.98	197966.0
2006-12-28 17:00:00	MSFT	Stock	29.98	29.98	29.97	29.98	8100.0
2006-12-28 18:00:00	MSFT	Stock	29.977	29.977	29.97	29.97	1961.0
2006-12-28 19:00:00	MSFT	Stock	29.96	29.96	29.93	29.96	1778.0
2006-12-28 08:00:00	NVDA	Stock	0.6252	0.6252	0.6248	0.6248	36000.0
2006-12-28 09:00:00	NVDA	Stock	0.6242	0.6258	0.6185	0.6213	23273220.0
2006-12-28 10:00:00	NVDA	Stock	0.6213	0.6265	0.6178	0.619	45965340.0
2006-12-28 11:00:00	NVDA	Stock	0.619	0.6225	0.6188	0.6212	25374540.0
2006-12-28 12:00:00	NVDA	Stock	0.6213	0.625	0.6213	0.6232	19544760.0
2006-12-28 13:00:00	NVDA	Stock	0.6232	0.6243	0.623	0.6238	13284480.0
2006-12-28 14:00:00	NVDA	Stock	0.6237	0.6262	0.6225	0.6233	24701760.0
2006-12-28 15:00:00	NVDA	Stock	0.6233	0.6242	0.6198	0.6207	52048080.0
2006-12-28 16:00:00	NVDA	Stock	0.6205	0.6205	0.6192	0.6197	531660.0
2006-12-28 17:00:00	NVDA	Stock	0.62	0.6212	0.62	0.6212	102000.0
2006-12-28 18:00:00	NVDA	Stock	0.6212	0.6213	0.6212	0.6213	135000.0
2006-12-28 09:00:00	AMZN	Stock	2.0135	2.0315	2.009	2.0175	14067620.0
2006-12-28 10:00:00	AMZN	Stock	2.018	2.027	2.004	2.005	19176420.0
2006-12-28 11:00:00	AMZN	Stock	2.005	2.006	1.996	1.9975	9477940.0
2006-12-28 12:00:00	AMZN	Stock	1.9975	2.004	1.996	2.0035	12127700.0
2006-12-28 13:00:00	AMZN	Stock	2.003	2.009	1.9985	2.0	8870780.0
2006-12-28 14:00:00	AMZN	Stock	2.0005	2.012	2.0	2.0105	8907600.0
2006-12-28 15:00:00	AMZN	Stock	2.011	2.016	2.009	2.0095	14297400.0
2006-12-28 16:00:00	AMZN	Stock	2.009	2.0135	2.008	2.008	334180.0
2006-12-28 17:00:00	AMZN	Stock	2.008	2.008	2.008	2.008	2000.0
2006-12-28 18:00:00	AMZN	Stock	2.008	2.008	2.008	2.008	5300.0
2006-12-28 09:00:00	CL	Stock	32.615	32.72	32.54	32.72	217200.0

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

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