PREVIEW / stock_1hour / 2005-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-07.parquet
  size:    556 KB
  rows:    25,896
  symbols: 1,908

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-07 08:00:00	AAPL	Stock	1.1539	1.1638	1.1539	1.1586	3092824.0
2005-01-07 09:00:00	AAPL	Stock	1.1582	1.1827	1.1546	1.1782	263341344.0
2005-01-07 10:00:00	AAPL	Stock	1.1786	1.183	1.1704	1.1795	306256328.0
2005-01-07 11:00:00	AAPL	Stock	1.1795	1.2229	1.1786	1.2184	483253848.0
2005-01-07 12:00:00	AAPL	Stock	1.2184	1.2366	1.2118	1.2289	348292840.0
2005-01-07 13:00:00	AAPL	Stock	1.2291	1.2393	1.2188	1.2384	294867720.0
2005-01-07 14:00:00	AAPL	Stock	1.2384	1.2434	1.2289	1.2375	268051784.0
2005-01-07 15:00:00	AAPL	Stock	1.2373	1.2402	1.2286	1.2364	243603360.0
2005-01-07 16:00:00	AAPL	Stock	1.2363	1.2393	1.2071	1.2384	10110184.0
2005-01-07 17:00:00	AAPL	Stock	1.238	1.2411	1.238	1.2404	8781080.0
2005-01-07 18:00:00	AAPL	Stock	1.2411	1.2411	1.2395	1.2402	257600.0
2005-01-07 08:00:00	MSFT	Stock	26.68	26.93	26.68	26.86	109912.0
2005-01-07 09:00:00	MSFT	Stock	26.85	26.89	26.77	26.82	7580007.0
2005-01-07 10:00:00	MSFT	Stock	26.82	26.89	26.62	26.72	16154643.0
2005-01-07 11:00:00	MSFT	Stock	26.72	26.8	26.69	26.75	9230535.0
2005-01-07 12:00:00	MSFT	Stock	26.75	26.85	26.71	26.77	6615795.0
2005-01-07 13:00:00	MSFT	Stock	26.76	26.83	26.75	26.77	4400200.0
2005-01-07 14:00:00	MSFT	Stock	26.76	26.8	26.68	26.76	9668516.0
2005-01-07 15:00:00	MSFT	Stock	26.76	26.79	26.65	26.67	10860040.0
2005-01-07 16:00:00	MSFT	Stock	26.67	26.806	26.64	26.68	1781080.0
2005-01-07 17:00:00	MSFT	Stock	26.68	26.69	26.66	26.69	18350.0
2005-01-07 18:00:00	MSFT	Stock	26.68	26.69	26.68	26.69	4756.0
2005-01-07 08:00:00	NVDA	Stock	0.1875	0.1894	0.1875	0.1883	696000.0
2005-01-07 09:00:00	NVDA	Stock	0.1883	0.189	0.1868	0.1873	62012040.0
2005-01-07 10:00:00	NVDA	Stock	0.1873	0.1881	0.1808	0.1825	205426200.0
2005-01-07 11:00:00	NVDA	Stock	0.1826	0.1871	0.1826	0.1861	100573440.0
2005-01-07 12:00:00	NVDA	Stock	0.1861	0.188	0.185	0.1875	62925240.0
2005-01-07 13:00:00	NVDA	Stock	0.1876	0.1888	0.1871	0.1871	70104840.0
2005-01-07 14:00:00	NVDA	Stock	0.187	0.1879	0.1852	0.1864	54334200.0
2005-01-07 15:00:00	NVDA	Stock	0.1864	0.1871	0.1829	0.1841	198164640.0
2005-01-07 16:00:00	NVDA	Stock	0.1843	0.1846	0.1836	0.1836	2432640.0
2005-01-07 08:00:00	AMZN	Stock	2.06	2.075	2.06	2.075	222400.0
2005-01-07 09:00:00	AMZN	Stock	2.0745	2.075	2.0525	2.075	19408600.0
2005-01-07 10:00:00	AMZN	Stock	2.074	2.0925	2.06	2.077	45628800.0
2005-01-07 11:00:00	AMZN	Stock	2.0775	2.094	2.071	2.094	24913520.0
2005-01-07 12:00:00	AMZN	Stock	2.094	2.132	2.089	2.116	33072900.0
2005-01-07 13:00:00	AMZN	Stock	2.1165	2.122	2.1105	2.118	13129340.0
2005-01-07 14:00:00	AMZN	Stock	2.118	2.128	2.113	2.127	18991500.0
2005-01-07 15:00:00	AMZN	Stock	2.1275	2.1345	2.112	2.118	36613740.0
2005-01-07 16:00:00	AMZN	Stock	2.118	2.12	2.116	2.12	1135720.0
2005-01-07 17:00:00	AMZN	Stock	2.1162	2.13	2.1162	2.1295	320640.0
2005-01-07 18:00:00	AMZN	Stock	2.0665	2.129	2.0665	2.129	224000.0
2005-01-07 09:00:00	CL	Stock	24.865	24.875	24.675	24.875	277200.0
2005-01-07 10:00:00	CL	Stock	24.87	25.14	24.86	25.085	733400.0
2005-01-07 11:00:00	CL	Stock	25.085	25.175	25.06	25.095	655200.0
2005-01-07 12:00:00	CL	Stock	25.095	25.095	25.0	25.05	260400.0
2005-01-07 13:00:00	CL	Stock	25.05	25.1	25.01	25.075	411600.0
2005-01-07 14:00:00	CL	Stock	25.075	25.095	25.0065	25.04	248600.0
2005-01-07 15:00:00	CL	Stock	25.035	25.075	24.985	25.04	719200.0
2005-01-07 16:00:00	CL	Stock	25.04	25.04	25.04	25.04	15000.0

> showing 50 of 25,896 rows — these rows as CSV

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