PREVIEW / stock_1hour / 2009-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-23.parquet
  size:    890 KB
  rows:    42,929
  symbols: 3,393

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
2009-09-23 07:00:00	AAPL	Stock	6.6071	6.6236	6.6071	6.6236	51380.0
2009-09-23 08:00:00	AAPL	Stock	6.6179	6.6236	6.5721	6.6196	1694784.0
2009-09-23 09:00:00	AAPL	Stock	6.6175	6.7093	6.6082	6.6889	101713164.0
2009-09-23 10:00:00	AAPL	Stock	6.6904	6.7054	6.6429	6.6732	96964476.0
2009-09-23 11:00:00	AAPL	Stock	6.6739	6.7032	6.6618	6.7	40018076.0
2009-09-23 12:00:00	AAPL	Stock	6.6996	6.7189	6.6904	6.7075	50330980.0
2009-09-23 13:00:00	AAPL	Stock	6.7086	6.7229	6.7014	6.7089	49163968.0
2009-09-23 14:00:00	AAPL	Stock	6.7086	6.7464	6.7057	6.7093	101921736.0
2009-09-23 15:00:00	AAPL	Stock	6.7107	6.7307	6.6121	6.6261	141200612.0
2009-09-23 16:00:00	AAPL	Stock	6.6264	6.6885	6.6246	6.6386	5181596.0
2009-09-23 17:00:00	AAPL	Stock	6.6382	6.6571	6.6357	6.6571	1044204.0
2009-09-23 18:00:00	AAPL	Stock	6.6571	6.6714	6.625	6.6671	755804.0
2009-09-23 19:00:00	AAPL	Stock	6.6675	6.6714	6.6575	6.6661	774648.0
2009-09-23 08:00:00	MSFT	Stock	25.84	25.89	25.3	25.89	32700.0
2009-09-23 09:00:00	MSFT	Stock	25.86	26.0	25.8	25.91	7270422.0
2009-09-23 10:00:00	MSFT	Stock	25.92	26.0	25.86	25.92	8852857.0
2009-09-23 11:00:00	MSFT	Stock	25.93	25.99	25.91	25.972	5501043.0
2009-09-23 12:00:00	MSFT	Stock	25.98	26.02	25.96	26.01	5528940.0
2009-09-23 13:00:00	MSFT	Stock	26.002	26.09	25.95	26.085	4553814.0
2009-09-23 14:00:00	MSFT	Stock	26.08	26.25	26.04	26.06	9688894.0
2009-09-23 15:00:00	MSFT	Stock	26.06	26.12	25.64	25.71	16824483.0
2009-09-23 16:00:00	MSFT	Stock	25.72	25.972	25.68	25.75	1663519.0
2009-09-23 17:00:00	MSFT	Stock	25.74	25.74	25.72	25.73	5597.0
2009-09-23 18:00:00	MSFT	Stock	25.71	25.77	25.71	25.75	16641.0
2009-09-23 19:00:00	MSFT	Stock	25.75	25.75	25.73	25.73	1098.0
2009-09-23 08:00:00	NVDA	Stock	0.3788	0.3788	0.3788	0.3788	740000.0
2009-09-23 09:00:00	NVDA	Stock	0.382	0.3848	0.3788	0.3798	51019760.0
2009-09-23 10:00:00	NVDA	Stock	0.3798	0.382	0.3753	0.3755	79149480.0
2009-09-23 11:00:00	NVDA	Stock	0.3755	0.378	0.3753	0.3775	55664240.0
2009-09-23 12:00:00	NVDA	Stock	0.3773	0.3785	0.3768	0.3785	25065160.0
2009-09-23 13:00:00	NVDA	Stock	0.3785	0.381	0.3778	0.381	35893560.0
2009-09-23 14:00:00	NVDA	Stock	0.3809	0.385	0.3788	0.381	78938640.0
2009-09-23 15:00:00	NVDA	Stock	0.381	0.3822	0.373	0.3735	144106560.0
2009-09-23 16:00:00	NVDA	Stock	0.3738	0.3875	0.3735	0.3784	1600680.0
2009-09-23 17:00:00	NVDA	Stock	0.375	0.3753	0.375	0.3753	48000.0
2009-09-23 18:00:00	NVDA	Stock	0.3763	0.3763	0.3758	0.3758	100000.0
2009-09-23 19:00:00	NVDA	Stock	0.3758	0.376	0.3745	0.3745	70640.0
2009-09-23 07:00:00	AMZN	Stock	4.6715	4.6715	4.668	4.668	4000.0
2009-09-23 08:00:00	AMZN	Stock	4.6875	4.691	4.528	4.6865	934700.0
2009-09-23 09:00:00	AMZN	Stock	4.68	4.709	4.619	4.6597	18812560.0
2009-09-23 10:00:00	AMZN	Stock	4.6607	4.7145	4.651	4.694	21974980.0
2009-09-23 11:00:00	AMZN	Stock	4.694	4.6945	4.6505	4.6755	10671580.0
2009-09-23 12:00:00	AMZN	Stock	4.6745	4.6905	4.673	4.684	6659460.0
2009-09-23 13:00:00	AMZN	Stock	4.684	4.7025	4.675	4.7	8029140.0
2009-09-23 14:00:00	AMZN	Stock	4.699	4.725	4.6805	4.69	16083140.0
2009-09-23 15:00:00	AMZN	Stock	4.6905	4.695	4.611	4.619	28329040.0
2009-09-23 16:00:00	AMZN	Stock	4.619	4.6742	4.611	4.615	1997760.0
2009-09-23 17:00:00	AMZN	Stock	4.6125	4.6125	4.6125	4.6125	22000.0
2009-09-23 18:00:00	AMZN	Stock	4.613	4.613	4.613	4.613	2000.0
2009-09-23 19:00:00	AMZN	Stock	4.613	4.625	4.613	4.625	9000.0

> showing 50 of 42,929 rows — these rows as CSV

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