PREVIEW / stock_1hour / 2006-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-06.parquet
  size:    594 KB
  rows:    28,087
  symbols: 2,172

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-01-06 08:00:00	AAPL	Stock	2.6607	2.6782	2.6339	2.6768	2164036.0
2006-01-06 09:00:00	AAPL	Stock	2.6775	2.6957	2.6625	2.6696	81225648.0
2006-01-06 10:00:00	AAPL	Stock	2.6696	2.6996	2.6668	2.6889	125963040.0
2006-01-06 11:00:00	AAPL	Stock	2.6889	2.7104	2.6732	2.7093	108383464.0
2006-01-06 12:00:00	AAPL	Stock	2.71	2.73	2.7064	2.7125	112547316.0
2006-01-06 13:00:00	AAPL	Stock	2.7125	2.7389	2.7104	2.7329	73701852.0
2006-01-06 14:00:00	AAPL	Stock	2.7325	2.7393	2.7175	2.7214	84010192.0
2006-01-06 15:00:00	AAPL	Stock	2.7214	2.7275	2.7125	2.7254	103443060.0
2006-01-06 16:00:00	AAPL	Stock	2.7254	2.7286	2.7232	2.7232	2458568.0
2006-01-06 17:00:00	AAPL	Stock	2.7236	2.7279	2.7236	2.7268	262724.0
2006-01-06 18:00:00	AAPL	Stock	2.7254	2.7282	2.7254	2.7254	98504.0
2006-01-06 04:00:00	MSFT	Stock	26.84	26.84	26.84	26.84	1000.0
2006-01-06 07:00:00	MSFT	Stock	26.78	26.83	26.75	26.77	3300.0
2006-01-06 08:00:00	MSFT	Stock	26.8	26.94	26.8	26.94	141496.0
2006-01-06 09:00:00	MSFT	Stock	26.94	27.0	26.73	26.732	9508692.0
2006-01-06 10:00:00	MSFT	Stock	26.73	26.92	26.49	26.53	15085970.0
2006-01-06 11:00:00	MSFT	Stock	26.54	26.65	26.49	26.6	10891995.0
2006-01-06 12:00:00	MSFT	Stock	26.6	26.84	26.58	26.75	11913125.0
2006-01-06 13:00:00	MSFT	Stock	26.75	26.77	26.65	26.72	8039509.0
2006-01-06 14:00:00	MSFT	Stock	26.72	26.84	26.68	26.8	10660890.0
2006-01-06 15:00:00	MSFT	Stock	26.8	26.95	26.8	26.94	21776471.0
2006-01-06 16:00:00	MSFT	Stock	26.94	27.03	26.75	27.03	2848038.0
2006-01-06 17:00:00	MSFT	Stock	26.96	27.01	26.96	27.01	40041.0
2006-01-06 18:00:00	MSFT	Stock	27.01	27.01	26.99	27.0	6016.0
2006-01-06 08:00:00	NVDA	Stock	0.3342	0.335	0.3342	0.335	96000.0
2006-01-06 09:00:00	NVDA	Stock	0.3358	0.3387	0.3254	0.3317	146383320.0
2006-01-06 10:00:00	NVDA	Stock	0.3314	0.334	0.3292	0.3311	87134160.0
2006-01-06 11:00:00	NVDA	Stock	0.3312	0.3315	0.3287	0.3295	48108960.0
2006-01-06 12:00:00	NVDA	Stock	0.3295	0.3317	0.3294	0.3312	35477520.0
2006-01-06 13:00:00	NVDA	Stock	0.3311	0.3391	0.3311	0.3388	89011560.0
2006-01-06 14:00:00	NVDA	Stock	0.3388	0.3414	0.3387	0.3399	112973040.0
2006-01-06 15:00:00	NVDA	Stock	0.3398	0.3416	0.3396	0.3403	81685200.0
2006-01-06 16:00:00	NVDA	Stock	0.3402	0.3403	0.3391	0.3403	928200.0
2006-01-06 17:00:00	NVDA	Stock	0.3397	0.3397	0.3397	0.3397	12000.0
2006-01-06 09:00:00	AMZN	Stock	2.3925	2.429	2.3925	2.4125	18787460.0
2006-01-06 10:00:00	AMZN	Stock	2.4125	2.4125	2.376	2.3785	22684120.0
2006-01-06 11:00:00	AMZN	Stock	2.378	2.39	2.366	2.379	18604840.0
2006-01-06 12:00:00	AMZN	Stock	2.3795	2.402	2.379	2.392	10994000.0
2006-01-06 13:00:00	AMZN	Stock	2.392	2.394	2.3775	2.392	16685360.0
2006-01-06 14:00:00	AMZN	Stock	2.3925	2.411	2.391	2.406	12979020.0
2006-01-06 15:00:00	AMZN	Stock	2.406	2.4085	2.3875	2.3925	19324580.0
2006-01-06 16:00:00	AMZN	Stock	2.394	2.395	2.389	2.39	525040.0
2006-01-06 17:00:00	AMZN	Stock	2.3935	2.3935	2.3935	2.3935	2100.0
2006-01-06 18:00:00	AMZN	Stock	2.3925	2.3925	2.39	2.39	26000.0
2006-01-06 09:00:00	CL	Stock	27.425	27.49	27.345	27.48	307400.0
2006-01-06 10:00:00	CL	Stock	27.48	27.48	27.29	27.415	421800.0
2006-01-06 11:00:00	CL	Stock	27.42	27.535	27.34	27.475	445000.0
2006-01-06 12:00:00	CL	Stock	27.48	27.515	27.365	27.365	267600.0
2006-01-06 13:00:00	CL	Stock	27.368	27.5	27.365	27.495	370000.0
2006-01-06 14:00:00	CL	Stock	27.485	27.53	27.445	27.465	498400.0

> showing 50 of 28,087 rows — these rows as CSV

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