PREVIEW / stock_1hour / 2007-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-02.parquet
  size:    798 KB
  rows:    39,444
  symbols: 3,114

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-10-02 05:00:00	AAPL	Stock	5.6018	5.6018	5.6018	5.6018	15400.0
2007-10-02 06:00:00	AAPL	Stock	5.6018	5.6154	5.6018	5.6154	11872.0
2007-10-02 07:00:00	AAPL	Stock	5.6018	5.6189	5.5929	5.6054	272300.0
2007-10-02 08:00:00	AAPL	Stock	5.6071	5.615	5.5736	5.5861	5734848.0
2007-10-02 09:00:00	AAPL	Stock	5.5864	5.6325	5.5761	5.6118	117983572.0
2007-10-02 10:00:00	AAPL	Stock	5.6111	5.6639	5.5893	5.5964	192146024.0
2007-10-02 11:00:00	AAPL	Stock	5.5961	5.6104	5.5675	5.6071	117627132.0
2007-10-02 12:00:00	AAPL	Stock	5.6071	5.6086	5.5779	5.5971	51617636.0
2007-10-02 13:00:00	AAPL	Stock	5.5968	5.6357	5.5868	5.6239	68519388.0
2007-10-02 14:00:00	AAPL	Stock	5.6239	5.6468	5.6118	5.6393	96097456.0
2007-10-02 15:00:00	AAPL	Stock	5.6396	5.6607	5.615	5.6593	120382388.0
2007-10-02 16:00:00	AAPL	Stock	5.6588	5.66	5.6061	5.655	10562496.0
2007-10-02 17:00:00	AAPL	Stock	5.6546	5.6589	5.6504	5.6589	10192392.0
2007-10-02 18:00:00	AAPL	Stock	5.6546	5.6589	5.6418	5.6554	573468.0
2007-10-02 19:00:00	AAPL	Stock	5.6554	5.6554	5.6464	5.6511	366604.0
2007-10-02 07:00:00	MSFT	Stock	29.73	29.78	29.73	29.78	3500.0
2007-10-02 08:00:00	MSFT	Stock	29.77	29.8	29.71	29.77	8825.0
2007-10-02 09:00:00	MSFT	Stock	29.74	29.82	29.58	29.601	3163953.0
2007-10-02 10:00:00	MSFT	Stock	29.6	29.72	29.57	29.67	4872750.0
2007-10-02 11:00:00	MSFT	Stock	29.66	29.85	29.61	29.84	4922149.0
2007-10-02 12:00:00	MSFT	Stock	29.84	29.85	29.71	29.76	3003345.0
2007-10-02 13:00:00	MSFT	Stock	29.761	29.82	29.69	29.765	4070716.0
2007-10-02 14:00:00	MSFT	Stock	29.77	29.8	29.65	29.657	3844217.0
2007-10-02 15:00:00	MSFT	Stock	29.657	29.71	29.59	29.7	7253110.0
2007-10-02 16:00:00	MSFT	Stock	29.7	29.809	29.673	29.708	1307733.0
2007-10-02 17:00:00	MSFT	Stock	29.7	29.762	29.67	29.7	1250520.0
2007-10-02 18:00:00	MSFT	Stock	29.69	29.789	29.69	29.7	1800.0
2007-10-02 19:00:00	MSFT	Stock	29.71	29.77	29.7	29.7	3204.0
2007-10-02 08:00:00	NVDA	Stock	0.9488	0.9525	0.9425	0.9425	1030960.0
2007-10-02 09:00:00	NVDA	Stock	0.9425	0.9443	0.9345	0.9358	41522520.0
2007-10-02 10:00:00	NVDA	Stock	0.9358	0.9368	0.9215	0.9288	68998720.0
2007-10-02 11:00:00	NVDA	Stock	0.9288	0.932	0.9235	0.9318	26146560.0
2007-10-02 12:00:00	NVDA	Stock	0.9318	0.9345	0.9293	0.9345	25221800.0
2007-10-02 13:00:00	NVDA	Stock	0.9344	0.9368	0.9295	0.9358	29808640.0
2007-10-02 14:00:00	NVDA	Stock	0.9355	0.9375	0.9328	0.936	27445520.0
2007-10-02 15:00:00	NVDA	Stock	0.936	0.9363	0.9318	0.9352	52811960.0
2007-10-02 16:00:00	NVDA	Stock	0.9352	0.9369	0.9218	0.9238	11886880.0
2007-10-02 17:00:00	NVDA	Stock	0.9258	0.9262	0.925	0.925	88000.0
2007-10-02 18:00:00	NVDA	Stock	0.9358	0.9358	0.9238	0.9238	171000.0
2007-10-02 19:00:00	NVDA	Stock	0.9238	0.925	0.9238	0.9238	128000.0
2007-10-02 06:00:00	AMZN	Stock	4.65	4.69	4.65	4.69	6000.0
2007-10-02 08:00:00	AMZN	Stock	4.6685	4.686	4.666	4.6775	162000.0
2007-10-02 09:00:00	AMZN	Stock	4.673	4.6955	4.62	4.6298	14551380.0
2007-10-02 10:00:00	AMZN	Stock	4.6295	4.661	4.6125	4.6235	14725140.0
2007-10-02 11:00:00	AMZN	Stock	4.6215	4.6268	4.57	4.5965	14906580.0
2007-10-02 12:00:00	AMZN	Stock	4.5965	4.6165	4.5825	4.6085	8585080.0
2007-10-02 13:00:00	AMZN	Stock	4.6085	4.6115	4.5944	4.6064	10170240.0
2007-10-02 14:00:00	AMZN	Stock	4.6065	4.61	4.5915	4.605	11267820.0
2007-10-02 15:00:00	AMZN	Stock	4.605	4.622	4.597	4.618	21100200.0
2007-10-02 16:00:00	AMZN	Stock	4.616	4.692	4.6027	4.6146	690460.0

> showing 50 of 39,444 rows — these rows as CSV

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