PREVIEW / stock_1hour / 2002-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-05.parquet
  size:    404 KB
  rows:    19,350
  symbols: 1,502

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
2002-11-05 09:00:00	AAPL	Stock	0.3016	0.3016	0.2946	0.2948	23156000.0
2002-11-05 10:00:00	AAPL	Stock	0.2948	0.2998	0.292	0.2968	30888368.0
2002-11-05 11:00:00	AAPL	Stock	0.2968	0.2971	0.293	0.2941	37981832.0
2002-11-05 12:00:00	AAPL	Stock	0.2941	0.297	0.2923	0.2954	24836056.0
2002-11-05 13:00:00	AAPL	Stock	0.2953	0.2955	0.2929	0.2941	19851664.0
2002-11-05 14:00:00	AAPL	Stock	0.2939	0.2998	0.2939	0.2998	24664360.0
2002-11-05 15:00:00	AAPL	Stock	0.2998	0.303	0.2976	0.3018	33118736.0
2002-11-05 16:00:00	AAPL	Stock	0.3016	0.3025	0.3013	0.3025	3283000.0
2002-11-05 17:00:00	AAPL	Stock	0.3018	0.3018	0.3018	0.3018	1036000.0
2002-11-05 08:00:00	MSFT	Stock	27.905	28.0	27.895	27.99	49254.0
2002-11-05 09:00:00	MSFT	Stock	27.995	28.09	27.87	27.89	10305598.0
2002-11-05 10:00:00	MSFT	Stock	27.9	28.08	27.79	28.075	15507548.0
2002-11-05 11:00:00	MSFT	Stock	28.074	28.075	27.905	28.02	7354010.0
2002-11-05 12:00:00	MSFT	Stock	28.02	28.055	27.825	27.975	7716104.0
2002-11-05 13:00:00	MSFT	Stock	27.975	28.01	27.845	27.86	5449816.0
2002-11-05 14:00:00	MSFT	Stock	27.855	28.27	27.855	28.24	10090018.0
2002-11-05 15:00:00	MSFT	Stock	28.24	28.385	28.12	28.335	13937788.0
2002-11-05 16:00:00	MSFT	Stock	28.335	28.375	28.2187	28.31	1617154.0
2002-11-05 17:00:00	MSFT	Stock	28.325	28.375	28.31	28.375	169040.0
2002-11-05 18:00:00	MSFT	Stock	28.35	28.38	28.35	28.38	12220.0
2002-11-05 08:00:00	NVDA	Stock	0.1304	0.1304	0.1279	0.1293	4470840.0
2002-11-05 09:00:00	NVDA	Stock	0.1296	0.1322	0.1282	0.1297	348061680.0
2002-11-05 10:00:00	NVDA	Stock	0.1297	0.1303	0.1208	0.1248	569571960.0
2002-11-05 11:00:00	NVDA	Stock	0.1248	0.1254	0.1229	0.1234	161138040.0
2002-11-05 12:00:00	NVDA	Stock	0.1234	0.1237	0.1217	0.1221	215481720.0
2002-11-05 13:00:00	NVDA	Stock	0.122	0.1226	0.1196	0.1204	122866200.0
2002-11-05 14:00:00	NVDA	Stock	0.1204	0.1242	0.1204	0.1237	172768320.0
2002-11-05 15:00:00	NVDA	Stock	0.1237	0.127	0.1236	0.1253	285925680.0
2002-11-05 16:00:00	NVDA	Stock	0.1253	0.1259	0.1248	0.1254	37089120.0
2002-11-05 17:00:00	NVDA	Stock	0.1254	0.1262	0.1252	0.1255	1536000.0
2002-11-05 18:00:00	NVDA	Stock	0.1262	0.1262	0.1258	0.1262	180000.0
2002-11-05 08:00:00	AMZN	Stock	0.935	0.939	0.9275	0.93	2482000.0
2002-11-05 09:00:00	AMZN	Stock	0.939	0.9395	0.9235	0.935	21495260.0
2002-11-05 10:00:00	AMZN	Stock	0.935	0.9435	0.9305	0.9395	25970940.0
2002-11-05 11:00:00	AMZN	Stock	0.939	0.942	0.93	0.936	15337200.0
2002-11-05 12:00:00	AMZN	Stock	0.9355	0.9405	0.9335	0.9355	15886700.0
2002-11-05 13:00:00	AMZN	Stock	0.935	0.9355	0.91	0.917	32595780.0
2002-11-05 14:00:00	AMZN	Stock	0.917	0.9302	0.917	0.9258	12493680.0
2002-11-05 15:00:00	AMZN	Stock	0.928	0.9375	0.924	0.936	17543640.0
2002-11-05 16:00:00	AMZN	Stock	0.9365	0.941	0.9325	0.9375	2870040.0
2002-11-05 17:00:00	AMZN	Stock	0.94	0.945	0.9359	0.9359	602000.0
2002-11-05 18:00:00	AMZN	Stock	0.944	0.944	0.94	0.944	54200.0
2002-11-05 09:00:00	CL	Stock	26.77	26.92	26.77	26.86	277200.0
2002-11-05 10:00:00	CL	Stock	26.87	26.945	26.8	26.9	460200.0
2002-11-05 11:00:00	CL	Stock	26.9	27.09	26.895	27.065	463200.0
2002-11-05 12:00:00	CL	Stock	27.06	27.22	27.06	27.16	447000.0
2002-11-05 13:00:00	CL	Stock	27.155	27.165	27.04	27.07	304600.0
2002-11-05 14:00:00	CL	Stock	27.07	27.2	27.065	27.175	399600.0
2002-11-05 15:00:00	CL	Stock	27.175	27.25	27.115	27.23	669600.0
2002-11-05 16:00:00	CL	Stock	27.235	27.25	27.235	27.24	167800.0

> showing 50 of 19,350 rows — these rows as CSV

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