PREVIEW / stock_1hour / 2008-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-13.parquet
  size:    818 KB
  rows:    41,219
  symbols: 3,327

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-11-13 05:00:00	AAPL	Stock	3.1746	3.1814	3.1429	3.1429	50512.0
2008-11-13 06:00:00	AAPL	Stock	3.1429	3.1607	3.1429	3.1607	46088.0
2008-11-13 07:00:00	AAPL	Stock	3.1807	3.2679	3.1807	3.2	628040.0
2008-11-13 08:00:00	AAPL	Stock	3.2	3.2064	3.1596	3.1611	3707060.0
2008-11-13 09:00:00	AAPL	Stock	3.1621	3.2732	3.1621	3.1782	198240336.0
2008-11-13 10:00:00	AAPL	Stock	3.1775	3.2589	3.1436	3.2075	332790780.0
2008-11-13 11:00:00	AAPL	Stock	3.2082	3.2221	3.1625	3.1818	157604692.0
2008-11-13 12:00:00	AAPL	Stock	3.1819	3.1896	3.0739	3.0739	166361440.0
2008-11-13 13:00:00	AAPL	Stock	3.0754	3.25	3.0721	3.1934	271280044.0
2008-11-13 14:00:00	AAPL	Stock	3.1936	3.3768	3.1829	3.3304	348741904.0
2008-11-13 15:00:00	AAPL	Stock	3.3318	3.4429	3.2857	3.4404	310596188.0
2008-11-13 16:00:00	AAPL	Stock	3.4404	3.4821	3.2106	3.4375	37163560.0
2008-11-13 17:00:00	AAPL	Stock	3.4357	3.4429	3.4346	3.4354	794696.0
2008-11-13 18:00:00	AAPL	Stock	3.4354	3.4393	3.4325	3.4339	513800.0
2008-11-13 19:00:00	AAPL	Stock	3.4339	3.4357	3.4239	3.4268	812756.0
2008-11-13 04:00:00	MSFT	Stock	20.0	20.2	20.0	20.2	800.0
2008-11-13 06:00:00	MSFT	Stock	20.01	20.19	20.01	20.19	1500.0
2008-11-13 07:00:00	MSFT	Stock	20.07	20.15	20.06	20.13	27478.0
2008-11-13 08:00:00	MSFT	Stock	20.13	20.15	20.0	20.15	45637.0
2008-11-13 09:00:00	MSFT	Stock	20.15	20.3	19.6	19.72	12748393.0
2008-11-13 10:00:00	MSFT	Stock	19.71	20.0	19.51	19.62	18613583.0
2008-11-13 11:00:00	MSFT	Stock	19.61	19.68	19.27	19.35	12352647.0
2008-11-13 12:00:00	MSFT	Stock	19.34	19.39	18.75	18.75	17491799.0
2008-11-13 13:00:00	MSFT	Stock	18.75	19.83	18.74	19.48	20826438.0
2008-11-13 14:00:00	MSFT	Stock	19.48	20.4	19.34	20.09	22792491.0
2008-11-13 15:00:00	MSFT	Stock	20.09	21.24	19.82	21.24	34028044.0
2008-11-13 16:00:00	MSFT	Stock	21.24	22.99	19.612	21.12	7034012.0
2008-11-13 17:00:00	MSFT	Stock	21.12	21.24	19.06	21.18	151123.0
2008-11-13 18:00:00	MSFT	Stock	21.24	21.25	19.809	21.11	71938.0
2008-11-13 19:00:00	MSFT	Stock	21.11	21.12	21.08	21.12	30403.0
2008-11-13 04:00:00	NVDA	Stock	0.178	0.178	0.178	0.178	4000.0
2008-11-13 08:00:00	NVDA	Stock	0.1725	0.175	0.1713	0.175	346520.0
2008-11-13 09:00:00	NVDA	Stock	0.175	0.183	0.175	0.1768	67037760.0
2008-11-13 10:00:00	NVDA	Stock	0.1768	0.181	0.176	0.1803	102923640.0
2008-11-13 11:00:00	NVDA	Stock	0.1803	0.182	0.1783	0.1815	72234560.0
2008-11-13 12:00:00	NVDA	Stock	0.1815	0.1823	0.1718	0.1718	110558440.0
2008-11-13 13:00:00	NVDA	Stock	0.1718	0.185	0.1715	0.1818	118256680.0
2008-11-13 14:00:00	NVDA	Stock	0.1815	0.1928	0.1788	0.1895	115814560.0
2008-11-13 15:00:00	NVDA	Stock	0.1893	0.1988	0.1848	0.1982	180340160.0
2008-11-13 16:00:00	NVDA	Stock	0.1985	0.2002	0.178	0.1985	9418880.0
2008-11-13 17:00:00	NVDA	Stock	0.1962	0.1985	0.1962	0.1985	70000.0
2008-11-13 18:00:00	NVDA	Stock	0.195	0.195	0.1948	0.1948	66000.0
2008-11-13 19:00:00	NVDA	Stock	0.1938	0.1962	0.1938	0.1962	18000.0
2008-11-13 07:00:00	AMZN	Stock	2.044	2.044	2.044	2.044	6000.0
2008-11-13 08:00:00	AMZN	Stock	2.0645	2.0645	2.05	2.06	66700.0
2008-11-13 09:00:00	AMZN	Stock	2.07	2.1105	2.0	2.0018	29711500.0
2008-11-13 10:00:00	AMZN	Stock	2.004	2.0825	1.9925	2.0665	44575140.0
2008-11-13 11:00:00	AMZN	Stock	2.065	2.071	2.0355	2.042	23880060.0
2008-11-13 12:00:00	AMZN	Stock	2.0425	2.051	1.924	1.925	26905840.0
2008-11-13 13:00:00	AMZN	Stock	1.925	2.077	1.9245	2.039	48645180.0

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

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