PREVIEW / stock_1hour / 2006-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-01.parquet
  size:    635 KB
  rows:    30,278
  symbols: 2,434

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-01 07:00:00	AAPL	Stock	2.8946	2.8946	2.8946	2.8946	2800.0
2006-11-01 08:00:00	AAPL	Stock	2.8946	2.8957	2.8768	2.8925	1255156.0
2006-11-01 09:00:00	AAPL	Stock	2.8925	2.9064	2.8925	2.8986	42596344.0
2006-11-01 10:00:00	AAPL	Stock	2.8982	2.8986	2.8557	2.8657	140903336.0
2006-11-01 11:00:00	AAPL	Stock	2.8661	2.8711	2.8332	2.8371	102329696.0
2006-11-01 12:00:00	AAPL	Stock	2.8375	2.8561	2.8357	2.85	53876592.0
2006-11-01 13:00:00	AAPL	Stock	2.8496	2.8657	2.845	2.8624	35332220.0
2006-11-01 14:00:00	AAPL	Stock	2.8621	2.8657	2.8393	2.8393	56524244.0
2006-11-01 15:00:00	AAPL	Stock	2.8396	2.8621	2.7986	2.8271	163358664.0
2006-11-01 16:00:00	AAPL	Stock	2.8264	2.8661	2.8229	2.8282	1419936.0
2006-11-01 17:00:00	AAPL	Stock	2.8282	2.8282	2.825	2.825	35168.0
2006-11-01 18:00:00	AAPL	Stock	2.825	2.8293	2.825	2.8293	110936.0
2006-11-01 19:00:00	AAPL	Stock	2.8311	2.8311	2.8293	2.8293	25592.0
2006-11-01 08:00:00	MSFT	Stock	28.71	28.8	28.71	28.8	42599.0
2006-11-01 09:00:00	MSFT	Stock	28.79	28.99	28.73	28.9	9793531.0
2006-11-01 10:00:00	MSFT	Stock	28.9	28.97	28.75	28.839	15255218.0
2006-11-01 11:00:00	MSFT	Stock	28.84	28.93	28.78	28.85	8231113.0
2006-11-01 12:00:00	MSFT	Stock	28.86	28.95	28.79	28.84	5438592.0
2006-11-01 13:00:00	MSFT	Stock	28.847	28.88	28.82	28.85	3832041.0
2006-11-01 14:00:00	MSFT	Stock	28.85	28.86	28.75	28.79	7256222.0
2006-11-01 15:00:00	MSFT	Stock	28.79	28.82	28.7	28.8	13691438.0
2006-11-01 16:00:00	MSFT	Stock	28.81	28.86	28.71	28.81	413981.0
2006-11-01 17:00:00	MSFT	Stock	28.78	28.78	28.78	28.78	1020.0
2006-11-01 18:00:00	MSFT	Stock	28.79	28.81	28.75	28.81	17703.0
2006-11-01 19:00:00	MSFT	Stock	28.77	28.77	28.77	28.77	2300.0
2006-11-01 08:00:00	NVDA	Stock	0.5832	0.5833	0.579	0.5798	619560.0
2006-11-01 09:00:00	NVDA	Stock	0.5802	0.5802	0.565	0.5665	110580300.0
2006-11-01 10:00:00	NVDA	Stock	0.5663	0.569	0.5612	0.5615	118521900.0
2006-11-01 11:00:00	NVDA	Stock	0.5615	0.5628	0.5497	0.5553	152700600.0
2006-11-01 12:00:00	NVDA	Stock	0.555	0.5573	0.5495	0.5507	91091820.0
2006-11-01 13:00:00	NVDA	Stock	0.5507	0.5517	0.5435	0.544	146979600.0
2006-11-01 14:00:00	NVDA	Stock	0.5438	0.5457	0.5318	0.5368	232584060.0
2006-11-01 15:00:00	NVDA	Stock	0.5368	0.537	0.5283	0.536	246307500.0
2006-11-01 16:00:00	NVDA	Stock	0.5363	0.537	0.534	0.5367	6587340.0
2006-11-01 17:00:00	NVDA	Stock	0.5367	0.5372	0.536	0.537	344280.0
2006-11-01 18:00:00	NVDA	Stock	0.537	0.537	0.5363	0.537	32760.0
2006-11-01 19:00:00	NVDA	Stock	0.5367	0.5367	0.5367	0.5367	27960.0
2006-11-01 08:00:00	AMZN	Stock	1.9045	1.9045	1.9045	1.9045	713000.0
2006-11-01 09:00:00	AMZN	Stock	1.9115	1.912	1.895	1.897	9660920.0
2006-11-01 10:00:00	AMZN	Stock	1.8975	1.906	1.884	1.9045	22031380.0
2006-11-01 11:00:00	AMZN	Stock	1.9045	1.9082	1.8925	1.895	13358280.0
2006-11-01 12:00:00	AMZN	Stock	1.8946	1.898	1.8815	1.883	16052320.0
2006-11-01 13:00:00	AMZN	Stock	1.8827	1.8935	1.88	1.886	14361520.0
2006-11-01 14:00:00	AMZN	Stock	1.8855	1.886	1.8765	1.8835	14769240.0
2006-11-01 15:00:00	AMZN	Stock	1.8835	1.8835	1.873	1.8805	36653060.0
2006-11-01 16:00:00	AMZN	Stock	1.879	1.89	1.8785	1.89	353800.0
2006-11-01 17:00:00	AMZN	Stock	1.89	1.89	1.89	1.89	3760.0
2006-11-01 18:00:00	AMZN	Stock	1.8815	1.8815	1.878	1.878	15540.0
2006-11-01 08:00:00	CL	Stock	31.985	31.985	31.985	31.985	2800.0
2006-11-01 09:00:00	CL	Stock	32.11	32.115	31.89	32.0	389800.0

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

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