PREVIEW / stock_1hour / 2005-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-04.parquet
  size:    555 KB
  rows:    26,200
  symbols: 1,969

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-05-04 08:00:00	AAPL	Stock	1.2964	1.2979	1.2911	1.2943	1329972.0
2005-05-04 09:00:00	AAPL	Stock	1.2936	1.3125	1.2889	1.3075	66474324.0
2005-05-04 10:00:00	AAPL	Stock	1.3071	1.3186	1.3043	1.3143	90406204.0
2005-05-04 11:00:00	AAPL	Stock	1.3139	1.3189	1.3118	1.3136	48983508.0
2005-05-04 12:00:00	AAPL	Stock	1.3136	1.3143	1.3089	1.3118	46063332.0
2005-05-04 13:00:00	AAPL	Stock	1.3118	1.3218	1.3111	1.3204	40285840.0
2005-05-04 14:00:00	AAPL	Stock	1.3204	1.3239	1.3175	1.3214	59810436.0
2005-05-04 15:00:00	AAPL	Stock	1.3214	1.3286	1.3179	1.3268	86196208.0
2005-05-04 16:00:00	AAPL	Stock	1.3254	1.3279	1.3211	1.325	1595356.0
2005-05-04 17:00:00	AAPL	Stock	1.3257	1.3279	1.3254	1.3264	8670900.0
2005-05-04 18:00:00	AAPL	Stock	1.3268	1.3268	1.3261	1.3261	40012.0
2005-05-04 08:00:00	MSFT	Stock	25.35	25.47	25.34	25.38	23922.0
2005-05-04 09:00:00	MSFT	Stock	25.36	25.4	25.22	25.27	7475461.0
2005-05-04 10:00:00	MSFT	Stock	25.26	25.33	25.12	25.22	20354512.0
2005-05-04 11:00:00	MSFT	Stock	25.22	25.26	25.16	25.18	11037079.0
2005-05-04 12:00:00	MSFT	Stock	25.18	25.2	25.11	25.17	9128327.0
2005-05-04 13:00:00	MSFT	Stock	25.18	25.25	25.13	25.24	5211330.0
2005-05-04 14:00:00	MSFT	Stock	25.24	25.26	25.15	25.21	8794757.0
2005-05-04 15:00:00	MSFT	Stock	25.21	25.31	25.16	25.24	15191696.0
2005-05-04 16:00:00	MSFT	Stock	25.23	25.3	25.21	25.27	7027300.0
2005-05-04 17:00:00	MSFT	Stock	25.27	25.27	25.21	25.25	158500.0
2005-05-04 18:00:00	MSFT	Stock	25.25	25.26	25.21	25.26	19807.0
2005-05-04 09:00:00	NVDA	Stock	0.1816	0.1853	0.1813	0.1826	77486400.0
2005-05-04 10:00:00	NVDA	Stock	0.1826	0.1833	0.1817	0.182	99317040.0
2005-05-04 11:00:00	NVDA	Stock	0.1819	0.1832	0.1819	0.1831	43976880.0
2005-05-04 12:00:00	NVDA	Stock	0.1831	0.1832	0.1823	0.1831	17453400.0
2005-05-04 13:00:00	NVDA	Stock	0.183	0.1852	0.1829	0.1846	20931600.0
2005-05-04 14:00:00	NVDA	Stock	0.1846	0.1867	0.1842	0.1865	47676120.0
2005-05-04 15:00:00	NVDA	Stock	0.1865	0.1882	0.1853	0.1868	125785920.0
2005-05-04 16:00:00	NVDA	Stock	0.1868	0.1869	0.1859	0.1859	970560.0
2005-05-04 17:00:00	NVDA	Stock	0.1858	0.1858	0.1858	0.1858	120000.0
2005-05-04 18:00:00	NVDA	Stock	0.1858	0.1863	0.1858	0.1863	180000.0
2005-05-04 08:00:00	AMZN	Stock	1.66	1.66	1.651	1.651	24000.0
2005-05-04 09:00:00	AMZN	Stock	1.67	1.6865	1.6635	1.686	12450880.0
2005-05-04 10:00:00	AMZN	Stock	1.6855	1.6955	1.6805	1.6935	31587660.0
2005-05-04 11:00:00	AMZN	Stock	1.6935	1.6975	1.692	1.6935	19006140.0
2005-05-04 12:00:00	AMZN	Stock	1.6935	1.697	1.691	1.6955	11720580.0
2005-05-04 13:00:00	AMZN	Stock	1.6951	1.6985	1.694	1.698	16594000.0
2005-05-04 14:00:00	AMZN	Stock	1.698	1.703	1.6955	1.6995	16576780.0
2005-05-04 15:00:00	AMZN	Stock	1.6985	1.706	1.695	1.7	43989760.0
2005-05-04 16:00:00	AMZN	Stock	1.6995	1.6995	1.696	1.698	745120.0
2005-05-04 17:00:00	AMZN	Stock	1.698	1.698	1.696	1.698	259600.0
2005-05-04 18:00:00	AMZN	Stock	1.696	1.696	1.696	1.696	30000.0
2005-05-04 09:00:00	CL	Stock	24.995	25.0475	24.945	24.965	360000.0
2005-05-04 10:00:00	CL	Stock	24.965	25.01	24.905	24.96	593600.0
2005-05-04 11:00:00	CL	Stock	24.955	24.99	24.895	24.895	577200.0
2005-05-04 12:00:00	CL	Stock	24.885	24.975	24.83	24.975	403600.0
2005-05-04 13:00:00	CL	Stock	24.97	25.015	24.94	25.0	588000.0
2005-05-04 14:00:00	CL	Stock	25.0	25.02	24.955	25.015	691400.0
2005-05-04 15:00:00	CL	Stock	25.015	25.045	24.985	25.0	848200.0

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

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