PREVIEW / stock_1hour / 2005-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-14.parquet
  size:    527 KB
  rows:    24,710
  symbols: 1,915

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-01-14 08:00:00	AAPL	Stock	1.2545	1.2605	1.2461	1.2591	7838376.0
2005-01-14 09:00:00	AAPL	Stock	1.2591	1.2604	1.2355	1.2434	278592664.0
2005-01-14 10:00:00	AAPL	Stock	1.2436	1.2777	1.2393	1.27	381654616.0
2005-01-14 11:00:00	AAPL	Stock	1.27	1.2807	1.2645	1.2688	214646208.0
2005-01-14 12:00:00	AAPL	Stock	1.2684	1.2716	1.2559	1.2584	164840648.0
2005-01-14 13:00:00	AAPL	Stock	1.2588	1.2807	1.2477	1.2502	293364512.0
2005-01-14 14:00:00	AAPL	Stock	1.25	1.2746	1.248	1.252	221972968.0
2005-01-14 15:00:00	AAPL	Stock	1.252	1.2554	1.2448	1.2536	165915456.0
2005-01-14 16:00:00	AAPL	Stock	1.2527	1.2539	1.2505	1.2527	5878208.0
2005-01-14 17:00:00	AAPL	Stock	1.2518	1.2536	1.2518	1.2527	409080.0
2005-01-14 18:00:00	AAPL	Stock	1.2525	1.2536	1.2525	1.2536	307048.0
2005-01-14 08:00:00	MSFT	Stock	26.34	26.43	26.3	26.41	74429.0
2005-01-14 09:00:00	MSFT	Stock	26.41	27.0	26.09	26.17	12607280.0
2005-01-14 10:00:00	MSFT	Stock	26.18	26.32	26.08	26.23	15255638.0
2005-01-14 11:00:00	MSFT	Stock	26.23	26.32	26.19	26.2	10392876.0
2005-01-14 12:00:00	MSFT	Stock	26.201	26.28	26.14	26.14	7265727.0
2005-01-14 13:00:00	MSFT	Stock	26.14	26.45	26.1	26.16	6927400.0
2005-01-14 14:00:00	MSFT	Stock	26.16	26.32	26.13	26.17	21962028.0
2005-01-14 15:00:00	MSFT	Stock	26.16	26.17	26.04	26.13	14558868.0
2005-01-14 16:00:00	MSFT	Stock	26.13	26.13	26.05	26.13	1653803.0
2005-01-14 17:00:00	MSFT	Stock	26.1	26.13	26.09	26.09	54268.0
2005-01-14 18:00:00	MSFT	Stock	26.09	26.12	26.09	26.12	4190.0
2005-01-14 08:00:00	NVDA	Stock	0.1822	0.1825	0.1809	0.1814	3276000.0
2005-01-14 09:00:00	NVDA	Stock	0.1814	0.1824	0.179	0.1802	72979920.0
2005-01-14 10:00:00	NVDA	Stock	0.1801	0.1809	0.1779	0.1797	157876680.0
2005-01-14 11:00:00	NVDA	Stock	0.1797	0.18	0.1778	0.178	49279440.0
2005-01-14 12:00:00	NVDA	Stock	0.178	0.1792	0.1779	0.178	50618040.0
2005-01-14 13:00:00	NVDA	Stock	0.178	0.1824	0.1775	0.1783	42656880.0
2005-01-14 14:00:00	NVDA	Stock	0.1783	0.1818	0.178	0.1792	108931320.0
2005-01-14 15:00:00	NVDA	Stock	0.1792	0.1798	0.1788	0.179	72457200.0
2005-01-14 16:00:00	NVDA	Stock	0.1792	0.1798	0.179	0.179	1167240.0
2005-01-14 17:00:00	NVDA	Stock	0.1792	0.1792	0.1777	0.1777	123600.0
2005-01-14 08:00:00	AMZN	Stock	2.1375	2.1495	2.135	2.1495	158000.0
2005-01-14 09:00:00	AMZN	Stock	2.1475	2.173	2.1385	2.16	29647900.0
2005-01-14 10:00:00	AMZN	Stock	2.1615	2.186	2.1465	2.1725	34193200.0
2005-01-14 11:00:00	AMZN	Stock	2.1725	2.1735	2.1515	2.1635	19296760.0
2005-01-14 12:00:00	AMZN	Stock	2.163	2.1765	2.16	2.1695	11646520.0
2005-01-14 13:00:00	AMZN	Stock	2.1695	2.186	2.16	2.1695	27142300.0
2005-01-14 14:00:00	AMZN	Stock	2.169	2.219	2.167	2.1966	46903840.0
2005-01-14 15:00:00	AMZN	Stock	2.197	2.233	2.196	2.2275	74427080.0
2005-01-14 16:00:00	AMZN	Stock	2.227	2.233	2.181	2.233	2433500.0
2005-01-14 17:00:00	AMZN	Stock	2.235	2.2355	2.2255	2.229	76380.0
2005-01-14 09:00:00	CL	Stock	24.95	25.01	24.805	24.835	384800.0
2005-01-14 10:00:00	CL	Stock	24.835	24.94	24.76	24.87	482400.0
2005-01-14 11:00:00	CL	Stock	24.875	24.88	24.805	24.825	432200.0
2005-01-14 12:00:00	CL	Stock	24.82	24.95	24.815	24.907	387600.0
2005-01-14 13:00:00	CL	Stock	24.91	24.975	24.905	24.97	486200.0
2005-01-14 14:00:00	CL	Stock	24.965	25.03	24.955	25.0	330800.0
2005-01-14 15:00:00	CL	Stock	24.995	25.05	24.955	25.015	566800.0
2005-01-14 16:00:00	CL	Stock	25.02	25.04	25.02	25.04	8400.0

> showing 50 of 24,710 rows — these rows as CSV

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