PREVIEW / stock_1hour / 2006-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-16.parquet
  size:    608 KB
  rows:    29,124
  symbols: 2,273

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
2006-05-16 08:00:00	AAPL	Stock	2.425	2.4561	2.4225	2.4375	3900792.0
2006-05-16 09:00:00	AAPL	Stock	2.4375	2.4411	2.3693	2.3793	136048500.0
2006-05-16 10:00:00	AAPL	Stock	2.3793	2.3829	2.3407	2.3654	212199456.0
2006-05-16 11:00:00	AAPL	Stock	2.3654	2.3661	2.3407	2.3532	103805128.0
2006-05-16 12:00:00	AAPL	Stock	2.3532	2.3611	2.3429	2.3471	55204520.0
2006-05-16 13:00:00	AAPL	Stock	2.3475	2.3589	2.3471	2.35	60771340.0
2006-05-16 14:00:00	AAPL	Stock	2.35	2.3543	2.3193	2.3196	116428648.0
2006-05-16 15:00:00	AAPL	Stock	2.3196	2.3346	2.3125	2.3207	217711900.0
2006-05-16 16:00:00	AAPL	Stock	2.3196	2.325	2.3171	2.3171	10177048.0
2006-05-16 17:00:00	AAPL	Stock	2.3171	2.3186	2.3161	2.3179	500696.0
2006-05-16 18:00:00	AAPL	Stock	2.3207	2.3225	2.3186	2.3196	370972.0
2006-05-16 08:00:00	MSFT	Stock	23.13	23.16	23.1	23.16	48733.0
2006-05-16 09:00:00	MSFT	Stock	23.15	24.0	23.06	23.078	7090830.0
2006-05-16 10:00:00	MSFT	Stock	23.08	23.09	23.01	23.05	8845262.0
2006-05-16 11:00:00	MSFT	Stock	23.04	23.05	22.91	22.952	19817462.0
2006-05-16 12:00:00	MSFT	Stock	22.97	23.08	22.93	22.96	10040805.0
2006-05-16 13:00:00	MSFT	Stock	22.97	23.07	22.95	23.0	7830325.0
2006-05-16 14:00:00	MSFT	Stock	23.0	23.0	22.96	22.99	6026212.0
2006-05-16 15:00:00	MSFT	Stock	22.98	23.03	22.93	23.0	13905696.0
2006-05-16 16:00:00	MSFT	Stock	22.99	23.04	22.98	23.01	376146.0
2006-05-16 17:00:00	MSFT	Stock	23.0	23.0	22.96	23.0	11278.0
2006-05-16 18:00:00	MSFT	Stock	22.97	23.005	22.96	22.98	62180.0
2006-05-16 08:00:00	NVDA	Stock	0.4383	0.4452	0.4383	0.4452	15600.0
2006-05-16 09:00:00	NVDA	Stock	0.4545	0.4545	0.4417	0.445	35072940.0
2006-05-16 10:00:00	NVDA	Stock	0.4447	0.446	0.438	0.44	62237940.0
2006-05-16 11:00:00	NVDA	Stock	0.44	0.441	0.4342	0.4345	53699880.0
2006-05-16 12:00:00	NVDA	Stock	0.4345	0.4358	0.4315	0.4357	67495500.0
2006-05-16 13:00:00	NVDA	Stock	0.4357	0.4383	0.435	0.4377	76170360.0
2006-05-16 14:00:00	NVDA	Stock	0.4377	0.4378	0.435	0.4353	59841060.0
2006-05-16 15:00:00	NVDA	Stock	0.4353	0.4393	0.4307	0.4335	114652860.0
2006-05-16 16:00:00	NVDA	Stock	0.4333	0.4367	0.4323	0.4335	5313780.0
2006-05-16 17:00:00	NVDA	Stock	0.4358	0.4362	0.4358	0.4362	164580.0
2006-05-16 18:00:00	NVDA	Stock	0.4334	0.435	0.4334	0.435	45540.0
2006-05-16 08:00:00	AMZN	Stock	1.6375	1.6425	1.6375	1.6425	84000.0
2006-05-16 09:00:00	AMZN	Stock	1.6375	1.651	1.629	1.638	10554460.0
2006-05-16 10:00:00	AMZN	Stock	1.638	1.6425	1.6175	1.6185	12017640.0
2006-05-16 11:00:00	AMZN	Stock	1.618	1.6295	1.616	1.625	8649060.0
2006-05-16 12:00:00	AMZN	Stock	1.6245	1.6285	1.617	1.625	6056620.0
2006-05-16 13:00:00	AMZN	Stock	1.625	1.6425	1.625	1.635	9679820.0
2006-05-16 14:00:00	AMZN	Stock	1.635	1.637	1.633	1.636	5929680.0
2006-05-16 15:00:00	AMZN	Stock	1.6355	1.638	1.6275	1.637	20864180.0
2006-05-16 16:00:00	AMZN	Stock	1.6375	1.638	1.6375	1.638	1536760.0
2006-05-16 18:00:00	AMZN	Stock	1.6376	1.6376	1.6376	1.6376	5780.0
2006-05-16 09:00:00	CL	Stock	30.11	30.445	29.97	30.25	929400.0
2006-05-16 10:00:00	CL	Stock	30.27	30.325	30.19	30.28	1187800.0
2006-05-16 11:00:00	CL	Stock	30.285	30.425	30.265	30.385	1345400.0
2006-05-16 12:00:00	CL	Stock	30.385	30.45	30.31	30.395	1233200.0
2006-05-16 13:00:00	CL	Stock	30.4	30.435	30.335	30.435	992800.0
2006-05-16 14:00:00	CL	Stock	30.42	30.42	30.33	30.35	790000.0
2006-05-16 15:00:00	CL	Stock	30.355	30.39	30.25	30.31	1376000.0

> showing 50 of 29,124 rows — these rows as CSV

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