PREVIEW / stock_1hour / 2008-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-31.parquet
  size:    847 KB
  rows:    42,790
  symbols: 3,358

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-31 04:00:00	AAPL	Stock	3.9386	3.9386	3.8596	3.9196	66360.0
2008-10-31 06:00:00	AAPL	Stock	3.8929	3.8929	3.8929	3.8929	28000.0
2008-10-31 07:00:00	AAPL	Stock	3.9532	3.9532	3.9107	3.9179	106820.0
2008-10-31 08:00:00	AAPL	Stock	3.9243	3.9396	3.8968	3.9286	4394348.0
2008-10-31 09:00:00	AAPL	Stock	3.9339	3.9375	3.755	3.7882	256122664.0
2008-10-31 10:00:00	AAPL	Stock	3.7875	3.8571	3.7679	3.8175	272116264.0
2008-10-31 11:00:00	AAPL	Stock	3.8175	3.8882	3.7979	3.8732	222895372.0
2008-10-31 12:00:00	AAPL	Stock	3.8725	3.8775	3.8332	3.8668	123038860.0
2008-10-31 13:00:00	AAPL	Stock	3.8661	3.925	3.8571	3.8986	166086760.0
2008-10-31 14:00:00	AAPL	Stock	3.8989	3.9482	3.8454	3.9379	226760492.0
2008-10-31 15:00:00	AAPL	Stock	3.9379	3.9564	3.8107	3.8514	324130464.0
2008-10-31 16:00:00	AAPL	Stock	3.8554	3.8849	3.8357	3.8529	34250888.0
2008-10-31 17:00:00	AAPL	Stock	3.8529	3.8589	3.8386	3.8571	6721652.0
2008-10-31 18:00:00	AAPL	Stock	3.8571	3.8604	3.8536	3.8543	287140.0
2008-10-31 19:00:00	AAPL	Stock	3.8543	3.8607	3.8536	3.8607	168504.0
2008-10-31 08:00:00	MSFT	Stock	22.5	22.79	22.41	22.59	33514.0
2008-10-31 09:00:00	MSFT	Stock	22.63	22.78	22.12	22.25	9714372.0
2008-10-31 10:00:00	MSFT	Stock	22.25	22.54	22.23	22.36	10256954.0
2008-10-31 11:00:00	MSFT	Stock	22.36	22.51	22.2	22.327	11417123.0
2008-10-31 12:00:00	MSFT	Stock	22.33	22.47	22.25	22.411	7279758.0
2008-10-31 13:00:00	MSFT	Stock	22.411	22.91	22.39	22.699	8277525.0
2008-10-31 14:00:00	MSFT	Stock	22.69	22.85	22.53	22.735	9365410.0
2008-10-31 15:00:00	MSFT	Stock	22.74	22.91	22.21	22.41	21938525.0
2008-10-31 16:00:00	MSFT	Stock	22.41	22.592	22.325	22.42	12094125.0
2008-10-31 17:00:00	MSFT	Stock	22.45	22.59	22.33	22.47	1030947.0
2008-10-31 18:00:00	MSFT	Stock	22.47	22.48	22.44	22.46	5724.0
2008-10-31 19:00:00	MSFT	Stock	22.48	22.53	22.46	22.46	6515.0
2008-10-31 09:00:00	NVDA	Stock	0.2125	0.2152	0.2085	0.2145	68720800.0
2008-10-31 10:00:00	NVDA	Stock	0.2143	0.2212	0.214	0.217	90218920.0
2008-10-31 11:00:00	NVDA	Stock	0.217	0.2232	0.2169	0.2215	74050000.0
2008-10-31 12:00:00	NVDA	Stock	0.2218	0.2223	0.216	0.2185	49843160.0
2008-10-31 13:00:00	NVDA	Stock	0.2185	0.2232	0.218	0.2192	62599400.0
2008-10-31 14:00:00	NVDA	Stock	0.219	0.2212	0.2165	0.221	84481080.0
2008-10-31 15:00:00	NVDA	Stock	0.221	0.223	0.2148	0.219	147489720.0
2008-10-31 16:00:00	NVDA	Stock	0.219	0.2192	0.2181	0.219	23564360.0
2008-10-31 17:00:00	NVDA	Stock	0.2192	0.2192	0.2175	0.219	3724240.0
2008-10-31 19:00:00	NVDA	Stock	0.2175	0.2185	0.2175	0.2175	181200.0
2008-10-31 04:00:00	AMZN	Stock	2.82	2.82	2.82	2.82	6000.0
2008-10-31 08:00:00	AMZN	Stock	2.812	2.833	2.79	2.81	202100.0
2008-10-31 09:00:00	AMZN	Stock	2.8175	2.8355	2.775	2.7985	18454800.0
2008-10-31 10:00:00	AMZN	Stock	2.797	2.8395	2.7635	2.7775	23136360.0
2008-10-31 11:00:00	AMZN	Stock	2.778	2.8045	2.7605	2.794	13991260.0
2008-10-31 12:00:00	AMZN	Stock	2.795	2.7995	2.764	2.7985	11443740.0
2008-10-31 13:00:00	AMZN	Stock	2.798	2.8485	2.791	2.8055	22207460.0
2008-10-31 14:00:00	AMZN	Stock	2.804	2.8105	2.777	2.8035	15950200.0
2008-10-31 15:00:00	AMZN	Stock	2.804	2.8625	2.7505	2.862	53297080.0
2008-10-31 16:00:00	AMZN	Stock	2.862	2.8643	2.7948	2.8495	8742280.0
2008-10-31 17:00:00	AMZN	Stock	2.8355	2.8648	2.8355	2.862	1559040.0
2008-10-31 18:00:00	AMZN	Stock	2.85	2.85	2.85	2.85	20000.0
2008-10-31 19:00:00	AMZN	Stock	2.85	2.85	2.85	2.85	12000.0

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

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