PREVIEW / stock_1hour / 2006-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-19.parquet
  size:    603 KB
  rows:    28,685
  symbols: 2,371

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-09-19 07:00:00	AAPL	Stock	2.6261	2.6282	2.625	2.6282	14000.0
2006-09-19 08:00:00	AAPL	Stock	2.6393	2.6464	2.6254	2.6393	1164240.0
2006-09-19 09:00:00	AAPL	Stock	2.6418	2.6536	2.6196	2.6414	107355220.0
2006-09-19 10:00:00	AAPL	Stock	2.6418	2.65	2.6268	2.6404	99292144.0
2006-09-19 11:00:00	AAPL	Stock	2.64	2.6557	2.6132	2.6232	167688388.0
2006-09-19 12:00:00	AAPL	Stock	2.6232	2.6332	2.6	2.6193	112059276.0
2006-09-19 13:00:00	AAPL	Stock	2.6189	2.6286	2.6121	2.6225	51692116.0
2006-09-19 14:00:00	AAPL	Stock	2.6221	2.6354	2.6196	2.6293	59806768.0
2006-09-19 15:00:00	AAPL	Stock	2.6289	2.64	2.6246	2.6361	85537172.0
2006-09-19 16:00:00	AAPL	Stock	2.6368	2.6457	2.6346	2.6407	1034656.0
2006-09-19 17:00:00	AAPL	Stock	2.6407	2.6525	2.6404	2.6454	17061912.0
2006-09-19 18:00:00	AAPL	Stock	2.6454	2.6454	2.6411	2.6429	47152.0
2006-09-19 06:00:00	MSFT	Stock	26.69	26.69	26.69	26.69	500.0
2006-09-19 07:00:00	MSFT	Stock	26.65	26.71	26.65	26.68	17300.0
2006-09-19 08:00:00	MSFT	Stock	26.68	26.8	26.66	26.75	41300.0
2006-09-19 09:00:00	MSFT	Stock	26.76	26.863	26.7	26.8	4145406.0
2006-09-19 10:00:00	MSFT	Stock	26.792	26.93	26.77	26.9	5847992.0
2006-09-19 11:00:00	MSFT	Stock	26.9	26.94	26.75	26.79	8157920.0
2006-09-19 12:00:00	MSFT	Stock	26.773	26.81	26.72	26.79	5165059.0
2006-09-19 13:00:00	MSFT	Stock	26.79	26.88	26.78	26.83	6074698.0
2006-09-19 14:00:00	MSFT	Stock	26.83	26.91	26.78	26.81	5386835.0
2006-09-19 15:00:00	MSFT	Stock	26.8	26.862	26.8	26.86	6324192.0
2006-09-19 16:00:00	MSFT	Stock	26.87	27.15	26.84	27.06	514713.0
2006-09-19 17:00:00	MSFT	Stock	27.06	27.1	27.06	27.07	30725.0
2006-09-19 18:00:00	MSFT	Stock	27.09	27.1	27.03	27.07	16190.0
2006-09-19 08:00:00	NVDA	Stock	0.5103	0.5103	0.505	0.5065	3100800.0
2006-09-19 09:00:00	NVDA	Stock	0.5075	0.5092	0.5037	0.5057	73049220.0
2006-09-19 10:00:00	NVDA	Stock	0.5055	0.5078	0.5027	0.5072	100546560.0
2006-09-19 11:00:00	NVDA	Stock	0.5072	0.5117	0.5038	0.5053	139752960.0
2006-09-19 12:00:00	NVDA	Stock	0.5052	0.5067	0.4985	0.4988	100667220.0
2006-09-19 13:00:00	NVDA	Stock	0.4988	0.5002	0.4943	0.4955	98340540.0
2006-09-19 14:00:00	NVDA	Stock	0.4955	0.4982	0.4938	0.4972	70101960.0
2006-09-19 15:00:00	NVDA	Stock	0.4972	0.5008	0.497	0.4988	106932780.0
2006-09-19 16:00:00	NVDA	Stock	0.4977	0.4982	0.4975	0.4975	2139600.0
2006-09-19 17:00:00	NVDA	Stock	0.4995	0.5013	0.4995	0.5013	210000.0
2006-09-19 08:00:00	AMZN	Stock	1.605	1.605	1.605	1.605	2000.0
2006-09-19 09:00:00	AMZN	Stock	1.6145	1.615	1.593	1.6	9487840.0
2006-09-19 10:00:00	AMZN	Stock	1.6	1.6065	1.5935	1.595	12532560.0
2006-09-19 11:00:00	AMZN	Stock	1.595	1.599	1.541	1.545	50186300.0
2006-09-19 12:00:00	AMZN	Stock	1.5445	1.568	1.5445	1.566	32770200.0
2006-09-19 13:00:00	AMZN	Stock	1.5655	1.569	1.553	1.559	18234840.0
2006-09-19 14:00:00	AMZN	Stock	1.5594	1.569	1.559	1.5605	13499080.0
2006-09-19 15:00:00	AMZN	Stock	1.5605	1.5825	1.559	1.5805	31546880.0
2006-09-19 16:00:00	AMZN	Stock	1.5825	1.6	1.579	1.5885	606240.0
2006-09-19 17:00:00	AMZN	Stock	1.595	1.597	1.595	1.597	6000.0
2006-09-19 18:00:00	AMZN	Stock	1.597	1.597	1.597	1.597	10000.0
2006-09-19 09:00:00	CL	Stock	30.875	30.91	30.801	30.88	163600.0
2006-09-19 10:00:00	CL	Stock	30.865	30.91	30.75	30.78	234200.0
2006-09-19 11:00:00	CL	Stock	30.78	30.9	30.755	30.9	192800.0
2006-09-19 12:00:00	CL	Stock	30.895	30.95	30.845	30.94	228800.0

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

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