PREVIEW / stock_1hour / 2006-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-07.parquet
  size:    606 KB
  rows:    28,516
  symbols: 2,181

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-03-07 05:00:00	AAPL	Stock	2.3232	2.3232	2.3232	2.3232	2800.0
2006-03-07 06:00:00	AAPL	Stock	2.325	2.3357	2.325	2.3357	44380.0
2006-03-07 07:00:00	AAPL	Stock	2.3343	2.3343	2.3343	2.3343	13860.0
2006-03-07 08:00:00	AAPL	Stock	2.3343	2.3525	2.3343	2.3411	3843896.0
2006-03-07 09:00:00	AAPL	Stock	2.3429	2.3621	2.3304	2.3364	133537544.0
2006-03-07 10:00:00	AAPL	Stock	2.3368	2.3757	2.3364	2.3654	180448240.0
2006-03-07 11:00:00	AAPL	Stock	2.3654	2.3893	2.3554	2.3625	142135980.0
2006-03-07 12:00:00	AAPL	Stock	2.3621	2.3693	2.3411	2.3454	89095664.0
2006-03-07 13:00:00	AAPL	Stock	2.3454	2.3625	2.3243	2.355	121502892.0
2006-03-07 14:00:00	AAPL	Stock	2.355	2.3671	2.3418	2.3593	85321236.0
2006-03-07 15:00:00	AAPL	Stock	2.3593	2.3743	2.3546	2.3693	104752200.0
2006-03-07 16:00:00	AAPL	Stock	2.3693	2.3768	2.3679	2.3768	2217488.0
2006-03-07 17:00:00	AAPL	Stock	2.3696	2.3768	2.3679	2.3732	620172.0
2006-03-07 18:00:00	AAPL	Stock	2.3732	2.3732	2.3679	2.3696	165060.0
2006-03-07 07:00:00	MSFT	Stock	26.89	26.89	26.89	26.89	1000.0
2006-03-07 08:00:00	MSFT	Stock	26.82	26.87	26.82	26.86	11470.0
2006-03-07 09:00:00	MSFT	Stock	26.85	27.25	26.81	26.898	5445534.0
2006-03-07 10:00:00	MSFT	Stock	26.89	27.0	26.89	26.95	5430745.0
2006-03-07 11:00:00	MSFT	Stock	26.96	26.98	26.85	26.95	4942406.0
2006-03-07 12:00:00	MSFT	Stock	26.95	27.09	26.85	26.91	7642219.0
2006-03-07 13:00:00	MSFT	Stock	26.9	26.97	26.89	26.95	4220236.0
2006-03-07 14:00:00	MSFT	Stock	26.95	27.01	26.9	26.99	7707420.0
2006-03-07 15:00:00	MSFT	Stock	26.99	27.1	26.93	27.04	7988602.0
2006-03-07 16:00:00	MSFT	Stock	27.04	27.09	27.03	27.08	91002.0
2006-03-07 17:00:00	MSFT	Stock	27.06	27.08	27.05	27.06	5675315.0
2006-03-07 18:00:00	MSFT	Stock	27.08	27.08	27.06	27.08	18100.0
2006-03-07 08:00:00	NVDA	Stock	0.4091	0.4124	0.4089	0.4089	288000.0
2006-03-07 09:00:00	NVDA	Stock	0.4087	0.4115	0.4087	0.41	38046360.0
2006-03-07 10:00:00	NVDA	Stock	0.4102	0.4121	0.3992	0.3992	157085400.0
2006-03-07 11:00:00	NVDA	Stock	0.3996	0.4009	0.3975	0.3992	108008520.0
2006-03-07 12:00:00	NVDA	Stock	0.3992	0.4011	0.3951	0.3952	76879560.0
2006-03-07 13:00:00	NVDA	Stock	0.3952	0.3977	0.3937	0.3974	46476120.0
2006-03-07 14:00:00	NVDA	Stock	0.3975	0.3977	0.3949	0.3968	46848240.0
2006-03-07 15:00:00	NVDA	Stock	0.3967	0.4017	0.3965	0.4017	109508640.0
2006-03-07 16:00:00	NVDA	Stock	0.4018	0.4027	0.4009	0.4021	2157840.0
2006-03-07 17:00:00	NVDA	Stock	0.4018	0.4018	0.4018	0.4018	12000.0
2006-03-07 18:00:00	NVDA	Stock	0.4018	0.4018	0.4018	0.4018	36000.0
2006-03-07 08:00:00	AMZN	Stock	1.85	1.85	1.835	1.835	12440.0
2006-03-07 09:00:00	AMZN	Stock	1.833	1.8685	1.833	1.855	11392160.0
2006-03-07 10:00:00	AMZN	Stock	1.8555	1.871	1.853	1.8545	18872600.0
2006-03-07 11:00:00	AMZN	Stock	1.8545	1.8575	1.847	1.848	11038760.0
2006-03-07 12:00:00	AMZN	Stock	1.8475	1.852	1.8445	1.8465	11505260.0
2006-03-07 13:00:00	AMZN	Stock	1.846	1.85	1.841	1.8475	10522800.0
2006-03-07 14:00:00	AMZN	Stock	1.8475	1.852	1.8395	1.849	8579520.0
2006-03-07 15:00:00	AMZN	Stock	1.849	1.8555	1.8395	1.8465	20200240.0
2006-03-07 16:00:00	AMZN	Stock	1.8465	1.85	1.8465	1.847	448980.0
2006-03-07 17:00:00	AMZN	Stock	1.846	1.8464	1.845	1.845	44660.0
2006-03-07 18:00:00	AMZN	Stock	1.845	1.845	1.845	1.845	10000.0
2006-03-07 09:00:00	CL	Stock	27.035	27.35	27.01	27.345	222800.0
2006-03-07 10:00:00	CL	Stock	27.345	27.425	27.31	27.35	518200.0

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

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