PREVIEW / stock_1hour / 2007-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-19.parquet
  size:    807 KB
  rows:    39,618
  symbols: 3,151

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
2007-10-19 04:00:00	AAPL	Stock	6.2	6.2	6.2	6.2	2800.0
2007-10-19 06:00:00	AAPL	Stock	6.2104	6.2104	6.2104	6.2104	16800.0
2007-10-19 07:00:00	AAPL	Stock	6.2107	6.25	6.2107	6.2479	424704.0
2007-10-19 08:00:00	AAPL	Stock	6.2479	6.25	6.2214	6.2296	7533876.0
2007-10-19 09:00:00	AAPL	Stock	6.23	6.2414	6.1846	6.2143	185503892.0
2007-10-19 10:00:00	AAPL	Stock	6.2157	6.2204	6.0893	6.0893	243707744.0
2007-10-19 11:00:00	AAPL	Stock	6.0914	6.1761	6.0893	6.1718	172450124.0
2007-10-19 12:00:00	AAPL	Stock	6.1711	6.2111	6.1625	6.1993	134752576.0
2007-10-19 13:00:00	AAPL	Stock	6.1996	6.2021	6.1546	6.19	108928400.0
2007-10-19 14:00:00	AAPL	Stock	6.1896	6.1964	6.16	6.1661	124885348.0
2007-10-19 15:00:00	AAPL	Stock	6.1661	6.1832	6.0714	6.0861	268023756.0
2007-10-19 16:00:00	AAPL	Stock	6.0875	6.1964	6.0797	6.1039	46800936.0
2007-10-19 17:00:00	AAPL	Stock	6.1036	6.1071	6.0829	6.1018	1317876.0
2007-10-19 18:00:00	AAPL	Stock	6.0996	6.1264	6.0996	6.1214	1118208.0
2007-10-19 19:00:00	AAPL	Stock	6.1161	6.1232	6.1107	6.1179	587888.0
2007-10-19 07:00:00	MSFT	Stock	31.08	31.1	31.0	31.1	4257.0
2007-10-19 08:00:00	MSFT	Stock	31.1	31.12	31.01	31.05	9769.0
2007-10-19 09:00:00	MSFT	Stock	31.1	31.1	30.78	30.81	16564534.0
2007-10-19 10:00:00	MSFT	Stock	30.81	30.85	30.55	30.56	9242607.0
2007-10-19 11:00:00	MSFT	Stock	30.55	30.73	30.53	30.65	5680804.0
2007-10-19 12:00:00	MSFT	Stock	30.64	30.835	30.53	30.57	4544369.0
2007-10-19 13:00:00	MSFT	Stock	30.56	30.57	30.42	30.52	5146795.0
2007-10-19 14:00:00	MSFT	Stock	30.51	30.62	30.42	30.45	7955305.0
2007-10-19 15:00:00	MSFT	Stock	30.48	30.51	30.11	30.18	18682536.0
2007-10-19 16:00:00	MSFT	Stock	30.18	31.17	30.17	30.21	6078808.0
2007-10-19 17:00:00	MSFT	Stock	30.27	30.34	30.17	30.34	1287081.0
2007-10-19 18:00:00	MSFT	Stock	30.34	30.35	30.28	30.29	19000.0
2007-10-19 19:00:00	MSFT	Stock	30.3	31.16	30.27	30.31	42861.0
2007-10-19 07:00:00	NVDA	Stock	0.9988	1.0033	0.9988	1.0033	10440.0
2007-10-19 08:00:00	NVDA	Stock	0.9815	0.9838	0.9815	0.9838	528000.0
2007-10-19 09:00:00	NVDA	Stock	0.9838	0.9872	0.9605	0.9665	107725480.0
2007-10-19 10:00:00	NVDA	Stock	0.9665	0.9675	0.9422	0.943	84287600.0
2007-10-19 11:00:00	NVDA	Stock	0.9432	0.9608	0.9425	0.958	60343400.0
2007-10-19 12:00:00	NVDA	Stock	0.958	0.9605	0.95	0.9515	37111760.0
2007-10-19 13:00:00	NVDA	Stock	0.9515	0.9562	0.9435	0.9505	33461720.0
2007-10-19 14:00:00	NVDA	Stock	0.9508	0.956	0.9438	0.9472	39326960.0
2007-10-19 15:00:00	NVDA	Stock	0.9475	0.9488	0.9345	0.9348	110304320.0
2007-10-19 16:00:00	NVDA	Stock	0.9352	0.9878	0.9348	0.9388	18727640.0
2007-10-19 17:00:00	NVDA	Stock	0.9348	0.939	0.9348	0.939	3411800.0
2007-10-19 18:00:00	NVDA	Stock	0.9412	0.9412	0.9412	0.9412	24000.0
2007-10-19 19:00:00	NVDA	Stock	0.9412	0.945	0.9412	0.945	93600.0
2007-10-19 08:00:00	AMZN	Stock	4.55	4.55	4.512	4.518	389840.0
2007-10-19 09:00:00	AMZN	Stock	4.515	4.5325	4.484	4.519	31859420.0
2007-10-19 10:00:00	AMZN	Stock	4.52	4.5215	4.466	4.468	32170800.0
2007-10-19 11:00:00	AMZN	Stock	4.4685	4.506	4.4675	4.4965	23982820.0
2007-10-19 12:00:00	AMZN	Stock	4.4965	4.516	4.4855	4.508	16843220.0
2007-10-19 13:00:00	AMZN	Stock	4.507	4.5245	4.4955	4.51	10355180.0
2007-10-19 14:00:00	AMZN	Stock	4.511	4.519	4.495	4.496	17008680.0
2007-10-19 15:00:00	AMZN	Stock	4.496	4.507	4.485	4.488	41508600.0
2007-10-19 16:00:00	AMZN	Stock	4.5125	4.5125	4.4875	4.4975	8313720.0

> showing 50 of 39,618 rows — these rows as CSV

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