PREVIEW / stock_1hour / 2005-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-02.parquet
  size:    556 KB
  rows:    26,548
  symbols: 1,984

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
2005-06-02 08:00:00	AAPL	Stock	1.4421	1.4421	1.4204	1.4329	3599792.0
2005-06-02 09:00:00	AAPL	Stock	1.4314	1.4404	1.4143	1.4339	94249652.0
2005-06-02 10:00:00	AAPL	Stock	1.4339	1.4375	1.4225	1.4271	76773844.0
2005-06-02 11:00:00	AAPL	Stock	1.4271	1.4304	1.4243	1.4264	28465416.0
2005-06-02 12:00:00	AAPL	Stock	1.4264	1.4325	1.4232	1.4236	36751932.0
2005-06-02 13:00:00	AAPL	Stock	1.4236	1.4268	1.4189	1.4243	35278012.0
2005-06-02 14:00:00	AAPL	Stock	1.4239	1.4318	1.4236	1.4286	40169948.0
2005-06-02 15:00:00	AAPL	Stock	1.4282	1.4314	1.4261	1.4304	46613364.0
2005-06-02 16:00:00	AAPL	Stock	1.43	1.4318	1.4293	1.4304	2354268.0
2005-06-02 17:00:00	AAPL	Stock	1.4307	1.4329	1.4307	1.4329	211680.0
2005-06-02 07:00:00	MSFT	Stock	25.83	25.83	25.83	25.83	519.0
2005-06-02 08:00:00	MSFT	Stock	25.83	25.83	25.75	25.76	25281.0
2005-06-02 09:00:00	MSFT	Stock	25.79	25.86	25.66	25.79	4021460.0
2005-06-02 10:00:00	MSFT	Stock	25.78	25.84	25.64	25.79	5435238.0
2005-06-02 11:00:00	MSFT	Stock	25.8	25.85	25.74	25.78	3861994.0
2005-06-02 12:00:00	MSFT	Stock	25.78	25.8	25.76	25.77	1991429.0
2005-06-02 13:00:00	MSFT	Stock	25.76	25.79	25.709	25.75	2969617.0
2005-06-02 14:00:00	MSFT	Stock	25.76	25.77	25.73	25.75	3246083.0
2005-06-02 15:00:00	MSFT	Stock	25.74	25.78	25.71	25.78	4477275.0
2005-06-02 16:00:00	MSFT	Stock	25.75	25.8	25.71	25.79	201645.0
2005-06-02 17:00:00	MSFT	Stock	25.8	25.8	25.78	25.79	30030.0
2005-06-02 18:00:00	MSFT	Stock	25.764	25.79	25.764	25.79	2910.0
2005-06-02 09:00:00	NVDA	Stock	0.2275	0.2321	0.2271	0.2309	49571640.0
2005-06-02 10:00:00	NVDA	Stock	0.2309	0.2321	0.2303	0.2319	97363440.0
2005-06-02 11:00:00	NVDA	Stock	0.2319	0.2332	0.2315	0.2331	87465000.0
2005-06-02 12:00:00	NVDA	Stock	0.2331	0.2341	0.2322	0.2324	91932360.0
2005-06-02 13:00:00	NVDA	Stock	0.2324	0.234	0.2322	0.234	90524520.0
2005-06-02 14:00:00	NVDA	Stock	0.234	0.2357	0.2339	0.2354	92499240.0
2005-06-02 15:00:00	NVDA	Stock	0.2354	0.2364	0.2352	0.2364	118207080.0
2005-06-02 16:00:00	NVDA	Stock	0.2364	0.2369	0.2361	0.2369	1689840.0
2005-06-02 17:00:00	NVDA	Stock	0.2369	0.2371	0.236	0.236	572400.0
2005-06-02 18:00:00	NVDA	Stock	0.2371	0.2371	0.2371	0.2371	228000.0
2005-06-02 08:00:00	AMZN	Stock	1.8195	1.825	1.8195	1.825	833000.0
2005-06-02 09:00:00	AMZN	Stock	1.816	1.8456	1.813	1.83	18401300.0
2005-06-02 10:00:00	AMZN	Stock	1.83	1.833	1.8105	1.819	20483180.0
2005-06-02 11:00:00	AMZN	Stock	1.819	1.8255	1.816	1.8245	9345980.0
2005-06-02 12:00:00	AMZN	Stock	1.8245	1.8255	1.8225	1.824	4296840.0
2005-06-02 13:00:00	AMZN	Stock	1.824	1.825	1.8125	1.8175	9162380.0
2005-06-02 14:00:00	AMZN	Stock	1.8175	1.8185	1.8125	1.8175	11425480.0
2005-06-02 15:00:00	AMZN	Stock	1.8175	1.822	1.8145	1.82	15264040.0
2005-06-02 16:00:00	AMZN	Stock	1.8195	1.8255	1.819	1.8205	1797540.0
2005-06-02 17:00:00	AMZN	Stock	1.8195	1.8195	1.8195	1.8195	6000.0
2005-06-02 09:00:00	CL	Stock	25.0	25.07	24.93	24.97	352400.0
2005-06-02 10:00:00	CL	Stock	24.97	25.0	24.895	24.915	375200.0
2005-06-02 11:00:00	CL	Stock	24.915	25.01	24.875	24.905	415400.0
2005-06-02 12:00:00	CL	Stock	24.905	24.95	24.86	24.88	435200.0
2005-06-02 13:00:00	CL	Stock	24.875	24.915	24.795	24.8	308600.0
2005-06-02 14:00:00	CL	Stock	24.8	24.87	24.79	24.84	424800.0
2005-06-02 15:00:00	CL	Stock	24.835	24.85	24.76	24.805	789000.0
2005-06-02 16:00:00	CL	Stock	24.805	24.805	24.805	24.805	19000.0

> showing 50 of 26,548 rows — these rows as CSV

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