PREVIEW / stock_1hour / 2008-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-31.parquet
  size:    834 KB
  rows:    41,707
  symbols: 3,271

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
2008-01-31 05:00:00	AAPL	Stock	4.6489	4.6489	4.6489	4.6489	3248.0
2008-01-31 07:00:00	AAPL	Stock	4.6786	4.6946	4.6786	4.6904	36400.0
2008-01-31 08:00:00	AAPL	Stock	4.685	4.7143	4.6282	4.6282	4549748.0
2008-01-31 09:00:00	AAPL	Stock	4.6282	4.6875	4.5868	4.6789	170224656.0
2008-01-31 10:00:00	AAPL	Stock	4.6779	4.7164	4.6621	4.7043	191924600.0
2008-01-31 11:00:00	AAPL	Stock	4.7046	4.8057	4.6896	4.7943	198242772.0
2008-01-31 12:00:00	AAPL	Stock	4.7946	4.8239	4.7736	4.7868	168331380.0
2008-01-31 13:00:00	AAPL	Stock	4.7864	4.8218	4.7707	4.807	121532852.0
2008-01-31 14:00:00	AAPL	Stock	4.8086	4.8446	4.7889	4.8357	165771340.0
2008-01-31 15:00:00	AAPL	Stock	4.8357	4.8804	4.7968	4.8211	271327700.0
2008-01-31 16:00:00	AAPL	Stock	4.8211	4.8489	4.6804	4.7786	50609104.0
2008-01-31 17:00:00	AAPL	Stock	4.7804	4.8343	4.7668	4.775	1692152.0
2008-01-31 18:00:00	AAPL	Stock	4.7746	4.8343	4.7746	4.7946	976164.0
2008-01-31 19:00:00	AAPL	Stock	4.7946	4.8036	4.7896	4.8	476028.0
2008-01-31 06:00:00	MSFT	Stock	32.04	32.2	32.04	32.2	800.0
2008-01-31 07:00:00	MSFT	Stock	32.1	32.3	32.1	32.2	67442.0
2008-01-31 08:00:00	MSFT	Stock	32.15	32.15	31.85	31.91	76102.0
2008-01-31 09:00:00	MSFT	Stock	31.91	31.98	31.78	31.94	11407689.0
2008-01-31 10:00:00	MSFT	Stock	31.94	31.99	31.72	31.859	14101230.0
2008-01-31 11:00:00	MSFT	Stock	31.86	32.42	31.75	32.2	13908509.0
2008-01-31 12:00:00	MSFT	Stock	32.2	33.0	32.01	32.118	6833010.0
2008-01-31 13:00:00	MSFT	Stock	32.12	32.4	32.02	32.31	10294916.0
2008-01-31 14:00:00	MSFT	Stock	32.3	32.63	32.25	32.53	12440731.0
2008-01-31 15:00:00	MSFT	Stock	32.53	32.74	32.34	32.54	23356093.0
2008-01-31 16:00:00	MSFT	Stock	32.51	32.6	31.96	32.35	10721659.0
2008-01-31 17:00:00	MSFT	Stock	32.4	32.63	32.3	32.398	156352.0
2008-01-31 18:00:00	MSFT	Stock	32.42	32.6	32.38	32.38	276781.0
2008-01-31 19:00:00	MSFT	Stock	32.4	32.43	32.4	32.4	2215.0
2008-01-31 08:00:00	NVDA	Stock	0.6188	0.6188	0.6173	0.6173	72000.0
2008-01-31 09:00:00	NVDA	Stock	0.6125	0.6202	0.605	0.6053	61080160.0
2008-01-31 10:00:00	NVDA	Stock	0.6053	0.6075	0.5958	0.6015	102488240.0
2008-01-31 11:00:00	NVDA	Stock	0.6015	0.6125	0.5978	0.608	90161760.0
2008-01-31 12:00:00	NVDA	Stock	0.6075	0.6098	0.6025	0.6073	70057640.0
2008-01-31 13:00:00	NVDA	Stock	0.6075	0.6158	0.607	0.6108	47237360.0
2008-01-31 14:00:00	NVDA	Stock	0.611	0.6168	0.61	0.6167	60078400.0
2008-01-31 15:00:00	NVDA	Stock	0.6167	0.6263	0.6148	0.616	126472480.0
2008-01-31 16:00:00	NVDA	Stock	0.6143	0.619	0.6038	0.6148	11266320.0
2008-01-31 17:00:00	NVDA	Stock	0.6148	0.616	0.612	0.616	1578000.0
2008-01-31 18:00:00	NVDA	Stock	0.6185	0.6185	0.6075	0.6075	2121280.0
2008-01-31 19:00:00	NVDA	Stock	0.615	0.615	0.615	0.615	4000.0
2008-01-31 05:00:00	AMZN	Stock	3.32	3.3225	3.32	3.3225	18000.0
2008-01-31 06:00:00	AMZN	Stock	3.3225	3.3325	3.32	3.3325	51000.0
2008-01-31 07:00:00	AMZN	Stock	3.34	3.39	3.3065	3.365	4235020.0
2008-01-31 08:00:00	AMZN	Stock	3.3645	3.4395	3.2775	3.399	29960320.0
2008-01-31 09:00:00	AMZN	Stock	3.398	3.65	3.395	3.6425	229284700.0
2008-01-31 10:00:00	AMZN	Stock	3.6425	3.724	3.6005	3.656	192950500.0
2008-01-31 11:00:00	AMZN	Stock	3.6555	3.78	3.6175	3.75	95129440.0
2008-01-31 12:00:00	AMZN	Stock	3.7495	3.762	3.705	3.735	45848840.0
2008-01-31 13:00:00	AMZN	Stock	3.736	3.769	3.713	3.72	49874180.0
2008-01-31 14:00:00	AMZN	Stock	3.7195	3.8355	3.718	3.8305	61544120.0

> showing 50 of 41,707 rows — these rows as CSV

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