PREVIEW / stock_1hour / 2008-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-03.parquet
  size:    799 KB
  rows:    40,248
  symbols: 3,325

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-03 06:00:00	AAPL	Stock	3.8732	3.8732	3.8286	3.8293	44800.0
2008-11-03 07:00:00	AAPL	Stock	3.8571	3.8732	3.8218	3.8225	224168.0
2008-11-03 08:00:00	AAPL	Stock	3.8371	3.8429	3.7768	3.7893	5765592.0
2008-11-03 09:00:00	AAPL	Stock	3.79	3.85	3.7443	3.8364	157499104.0
2008-11-03 10:00:00	AAPL	Stock	3.8368	3.8964	3.825	3.855	220513020.0
2008-11-03 11:00:00	AAPL	Stock	3.8554	3.8593	3.8375	3.8521	97516160.0
2008-11-03 12:00:00	AAPL	Stock	3.8524	3.8746	3.8482	3.8621	93796724.0
2008-11-03 13:00:00	AAPL	Stock	3.862	3.8889	3.8493	3.855	88367552.0
2008-11-03 14:00:00	AAPL	Stock	3.8554	3.8586	3.7907	3.7946	143487512.0
2008-11-03 15:00:00	AAPL	Stock	3.7954	3.8375	3.7668	3.8196	218948660.0
2008-11-03 16:00:00	AAPL	Stock	3.8193	3.8587	3.8075	3.8096	21300944.0
2008-11-03 17:00:00	AAPL	Stock	3.8139	3.8343	3.8107	3.8157	191240.0
2008-11-03 18:00:00	AAPL	Stock	3.8161	3.8161	3.8125	3.8129	190176.0
2008-11-03 19:00:00	AAPL	Stock	3.8111	3.8168	3.8107	3.8107	336280.0
2008-11-03 07:00:00	MSFT	Stock	22.34	22.66	22.33	22.66	2000.0
2008-11-03 08:00:00	MSFT	Stock	22.55	22.58	22.33	22.45	13933.0
2008-11-03 09:00:00	MSFT	Stock	22.45	22.6	22.21	22.5	6159373.0
2008-11-03 10:00:00	MSFT	Stock	22.5	22.6	22.32	22.55	10296926.0
2008-11-03 11:00:00	MSFT	Stock	22.55	22.85	22.45	22.8	6793935.0
2008-11-03 12:00:00	MSFT	Stock	22.8	22.9	22.45	22.88	5736032.0
2008-11-03 13:00:00	MSFT	Stock	22.88	22.91	22.69	22.74	6639204.0
2008-11-03 14:00:00	MSFT	Stock	22.75	22.84	22.62	22.69	6017981.0
2008-11-03 15:00:00	MSFT	Stock	22.7	22.77	22.55	22.64	13090965.0
2008-11-03 16:00:00	MSFT	Stock	22.65	22.825	22.407	22.71	4107417.0
2008-11-03 17:00:00	MSFT	Stock	22.69	22.71	22.62	22.71	7989.0
2008-11-03 18:00:00	MSFT	Stock	22.72	22.72	22.63	22.72	1000.0
2008-11-03 19:00:00	MSFT	Stock	22.68	22.78	22.67	22.75	22250.0
2008-11-03 06:00:00	NVDA	Stock	0.225	0.225	0.225	0.225	20000.0
2008-11-03 07:00:00	NVDA	Stock	0.225	0.225	0.225	0.225	12000.0
2008-11-03 08:00:00	NVDA	Stock	0.2238	0.2243	0.2205	0.2243	524480.0
2008-11-03 09:00:00	NVDA	Stock	0.2212	0.2278	0.219	0.225	83459280.0
2008-11-03 10:00:00	NVDA	Stock	0.225	0.2278	0.2235	0.2238	102752440.0
2008-11-03 11:00:00	NVDA	Stock	0.2235	0.2255	0.2192	0.2198	76609400.0
2008-11-03 12:00:00	NVDA	Stock	0.22	0.2245	0.2192	0.2218	66325240.0
2008-11-03 13:00:00	NVDA	Stock	0.2218	0.2238	0.2205	0.2208	49384280.0
2008-11-03 14:00:00	NVDA	Stock	0.2208	0.2208	0.2141	0.2143	90422920.0
2008-11-03 15:00:00	NVDA	Stock	0.2143	0.2143	0.2075	0.2098	238215120.0
2008-11-03 16:00:00	NVDA	Stock	0.2095	0.2238	0.209	0.213	13329000.0
2008-11-03 17:00:00	NVDA	Stock	0.2132	0.2183	0.2125	0.2163	557720.0
2008-11-03 18:00:00	NVDA	Stock	0.215	0.215	0.2115	0.2118	96000.0
2008-11-03 19:00:00	NVDA	Stock	0.2108	0.216	0.2108	0.216	48600.0
2008-11-03 07:00:00	AMZN	Stock	2.85	2.85	2.85	2.85	14000.0
2008-11-03 08:00:00	AMZN	Stock	2.85	2.85	2.801	2.8175	109160.0
2008-11-03 09:00:00	AMZN	Stock	2.815	2.8615	2.7915	2.823	15869740.0
2008-11-03 10:00:00	AMZN	Stock	2.8235	2.859	2.7925	2.8525	20841680.0
2008-11-03 11:00:00	AMZN	Stock	2.855	2.8625	2.829	2.8485	11187740.0
2008-11-03 12:00:00	AMZN	Stock	2.849	2.8575	2.8355	2.84	9011820.0
2008-11-03 13:00:00	AMZN	Stock	2.8395	2.854	2.8225	2.8295	9914860.0
2008-11-03 14:00:00	AMZN	Stock	2.83	2.831	2.7865	2.794	16322120.0
2008-11-03 15:00:00	AMZN	Stock	2.7925	2.8015	2.751	2.7885	32643000.0

> showing 50 of 40,248 rows — these rows as CSV

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