PREVIEW / stock_1hour / 2007-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-28.parquet
  size:    873 KB
  rows:    43,891
  symbols: 3,263

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-12-28 05:00:00	AAPL	Stock	7.14	7.14	7.14	7.14	2800.0
2007-12-28 07:00:00	AAPL	Stock	7.1607	7.1779	7.1446	7.1707	1073520.0
2007-12-28 08:00:00	AAPL	Stock	7.1679	7.1875	7.1429	7.15	5537308.0
2007-12-28 09:00:00	AAPL	Stock	7.1546	7.1986	7.1443	7.1739	93602404.0
2007-12-28 10:00:00	AAPL	Stock	7.1743	7.1825	7.1268	7.1407	118028736.0
2007-12-28 11:00:00	AAPL	Stock	7.1418	7.1636	7.1204	7.1411	67110092.0
2007-12-28 12:00:00	AAPL	Stock	7.1407	7.1454	7.0539	7.0604	95783212.0
2007-12-28 13:00:00	AAPL	Stock	7.0612	7.1221	7.0314	7.1175	103504632.0
2007-12-28 14:00:00	AAPL	Stock	7.1175	7.1375	7.0893	7.1107	83890352.0
2007-12-28 15:00:00	AAPL	Stock	7.1107	7.1414	7.0761	7.135	104026468.0
2007-12-28 16:00:00	AAPL	Stock	7.1382	7.1398	7.1136	7.1361	19986008.0
2007-12-28 17:00:00	AAPL	Stock	7.1368	7.1621	7.0918	7.1414	767396.0
2007-12-28 18:00:00	AAPL	Stock	7.1396	7.1432	7.1264	7.1429	6260632.0
2007-12-28 19:00:00	AAPL	Stock	7.1393	7.1432	7.1393	7.1429	251244.0
2007-12-28 08:00:00	MSFT	Stock	36.1	36.16	35.97	36.15	234673.0
2007-12-28 09:00:00	MSFT	Stock	36.15	36.19	36.0	36.07	3054545.0
2007-12-28 10:00:00	MSFT	Stock	36.07	36.16	35.968	36.062	4072215.0
2007-12-28 11:00:00	MSFT	Stock	36.07	36.08	35.97	36.06	2877500.0
2007-12-28 12:00:00	MSFT	Stock	36.06	36.07	35.69	35.71	4085185.0
2007-12-28 13:00:00	MSFT	Stock	35.72	36.13	35.67	36.12	4201440.0
2007-12-28 14:00:00	MSFT	Stock	36.113	36.23	36.02	36.03	4371853.0
2007-12-28 15:00:00	MSFT	Stock	36.027	36.14	35.92	36.1	8216830.0
2007-12-28 16:00:00	MSFT	Stock	36.11	36.12	35.907	35.976	1686508.0
2007-12-28 17:00:00	MSFT	Stock	36.059	36.09	36.022	36.022	84733.0
2007-12-28 18:00:00	MSFT	Stock	36.022	36.12	36.022	36.12	596295.0
2007-12-28 19:00:00	MSFT	Stock	36.1	36.1	36.09	36.09	545.0
2007-12-28 08:00:00	NVDA	Stock	0.8802	0.8865	0.8752	0.8838	220000.0
2007-12-28 09:00:00	NVDA	Stock	0.8825	0.8875	0.8682	0.8748	34706200.0
2007-12-28 10:00:00	NVDA	Stock	0.8748	0.8805	0.8658	0.875	38694120.0
2007-12-28 11:00:00	NVDA	Stock	0.875	0.8762	0.866	0.8662	31969760.0
2007-12-28 12:00:00	NVDA	Stock	0.8662	0.8712	0.8628	0.863	29812080.0
2007-12-28 13:00:00	NVDA	Stock	0.863	0.8722	0.8622	0.8718	22809680.0
2007-12-28 14:00:00	NVDA	Stock	0.8718	0.8748	0.8668	0.8685	26124440.0
2007-12-28 15:00:00	NVDA	Stock	0.8688	0.872	0.8665	0.8698	46781760.0
2007-12-28 16:00:00	NVDA	Stock	0.8698	0.8711	0.8652	0.8698	21287720.0
2007-12-28 17:00:00	NVDA	Stock	0.8785	0.8785	0.8785	0.8785	668840.0
2007-12-28 18:00:00	NVDA	Stock	0.871	0.871	0.8688	0.8698	4623800.0
2007-12-28 19:00:00	NVDA	Stock	0.8695	0.8695	0.8695	0.8695	88880.0
2007-12-28 07:00:00	AMZN	Stock	4.728	4.728	4.725	4.725	14060.0
2007-12-28 08:00:00	AMZN	Stock	4.755	4.7685	4.75	4.7525	387440.0
2007-12-28 09:00:00	AMZN	Stock	4.764	4.795	4.7375	4.795	22426480.0
2007-12-28 10:00:00	AMZN	Stock	4.793	4.7945	4.743	4.7595	20877420.0
2007-12-28 11:00:00	AMZN	Stock	4.7602	4.7665	4.723	4.7305	15938940.0
2007-12-28 12:00:00	AMZN	Stock	4.7305	4.7335	4.6265	4.6465	26586560.0
2007-12-28 13:00:00	AMZN	Stock	4.6475	4.727	4.605	4.7235	22724180.0
2007-12-28 14:00:00	AMZN	Stock	4.7225	4.7515	4.701	4.7205	18844820.0
2007-12-28 15:00:00	AMZN	Stock	4.721	4.733	4.7025	4.719	20545540.0
2007-12-28 16:00:00	AMZN	Stock	4.721	4.7276	4.708	4.7225	2289940.0
2007-12-28 17:00:00	AMZN	Stock	4.72	4.7635	4.72	4.7276	331020.0
2007-12-28 18:00:00	AMZN	Stock	4.7276	4.7276	4.7225	4.7225	984640.0

> showing 50 of 43,891 rows — these rows as CSV

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