PREVIEW / stock_1hour / 2005-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-02.parquet
  size:    590 KB
  rows:    27,912
  symbols: 2,104

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-11-02 08:00:00	AAPL	Stock	2.0614	2.0614	2.0521	2.0546	623056.0
2005-11-02 09:00:00	AAPL	Stock	2.0571	2.0982	2.0521	2.095	102834564.0
2005-11-02 10:00:00	AAPL	Stock	2.0949	2.1289	2.0893	2.1246	222629512.0
2005-11-02 11:00:00	AAPL	Stock	2.1243	2.1393	2.1186	2.1279	147417648.0
2005-11-02 12:00:00	AAPL	Stock	2.1271	2.1429	2.1221	2.1371	91150556.0
2005-11-02 13:00:00	AAPL	Stock	2.1371	2.1386	2.1225	2.1368	66660748.0
2005-11-02 14:00:00	AAPL	Stock	2.1368	2.1421	2.1289	2.1346	89553744.0
2005-11-02 15:00:00	AAPL	Stock	2.1346	2.1429	2.1307	2.1411	123615772.0
2005-11-02 16:00:00	AAPL	Stock	2.1414	2.1464	2.1393	2.1432	4514160.0
2005-11-02 17:00:00	AAPL	Stock	2.1432	2.1446	2.1375	2.1429	7141484.0
2005-11-02 18:00:00	AAPL	Stock	2.145	2.1454	2.14	2.1446	367920.0
2005-11-02 08:00:00	MSFT	Stock	26.03	26.1	25.87	25.91	11066.0
2005-11-02 09:00:00	MSFT	Stock	25.93	26.18	25.9	26.14	7980922.0
2005-11-02 10:00:00	MSFT	Stock	26.14	26.25	26.12	26.23	9812476.0
2005-11-02 11:00:00	MSFT	Stock	26.23	26.42	26.21	26.38	15793548.0
2005-11-02 12:00:00	MSFT	Stock	26.38	26.48	26.32	26.42	10056283.0
2005-11-02 13:00:00	MSFT	Stock	26.42	26.48	26.38	26.46	5886452.0
2005-11-02 14:00:00	MSFT	Stock	26.46	26.5	26.37	26.41	8973259.0
2005-11-02 15:00:00	MSFT	Stock	26.42	26.5	26.39	26.45	13748537.0
2005-11-02 16:00:00	MSFT	Stock	26.44	26.48	26.13	26.44	534084.0
2005-11-02 17:00:00	MSFT	Stock	26.41	26.46	26.41	26.43	322610.0
2005-11-02 18:00:00	MSFT	Stock	26.44	26.46	26.43	26.46	24398.0
2005-11-02 09:00:00	NVDA	Stock	0.2763	0.2787	0.275	0.277	48730080.0
2005-11-02 10:00:00	NVDA	Stock	0.2769	0.2822	0.2768	0.2815	62691720.0
2005-11-02 11:00:00	NVDA	Stock	0.2816	0.2844	0.2815	0.2837	36243000.0
2005-11-02 12:00:00	NVDA	Stock	0.2837	0.2852	0.2826	0.2847	25257360.0
2005-11-02 13:00:00	NVDA	Stock	0.2848	0.2869	0.2845	0.2862	46064880.0
2005-11-02 14:00:00	NVDA	Stock	0.286	0.2872	0.2846	0.2853	54929400.0
2005-11-02 15:00:00	NVDA	Stock	0.2853	0.2925	0.2853	0.2921	213243240.0
2005-11-02 16:00:00	NVDA	Stock	0.2918	0.3082	0.2912	0.2917	9141960.0
2005-11-02 17:00:00	NVDA	Stock	0.2917	0.2922	0.2912	0.2917	102019800.0
2005-11-02 18:00:00	NVDA	Stock	0.2921	0.2921	0.2908	0.2908	48600.0
2005-11-02 08:00:00	AMZN	Stock	2.014	2.017	2.014	2.0165	34000.0
2005-11-02 09:00:00	AMZN	Stock	2.0165	2.018	1.993	1.999	10479660.0
2005-11-02 10:00:00	AMZN	Stock	1.998	2.027	1.99	2.0265	15034280.0
2005-11-02 11:00:00	AMZN	Stock	2.0265	2.0475	2.02	2.0425	15401260.0
2005-11-02 12:00:00	AMZN	Stock	2.0416	2.055	2.0415	2.048	15671400.0
2005-11-02 13:00:00	AMZN	Stock	2.048	2.0615	2.0445	2.055	10062300.0
2005-11-02 14:00:00	AMZN	Stock	2.055	2.0575	2.0435	2.0445	9657960.0
2005-11-02 15:00:00	AMZN	Stock	2.0445	2.0515	2.037	2.037	16292100.0
2005-11-02 16:00:00	AMZN	Stock	2.0375	2.0425	2.034	2.037	264820.0
2005-11-02 17:00:00	AMZN	Stock	2.0375	2.04	2.0375	2.0375	2904100.0
2005-11-02 18:00:00	AMZN	Stock	2.04	2.04	2.0395	2.0395	13000.0
2005-11-02 08:00:00	CL	Stock	26.18	26.18	26.18	26.18	10000.0
2005-11-02 09:00:00	CL	Stock	26.235	26.395	26.2	26.305	665400.0
2005-11-02 10:00:00	CL	Stock	26.325	26.405	26.22	26.24	643600.0
2005-11-02 11:00:00	CL	Stock	26.245	26.32	26.1205	26.205	554000.0
2005-11-02 12:00:00	CL	Stock	26.205	26.245	26.115	26.21	402400.0
2005-11-02 13:00:00	CL	Stock	26.22	26.235	26.11	26.11	390200.0
2005-11-02 14:00:00	CL	Stock	26.105	26.145	26.015	26.025	575600.0

> showing 50 of 27,912 rows — these rows as CSV

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