PREVIEW / stock_1hour / 2005-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-27.parquet
  size:    525 KB
  rows:    24,553
  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-27 08:00:00	AAPL	Stock	1.29	1.29	1.2861	1.2875	1141392.0
2005-01-27 09:00:00	AAPL	Stock	1.2886	1.2929	1.2777	1.2863	65084768.0
2005-01-27 10:00:00	AAPL	Stock	1.2866	1.2914	1.2813	1.2888	95952752.0
2005-01-27 11:00:00	AAPL	Stock	1.2889	1.3021	1.2871	1.2979	98882952.0
2005-01-27 12:00:00	AAPL	Stock	1.2979	1.3018	1.2918	1.2936	50768256.0
2005-01-27 13:00:00	AAPL	Stock	1.2936	1.2945	1.2884	1.2891	60617872.0
2005-01-27 14:00:00	AAPL	Stock	1.2891	1.2923	1.2875	1.2895	33118120.0
2005-01-27 15:00:00	AAPL	Stock	1.2893	1.2971	1.2873	1.2963	75283096.0
2005-01-27 16:00:00	AAPL	Stock	1.2966	1.2982	1.2929	1.2972	6656272.0
2005-01-27 17:00:00	AAPL	Stock	1.2973	1.2973	1.2955	1.2973	308000.0
2005-01-27 18:00:00	AAPL	Stock	1.2973	1.2973	1.2948	1.2955	166320.0
2005-01-27 08:00:00	MSFT	Stock	26.07	26.08	25.9	26.0	3061961.0
2005-01-27 09:00:00	MSFT	Stock	26.0	26.05	25.85	25.942	8803772.0
2005-01-27 10:00:00	MSFT	Stock	25.95	26.03	25.89	26.0	10899151.0
2005-01-27 11:00:00	MSFT	Stock	25.99	26.03	25.93	26.0	6676249.0
2005-01-27 12:00:00	MSFT	Stock	26.0	26.02	25.95	26.0	6410915.0
2005-01-27 13:00:00	MSFT	Stock	26.0	26.02	25.87	25.911	8424484.0
2005-01-27 14:00:00	MSFT	Stock	25.91	25.93	25.86	25.88	9473953.0
2005-01-27 15:00:00	MSFT	Stock	25.88	26.16	25.86	26.1	21602752.0
2005-01-27 16:00:00	MSFT	Stock	26.11	26.6	25.45	26.43	15671751.0
2005-01-27 17:00:00	MSFT	Stock	26.43	26.61	25.969	26.58	1209270.0
2005-01-27 18:00:00	MSFT	Stock	26.58	26.58	26.52	26.57	170811.0
2005-01-27 09:00:00	NVDA	Stock	0.1769	0.1804	0.176	0.18	82112280.0
2005-01-27 10:00:00	NVDA	Stock	0.18	0.1875	0.1799	0.1866	313684440.0
2005-01-27 11:00:00	NVDA	Stock	0.1866	0.1875	0.1854	0.1867	75879360.0
2005-01-27 12:00:00	NVDA	Stock	0.1866	0.187	0.1846	0.1865	58598760.0
2005-01-27 13:00:00	NVDA	Stock	0.1865	0.1871	0.1855	0.1862	87949560.0
2005-01-27 14:00:00	NVDA	Stock	0.1861	0.1886	0.186	0.1873	105823200.0
2005-01-27 15:00:00	NVDA	Stock	0.1873	0.1917	0.1872	0.1909	262109400.0
2005-01-27 16:00:00	NVDA	Stock	0.1909	0.1924	0.1907	0.1924	12094200.0
2005-01-27 17:00:00	NVDA	Stock	0.1924	0.1924	0.1908	0.191	1704480.0
2005-01-27 18:00:00	NVDA	Stock	0.1912	0.1912	0.1912	0.1912	24000.0
2005-01-27 09:00:00	AMZN	Stock	2.065	2.0765	2.057	2.065	14838660.0
2005-01-27 10:00:00	AMZN	Stock	2.063	2.0755	2.0606	2.0635	14645940.0
2005-01-27 11:00:00	AMZN	Stock	2.0635	2.105	2.0635	2.0985	25472540.0
2005-01-27 12:00:00	AMZN	Stock	2.0975	2.1015	2.0795	2.0835	11251500.0
2005-01-27 13:00:00	AMZN	Stock	2.0855	2.086	2.0695	2.08	15070500.0
2005-01-27 14:00:00	AMZN	Stock	2.08	2.0955	2.079	2.0875	14321200.0
2005-01-27 15:00:00	AMZN	Stock	2.0875	2.12	2.0855	2.1155	56940080.0
2005-01-27 16:00:00	AMZN	Stock	2.116	2.1165	2.1025	2.1156	6422140.0
2005-01-27 17:00:00	AMZN	Stock	2.1115	2.1125	2.107	2.1095	48860.0
2005-01-27 18:00:00	AMZN	Stock	2.1095	2.11	2.109	2.109	64000.0
2005-01-27 09:00:00	CL	Stock	25.25	25.985	25.25	25.715	2543600.0
2005-01-27 10:00:00	CL	Stock	25.69	26.015	25.64	26.0	2548800.0
2005-01-27 11:00:00	CL	Stock	26.025	26.325	25.97	26.0	2389000.0
2005-01-27 12:00:00	CL	Stock	25.995	26.315	25.98	26.295	1663600.0
2005-01-27 13:00:00	CL	Stock	26.3	26.32	26.21	26.315	1015800.0
2005-01-27 14:00:00	CL	Stock	26.32	26.425	26.29	26.405	1908600.0
2005-01-27 15:00:00	CL	Stock	26.41	26.46	26.32	26.37	2347000.0
2005-01-27 16:00:00	CL	Stock	26.35	26.35	26.3445	26.345	2600.0

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

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