PREVIEW / stock_1hour / 2001-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-10.parquet
  size:    316 KB
  rows:    16,173
  symbols: 1,253

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
2001-01-10 08:00:00	AAPL	Stock	0.3058	0.308	0.3036	0.3036	576800.0
2001-01-10 09:00:00	AAPL	Stock	0.3036	0.3036	0.2868	0.2913	102160800.0
2001-01-10 10:00:00	AAPL	Stock	0.2913	0.2946	0.2891	0.2924	62507200.0
2001-01-10 11:00:00	AAPL	Stock	0.2924	0.2969	0.2913	0.2958	69339200.0
2001-01-10 12:00:00	AAPL	Stock	0.2958	0.2969	0.2868	0.2879	66623200.0
2001-01-10 13:00:00	AAPL	Stock	0.2891	0.2946	0.2868	0.2924	44346400.0
2001-01-10 14:00:00	AAPL	Stock	0.2924	0.2958	0.2913	0.2935	52197600.0
2001-01-10 15:00:00	AAPL	Stock	0.2924	0.298	0.2924	0.2969	116743200.0
2001-01-10 16:00:00	AAPL	Stock	0.2958	0.298	0.2924	0.2958	10925600.0
2001-01-10 17:00:00	AAPL	Stock	0.2935	0.3036	0.2913	0.2946	341600.0
2001-01-10 18:00:00	AAPL	Stock	0.2946	0.2946	0.2935	0.2935	33600.0
2001-01-10 08:00:00	MSFT	Stock	25.9062	25.9062	25.4375	25.5	311400.0
2001-01-10 09:00:00	MSFT	Stock	25.4375	26.2812	25.375	26.0	12286200.0
2001-01-10 10:00:00	MSFT	Stock	26.0312	26.5938	26.0	26.375	11696600.0
2001-01-10 11:00:00	MSFT	Stock	26.4062	26.8125	26.375	26.7812	10255400.0
2001-01-10 12:00:00	MSFT	Stock	26.7812	26.9062	25.9688	26.0938	14163800.0
2001-01-10 13:00:00	MSFT	Stock	26.0938	26.6875	25.8125	26.5	8797200.0
2001-01-10 14:00:00	MSFT	Stock	26.5312	26.6875	26.0625	26.1875	10649600.0
2001-01-10 15:00:00	MSFT	Stock	26.1875	26.5312	26.125	26.4375	12033200.0
2001-01-10 16:00:00	MSFT	Stock	26.4375	26.5938	26.0625	26.125	2593200.0
2001-01-10 17:00:00	MSFT	Stock	26.125	26.3281	25.9375	26.25	40600.0
2001-01-10 18:00:00	MSFT	Stock	26.25	26.25	26.0938	26.125	6600.0
2001-01-10 08:00:00	NVDA	Stock	0.1725	0.1725	0.1725	0.1725	1440000.0
2001-01-10 09:00:00	NVDA	Stock	0.165	0.1664	0.1599	0.1661	37920000.0
2001-01-10 10:00:00	NVDA	Stock	0.1661	0.1742	0.1656	0.1732	49176000.0
2001-01-10 11:00:00	NVDA	Stock	0.1732	0.1797	0.1732	0.1797	63048000.0
2001-01-10 12:00:00	NVDA	Stock	0.1796	0.1818	0.1745	0.1745	60504000.0
2001-01-10 13:00:00	NVDA	Stock	0.1747	0.1771	0.1708	0.176	31968000.0
2001-01-10 14:00:00	NVDA	Stock	0.176	0.1797	0.175	0.1771	30816000.0
2001-01-10 15:00:00	NVDA	Stock	0.1771	0.1854	0.176	0.1846	54960000.0
2001-01-10 16:00:00	NVDA	Stock	0.1846	0.1846	0.1789	0.1836	8040000.0
2001-01-10 17:00:00	NVDA	Stock	0.1792	0.1792	0.1792	0.1792	48000.0
2001-01-10 08:00:00	AMZN	Stock	0.8188	0.8188	0.8	0.8016	792000.0
2001-01-10 09:00:00	AMZN	Stock	0.8	0.85	0.7875	0.8375	33106000.0
2001-01-10 10:00:00	AMZN	Stock	0.8406	0.85	0.7781	0.8031	43404000.0
2001-01-10 11:00:00	AMZN	Stock	0.8	0.8312	0.7969	0.8281	27630000.0
2001-01-10 12:00:00	AMZN	Stock	0.8219	0.8406	0.7906	0.7906	23550000.0
2001-01-10 13:00:00	AMZN	Stock	0.7938	0.8031	0.7812	0.7969	14738000.0
2001-01-10 14:00:00	AMZN	Stock	0.7969	0.8031	0.7844	0.7906	18472000.0
2001-01-10 15:00:00	AMZN	Stock	0.7938	0.8281	0.7906	0.825	27394000.0
2001-01-10 16:00:00	AMZN	Stock	0.8281	0.85	0.7875	0.7875	5234000.0
2001-01-10 17:00:00	AMZN	Stock	0.7938	0.7938	0.7625	0.7906	1810000.0
2001-01-10 18:00:00	AMZN	Stock	0.7906	0.7938	0.7844	0.7875	140000.0
2001-01-10 09:00:00	CL	Stock	29.8	29.865	29.565	29.565	190400.0
2001-01-10 10:00:00	CL	Stock	29.57	29.575	29.35	29.4	311400.0
2001-01-10 11:00:00	CL	Stock	29.39	29.55	29.35	29.47	457000.0
2001-01-10 12:00:00	CL	Stock	29.47	29.605	29.45	29.525	521600.0
2001-01-10 13:00:00	CL	Stock	29.525	29.575	29.425	29.425	357200.0
2001-01-10 14:00:00	CL	Stock	29.425	29.475	29.275	29.475	354000.0
2001-01-10 15:00:00	CL	Stock	29.495	29.675	29.425	29.575	561600.0

> showing 50 of 16,173 rows — these rows as CSV

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