PREVIEW / stock_1hour / 2004-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-03.parquet
  size:    503 KB
  rows:    23,200
  symbols: 1,721

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
2004-02-03 08:00:00	AAPL	Stock	0.3964	0.3964	0.3964	0.3964	56000.0
2004-02-03 09:00:00	AAPL	Stock	0.3964	0.4	0.3946	0.3961	19699960.0
2004-02-03 10:00:00	AAPL	Stock	0.3961	0.3982	0.3929	0.3946	42915768.0
2004-02-03 11:00:00	AAPL	Stock	0.3948	0.3964	0.3943	0.3957	21055664.0
2004-02-03 12:00:00	AAPL	Stock	0.3959	0.3982	0.3952	0.3982	19960864.0
2004-02-03 13:00:00	AAPL	Stock	0.3982	0.3988	0.3961	0.3982	13752480.0
2004-02-03 14:00:00	AAPL	Stock	0.398	0.3985	0.3948	0.3973	22826440.0
2004-02-03 15:00:00	AAPL	Stock	0.3971	0.3984	0.3946	0.398	31234224.0
2004-02-03 16:00:00	AAPL	Stock	0.3977	0.3982	0.3941	0.398	1352400.0
2004-02-03 17:00:00	AAPL	Stock	0.3946	0.398	0.3911	0.3911	1613360.0
2004-02-03 18:00:00	AAPL	Stock	0.3961	0.3961	0.3961	0.3961	806960.0
2004-02-03 08:00:00	MSFT	Stock	27.3	27.45	27.3	27.4	217550.0
2004-02-03 09:00:00	MSFT	Stock	27.4	27.55	27.36	27.45	6682074.0
2004-02-03 10:00:00	MSFT	Stock	27.45	27.53	27.3	27.4	8282380.0
2004-02-03 11:00:00	MSFT	Stock	27.39	27.44	27.3	27.32	5297284.0
2004-02-03 12:00:00	MSFT	Stock	27.32	27.41	27.31	27.36	3808214.0
2004-02-03 13:00:00	MSFT	Stock	27.36	27.4	27.26	27.3	4052340.0
2004-02-03 14:00:00	MSFT	Stock	27.3	27.33	27.18	27.23	8416088.0
2004-02-03 15:00:00	MSFT	Stock	27.22	27.32	27.21	27.28	8907312.0
2004-02-03 16:00:00	MSFT	Stock	27.32	27.36	27.15	27.16	559187.0
2004-02-03 17:00:00	MSFT	Stock	27.17	27.31	27.1	27.13	235700.0
2004-02-03 18:00:00	MSFT	Stock	27.13	27.354	27.11	27.11	110380.0
2004-02-03 08:00:00	NVDA	Stock	0.1888	0.1888	0.1888	0.1888	324000.0
2004-02-03 09:00:00	NVDA	Stock	0.1886	0.1904	0.1865	0.189	73593120.0
2004-02-03 10:00:00	NVDA	Stock	0.1889	0.1907	0.1887	0.1904	62602440.0
2004-02-03 11:00:00	NVDA	Stock	0.1905	0.191	0.1888	0.1892	51541080.0
2004-02-03 12:00:00	NVDA	Stock	0.1892	0.1912	0.1888	0.1906	32376720.0
2004-02-03 13:00:00	NVDA	Stock	0.1907	0.1908	0.1892	0.1893	28395120.0
2004-02-03 14:00:00	NVDA	Stock	0.1892	0.1897	0.1852	0.1868	74742240.0
2004-02-03 15:00:00	NVDA	Stock	0.1868	0.1882	0.1867	0.1877	77931480.0
2004-02-03 16:00:00	NVDA	Stock	0.1877	0.1877	0.186	0.186	1195800.0
2004-02-03 17:00:00	NVDA	Stock	0.186	0.1877	0.186	0.1868	3745200.0
2004-02-03 18:00:00	NVDA	Stock	0.1868	0.1868	0.1868	0.1868	2868000.0
2004-02-03 08:00:00	AMZN	Stock	2.409	2.4135	2.405	2.405	119000.0
2004-02-03 09:00:00	AMZN	Stock	2.4075	2.414	2.355	2.376	43809260.0
2004-02-03 10:00:00	AMZN	Stock	2.3752	2.3752	2.3175	2.3445	76779880.0
2004-02-03 11:00:00	AMZN	Stock	2.346	2.358	2.3124	2.3145	50509760.0
2004-02-03 12:00:00	AMZN	Stock	2.3145	2.336	2.31	2.3335	31045000.0
2004-02-03 13:00:00	AMZN	Stock	2.3335	2.3385	2.251	2.2717	83880120.0
2004-02-03 14:00:00	AMZN	Stock	2.2725	2.2752	2.2345	2.245	100704560.0
2004-02-03 15:00:00	AMZN	Stock	2.2445	2.2705	2.226	2.2475	133512000.0
2004-02-03 16:00:00	AMZN	Stock	2.2495	2.2555	2.236	2.238	7350860.0
2004-02-03 17:00:00	AMZN	Stock	2.2375	2.2521	2.2325	2.235	12523440.0
2004-02-03 18:00:00	AMZN	Stock	2.235	2.236	2.233	2.233	40000.0
2004-02-03 09:00:00	CL	Stock	25.17	25.25	25.0	25.01	1984600.0
2004-02-03 10:00:00	CL	Stock	25.005	25.51	24.94	25.39	2016000.0
2004-02-03 11:00:00	CL	Stock	25.39	25.75	25.34	25.685	1529800.0
2004-02-03 12:00:00	CL	Stock	25.7	26.05	25.66	25.83	1573200.0
2004-02-03 13:00:00	CL	Stock	25.83	25.885	25.735	25.82	697400.0
2004-02-03 14:00:00	CL	Stock	25.82	25.94	25.77	25.89	1095800.0

> showing 50 of 23,200 rows — these rows as CSV

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