PREVIEW / stock_1hour / 2006-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-06.parquet
  size:    640 KB
  rows:    30,769
  symbols: 2,433

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-11-06 07:00:00	AAPL	Stock	2.81	2.815	2.8054	2.815	67760.0
2006-11-06 08:00:00	AAPL	Stock	2.8157	2.8271	2.81	2.8182	1646316.0
2006-11-06 09:00:00	AAPL	Stock	2.8182	2.8307	2.8011	2.8279	69353060.0
2006-11-06 10:00:00	AAPL	Stock	2.8279	2.8568	2.8239	2.8471	118098708.0
2006-11-06 11:00:00	AAPL	Stock	2.8481	2.8593	2.8425	2.8554	53064508.0
2006-11-06 12:00:00	AAPL	Stock	2.8557	2.8564	2.8393	2.8511	50067108.0
2006-11-06 13:00:00	AAPL	Stock	2.8507	2.8554	2.8429	2.8489	34545364.0
2006-11-06 14:00:00	AAPL	Stock	2.8489	2.8536	2.8464	2.8507	26379640.0
2006-11-06 15:00:00	AAPL	Stock	2.8507	2.8546	2.8414	2.8464	63754852.0
2006-11-06 16:00:00	AAPL	Stock	2.8436	2.8482	2.8429	2.8464	732816.0
2006-11-06 17:00:00	AAPL	Stock	2.8461	2.8471	2.8454	2.8464	8766548.0
2006-11-06 18:00:00	AAPL	Stock	2.8464	2.8489	2.8464	2.8489	113540.0
2006-11-06 19:00:00	AAPL	Stock	2.8468	2.8468	2.8468	2.8468	2800.0
2006-11-06 08:00:00	MSFT	Stock	28.7	28.84	28.0	28.65	136896.0
2006-11-06 09:00:00	MSFT	Stock	28.67	28.99	28.64	28.96	7406941.0
2006-11-06 10:00:00	MSFT	Stock	28.97	29.05	28.87	28.902	15185033.0
2006-11-06 11:00:00	MSFT	Stock	28.91	29.04	28.87	28.94	5622911.0
2006-11-06 12:00:00	MSFT	Stock	28.94	28.97	28.88	28.9	3181088.0
2006-11-06 13:00:00	MSFT	Stock	28.9	28.95	28.9	28.9	3161206.0
2006-11-06 14:00:00	MSFT	Stock	28.9	28.93	28.88	28.9	4753559.0
2006-11-06 15:00:00	MSFT	Stock	28.9	28.97	28.8	28.8	10794220.0
2006-11-06 16:00:00	MSFT	Stock	28.82	28.913	28.8	28.82	124383.0
2006-11-06 17:00:00	MSFT	Stock	28.84	28.84	28.81	28.84	378501.0
2006-11-06 18:00:00	MSFT	Stock	28.81	28.81	28.81	28.81	200.0
2006-11-06 19:00:00	MSFT	Stock	28.82	28.83	28.82	28.83	6138.0
2006-11-06 08:00:00	NVDA	Stock	0.55	0.55	0.5478	0.5478	87000.0
2006-11-06 09:00:00	NVDA	Stock	0.548	0.5533	0.5267	0.5433	109230180.0
2006-11-06 10:00:00	NVDA	Stock	0.5433	0.55	0.5428	0.5477	122922420.0
2006-11-06 11:00:00	NVDA	Stock	0.5477	0.558	0.5477	0.5578	110771820.0
2006-11-06 12:00:00	NVDA	Stock	0.5577	0.56	0.5555	0.5587	88094400.0
2006-11-06 13:00:00	NVDA	Stock	0.5585	0.563	0.5582	0.5607	80807580.0
2006-11-06 14:00:00	NVDA	Stock	0.5608	0.5673	0.5608	0.5653	94675500.0
2006-11-06 15:00:00	NVDA	Stock	0.5653	0.5669	0.5592	0.5605	117664800.0
2006-11-06 16:00:00	NVDA	Stock	0.56	0.56	0.5583	0.5592	927240.0
2006-11-06 17:00:00	NVDA	Stock	0.5592	0.5608	0.5592	0.5607	453840.0
2006-11-06 18:00:00	NVDA	Stock	0.5607	0.5607	0.5592	0.5592	93000.0
2006-11-06 08:00:00	AMZN	Stock	1.88	1.88	1.88	1.88	60000.0
2006-11-06 09:00:00	AMZN	Stock	1.88	1.9	1.8765	1.8995	10280480.0
2006-11-06 10:00:00	AMZN	Stock	1.9	1.915	1.8955	1.91	21811380.0
2006-11-06 11:00:00	AMZN	Stock	1.9105	1.9125	1.9025	1.9045	10250260.0
2006-11-06 12:00:00	AMZN	Stock	1.9045	1.9075	1.8975	1.902	6396340.0
2006-11-06 13:00:00	AMZN	Stock	1.9025	1.911	1.8975	1.9075	10236740.0
2006-11-06 14:00:00	AMZN	Stock	1.9075	1.912	1.9055	1.9105	8730640.0
2006-11-06 15:00:00	AMZN	Stock	1.91	1.9175	1.9085	1.913	19373500.0
2006-11-06 16:00:00	AMZN	Stock	1.911	1.913	1.91	1.91	271700.0
2006-11-06 17:00:00	AMZN	Stock	1.9095	1.9105	1.9095	1.91	101360.0
2006-11-06 18:00:00	AMZN	Stock	1.912	1.912	1.912	1.912	57700.0
2006-11-06 09:00:00	CL	Stock	31.9	31.995	31.87	31.96	345400.0
2006-11-06 10:00:00	CL	Stock	31.965	32.055	31.94	31.99	580600.0
2006-11-06 11:00:00	CL	Stock	31.995	32.025	31.97	32.015	462200.0

> showing 50 of 30,769 rows — these rows as CSV

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