PREVIEW / stock_1hour / 2008-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-08.parquet
  size:    872 KB
  rows:    43,400
  symbols: 3,383

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-10-08 04:00:00	AAPL	Stock	3.1607	3.1607	3.0214	3.0532	134680.0
2008-10-08 05:00:00	AAPL	Stock	3.0529	3.0643	3.0529	3.0536	30660.0
2008-10-08 06:00:00	AAPL	Stock	3.0	3.1071	3.0	3.1	307468.0
2008-10-08 07:00:00	AAPL	Stock	3.1214	3.3071	3.1214	3.2814	3017532.0
2008-10-08 08:00:00	AAPL	Stock	3.2775	3.3214	3.0579	3.0982	11935896.0
2008-10-08 09:00:00	AAPL	Stock	3.0957	3.3429	3.0411	3.3111	312031776.0
2008-10-08 10:00:00	AAPL	Stock	3.3107	3.375	3.2071	3.3175	428492876.0
2008-10-08 11:00:00	AAPL	Stock	3.3171	3.3861	3.2339	3.3068	272632584.0
2008-10-08 12:00:00	AAPL	Stock	3.3071	3.3093	3.1696	3.2836	217922348.0
2008-10-08 13:00:00	AAPL	Stock	3.2825	3.4404	3.2779	3.4371	283036768.0
2008-10-08 14:00:00	AAPL	Stock	3.4384	3.4393	3.3225	3.3546	247183916.0
2008-10-08 15:00:00	AAPL	Stock	3.3549	3.4125	3.165	3.2021	364591696.0
2008-10-08 16:00:00	AAPL	Stock	3.1968	3.3429	3.1907	3.1929	30888144.0
2008-10-08 17:00:00	AAPL	Stock	3.195	3.2139	3.1936	3.2139	690312.0
2008-10-08 18:00:00	AAPL	Stock	3.2107	3.2436	3.2075	3.2436	831824.0
2008-10-08 19:00:00	AAPL	Stock	3.2457	3.2625	3.2396	3.25	839496.0
2008-10-08 04:00:00	MSFT	Stock	22.76	22.76	22.0	22.43	4900.0
2008-10-08 05:00:00	MSFT	Stock	22.46	22.48	22.46	22.48	600.0
2008-10-08 06:00:00	MSFT	Stock	22.55	22.9	22.55	22.9	3440.0
2008-10-08 07:00:00	MSFT	Stock	23.2	23.8	23.15	23.41	205577.0
2008-10-08 08:00:00	MSFT	Stock	23.5	23.7	20.82	22.86	587248.0
2008-10-08 09:00:00	MSFT	Stock	22.86	23.86	20.8	23.59	20200678.0
2008-10-08 10:00:00	MSFT	Stock	23.562	23.99	22.89	22.94	31623412.0
2008-10-08 11:00:00	MSFT	Stock	22.94	23.34	22.71	23.06	20897984.0
2008-10-08 12:00:00	MSFT	Stock	23.05	23.2	22.5	23.02	19114308.0
2008-10-08 13:00:00	MSFT	Stock	23.02	24.15	23.01	24.05	22160388.0
2008-10-08 14:00:00	MSFT	Stock	24.05	24.3	22.9	23.76	19216339.0
2008-10-08 15:00:00	MSFT	Stock	23.77	23.95	22.99	23.0	26302114.0
2008-10-08 16:00:00	MSFT	Stock	22.994	23.555	22.83	22.86	4832613.0
2008-10-08 17:00:00	MSFT	Stock	22.99	23.12	22.87	23.12	23470.0
2008-10-08 18:00:00	MSFT	Stock	23.05	23.18	22.9	23.15	9358.0
2008-10-08 19:00:00	MSFT	Stock	23.17	23.33	23.1	23.25	19000.0
2008-10-08 08:00:00	NVDA	Stock	0.183	0.1875	0.1775	0.1775	938560.0
2008-10-08 09:00:00	NVDA	Stock	0.1773	0.1885	0.1713	0.1875	148216880.0
2008-10-08 10:00:00	NVDA	Stock	0.1875	0.1925	0.174	0.1793	201823600.0
2008-10-08 11:00:00	NVDA	Stock	0.1793	0.1855	0.1775	0.1838	184402400.0
2008-10-08 12:00:00	NVDA	Stock	0.1838	0.184	0.177	0.1815	136879560.0
2008-10-08 13:00:00	NVDA	Stock	0.1813	0.1913	0.1813	0.1905	163232680.0
2008-10-08 14:00:00	NVDA	Stock	0.1905	0.1955	0.1893	0.1913	190903160.0
2008-10-08 15:00:00	NVDA	Stock	0.1915	0.193	0.1838	0.1843	170259840.0
2008-10-08 16:00:00	NVDA	Stock	0.184	0.1868	0.1813	0.1813	20823960.0
2008-10-08 17:00:00	NVDA	Stock	0.1813	0.1848	0.1813	0.1848	108000.0
2008-10-08 18:00:00	NVDA	Stock	0.1845	0.1868	0.1845	0.1868	26000.0
2008-10-08 19:00:00	NVDA	Stock	0.1865	0.1868	0.1865	0.1868	28000.0
2008-10-08 04:00:00	AMZN	Stock	2.8765	2.8765	2.8765	2.8765	2000.0
2008-10-08 06:00:00	AMZN	Stock	2.8995	2.903	2.8995	2.903	24000.0
2008-10-08 07:00:00	AMZN	Stock	2.9745	2.9745	2.9745	2.9745	7500.0
2008-10-08 08:00:00	AMZN	Stock	2.9375	3.03	2.7875	2.81	858900.0
2008-10-08 09:00:00	AMZN	Stock	2.81	3.0375	2.7475	2.99	55176280.0
2008-10-08 10:00:00	AMZN	Stock	2.9925	3.097	2.869	2.9525	46278180.0

> showing 50 of 43,400 rows — these rows as CSV

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