PREVIEW / stock_1hour / 2007-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-27.parquet
  size:    825 KB
  rows:    41,231
  symbols: 3,260

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-27 04:00:00	AAPL	Stock	7.0982	7.0982	7.0982	7.0982	2800.0
2007-12-27 07:00:00	AAPL	Stock	7.1179	7.1429	7.1179	7.1268	305312.0
2007-12-27 08:00:00	AAPL	Stock	7.1268	7.1475	7.0804	7.1204	5376056.0
2007-12-27 09:00:00	AAPL	Stock	7.1204	7.1757	7.0896	7.1404	105961744.0
2007-12-27 10:00:00	AAPL	Stock	7.1407	7.2486	7.1393	7.1918	189918988.0
2007-12-27 11:00:00	AAPL	Stock	7.1925	7.2143	7.1561	7.2129	96443228.0
2007-12-27 12:00:00	AAPL	Stock	7.2129	7.2168	7.1664	7.1893	63612276.0
2007-12-27 13:00:00	AAPL	Stock	7.1893	7.2114	7.1625	7.2029	52581452.0
2007-12-27 14:00:00	AAPL	Stock	7.2018	7.2321	7.1679	7.1707	85757224.0
2007-12-27 15:00:00	AAPL	Stock	7.1711	7.1854	7.0643	7.1061	180394956.0
2007-12-27 16:00:00	AAPL	Stock	7.0961	7.2038	7.0793	7.0943	14193592.0
2007-12-27 17:00:00	AAPL	Stock	7.0964	7.1021	7.0893	7.0996	442792.0
2007-12-27 18:00:00	AAPL	Stock	7.0982	7.1071	7.0918	7.1025	388332.0
2007-12-27 19:00:00	AAPL	Stock	7.1064	7.1071	7.0982	7.0982	389340.0
2007-12-27 07:00:00	MSFT	Stock	36.79	36.79	36.5	36.5	1200.0
2007-12-27 08:00:00	MSFT	Stock	36.52	36.55	36.32	36.38	9010.0
2007-12-27 09:00:00	MSFT	Stock	36.44	36.52	36.29	36.5	2829127.0
2007-12-27 10:00:00	MSFT	Stock	36.51	36.55	36.29	36.31	4122165.0
2007-12-27 11:00:00	MSFT	Stock	36.32	36.44	36.24	36.44	3183849.0
2007-12-27 12:00:00	MSFT	Stock	36.44	36.45	36.27	36.31	3730515.0
2007-12-27 13:00:00	MSFT	Stock	36.31	36.39	36.24	36.27	2959867.0
2007-12-27 14:00:00	MSFT	Stock	36.27	36.36	36.25	36.27	3183456.0
2007-12-27 15:00:00	MSFT	Stock	36.27	36.31	35.94	36.05	10197471.0
2007-12-27 16:00:00	MSFT	Stock	36.03	36.344	35.95	35.97	4035971.0
2007-12-27 17:00:00	MSFT	Stock	35.97	36.0	35.97	36.0	5155.0
2007-12-27 18:00:00	MSFT	Stock	35.97	36.04	35.97	36.04	3858.0
2007-12-27 19:00:00	MSFT	Stock	36.03	36.05	36.01	36.01	3900.0
2007-12-27 07:00:00	NVDA	Stock	0.91	0.91	0.91	0.91	8000.0
2007-12-27 08:00:00	NVDA	Stock	0.9062	0.9062	0.9025	0.9025	384000.0
2007-12-27 09:00:00	NVDA	Stock	0.9035	0.91	0.8978	0.9	31580320.0
2007-12-27 10:00:00	NVDA	Stock	0.9	0.907	0.887	0.8918	38980320.0
2007-12-27 11:00:00	NVDA	Stock	0.8922	0.8932	0.885	0.8895	23929680.0
2007-12-27 12:00:00	NVDA	Stock	0.8895	0.8895	0.88	0.8835	23937080.0
2007-12-27 13:00:00	NVDA	Stock	0.8835	0.8868	0.8808	0.8845	20662800.0
2007-12-27 14:00:00	NVDA	Stock	0.8848	0.8875	0.8822	0.8848	23693080.0
2007-12-27 15:00:00	NVDA	Stock	0.8848	0.8873	0.8762	0.8785	54318920.0
2007-12-27 16:00:00	NVDA	Stock	0.8785	0.8891	0.8785	0.8788	23873280.0
2007-12-27 18:00:00	NVDA	Stock	0.8785	0.8792	0.8785	0.8792	172840.0
2007-12-27 19:00:00	NVDA	Stock	0.8792	0.8792	0.8792	0.8792	6960.0
2007-12-27 08:00:00	AMZN	Stock	4.67	4.67	4.625	4.638	214640.0
2007-12-27 09:00:00	AMZN	Stock	4.632	4.665	4.625	4.6345	8659340.0
2007-12-27 10:00:00	AMZN	Stock	4.6345	4.7495	4.6335	4.7095	31265840.0
2007-12-27 11:00:00	AMZN	Stock	4.7095	4.732	4.6875	4.723	16477840.0
2007-12-27 12:00:00	AMZN	Stock	4.7215	4.73	4.683	4.7065	16589100.0
2007-12-27 13:00:00	AMZN	Stock	4.707	4.7225	4.698	4.704	14190500.0
2007-12-27 14:00:00	AMZN	Stock	4.705	4.7645	4.703	4.746	20813820.0
2007-12-27 15:00:00	AMZN	Stock	4.747	4.7605	4.695	4.7125	31838320.0
2007-12-27 16:00:00	AMZN	Stock	4.7125	4.7245	4.7	4.7125	2195240.0
2007-12-27 17:00:00	AMZN	Stock	4.713	4.713	4.7125	4.7125	16500.0
2007-12-27 18:00:00	AMZN	Stock	4.7125	4.714	4.711	4.711	40040.0

> showing 50 of 41,231 rows — these rows as CSV

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