PREVIEW / stock_1hour / 2007-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-19.parquet
  size:    805 KB
  rows:    39,836
  symbols: 3,211

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-11-19 06:00:00	AAPL	Stock	5.9286	5.9311	5.9214	5.9311	26600.0
2007-11-19 07:00:00	AAPL	Stock	5.9214	5.9425	5.9018	5.9175	405384.0
2007-11-19 08:00:00	AAPL	Stock	5.9329	5.9329	5.8932	5.9129	4200560.0
2007-11-19 09:00:00	AAPL	Stock	5.9129	6.0071	5.9018	5.9646	163501408.0
2007-11-19 10:00:00	AAPL	Stock	5.9646	5.9986	5.9068	5.9235	179830336.0
2007-11-19 11:00:00	AAPL	Stock	5.9232	5.9357	5.8304	5.8954	161804048.0
2007-11-19 12:00:00	AAPL	Stock	5.8961	5.9318	5.8354	5.8546	110890304.0
2007-11-19 13:00:00	AAPL	Stock	5.855	5.8761	5.7975	5.8014	134723596.0
2007-11-19 14:00:00	AAPL	Stock	5.8018	5.9371	5.7893	5.8914	179439316.0
2007-11-19 15:00:00	AAPL	Stock	5.8911	5.9055	5.7911	5.8571	192167612.0
2007-11-19 16:00:00	AAPL	Stock	5.8571	5.9475	5.8468	5.8857	25685576.0
2007-11-19 17:00:00	AAPL	Stock	5.8893	5.8947	5.8336	5.875	894712.0
2007-11-19 18:00:00	AAPL	Stock	5.8786	5.8929	5.8786	5.8925	331576.0
2007-11-19 19:00:00	AAPL	Stock	5.8911	5.9079	5.8882	5.9068	587412.0
2007-11-19 08:00:00	MSFT	Stock	33.88	33.95	33.87	33.9	3794.0
2007-11-19 09:00:00	MSFT	Stock	33.89	34.24	33.85	34.01	4984288.0
2007-11-19 10:00:00	MSFT	Stock	34.01	34.2	33.98	34.04	8856622.0
2007-11-19 11:00:00	MSFT	Stock	34.03	34.12	33.9	34.02	8428846.0
2007-11-19 12:00:00	MSFT	Stock	34.02	34.22	34.0	34.1	5562916.0
2007-11-19 13:00:00	MSFT	Stock	34.11	34.19	34.02	34.02	6590411.0
2007-11-19 14:00:00	MSFT	Stock	34.02	34.19	34.0	34.098	7858587.0
2007-11-19 15:00:00	MSFT	Stock	34.1	34.1	33.93	33.97	16833989.0
2007-11-19 16:00:00	MSFT	Stock	33.96	34.12	33.9	34.0	3875077.0
2007-11-19 17:00:00	MSFT	Stock	34.01	34.059	33.96	34.0	20371.0
2007-11-19 18:00:00	MSFT	Stock	34.04	34.1	34.02	34.02	13150.0
2007-11-19 19:00:00	MSFT	Stock	34.0	34.01	33.95	33.95	11972.0
2007-11-19 08:00:00	NVDA	Stock	0.8125	0.8125	0.8025	0.8025	112000.0
2007-11-19 09:00:00	NVDA	Stock	0.802	0.8038	0.785	0.7963	40148040.0
2007-11-19 10:00:00	NVDA	Stock	0.7965	0.8012	0.7855	0.786	73233960.0
2007-11-19 11:00:00	NVDA	Stock	0.7858	0.787	0.7738	0.774	55998040.0
2007-11-19 12:00:00	NVDA	Stock	0.774	0.797	0.7732	0.7753	37655120.0
2007-11-19 13:00:00	NVDA	Stock	0.7753	0.7775	0.7618	0.764	67166960.0
2007-11-19 14:00:00	NVDA	Stock	0.764	0.7738	0.7605	0.7655	96535600.0
2007-11-19 15:00:00	NVDA	Stock	0.7655	0.7655	0.7523	0.757	161793480.0
2007-11-19 16:00:00	NVDA	Stock	0.757	0.7724	0.7535	0.7593	16739280.0
2007-11-19 17:00:00	NVDA	Stock	0.761	0.7724	0.761	0.7625	16333000.0
2007-11-19 18:00:00	NVDA	Stock	0.7625	0.7645	0.7625	0.7625	184000.0
2007-11-19 19:00:00	NVDA	Stock	0.7625	0.7643	0.7625	0.7643	52000.0
2007-11-19 07:00:00	AMZN	Stock	3.8815	3.8815	3.8815	3.8815	4000.0
2007-11-19 08:00:00	AMZN	Stock	3.905	3.907	3.905	3.905	37600.0
2007-11-19 09:00:00	AMZN	Stock	3.9075	3.968	3.897	3.958	20340020.0
2007-11-19 10:00:00	AMZN	Stock	3.958	3.9745	3.9015	3.91	33788780.0
2007-11-19 11:00:00	AMZN	Stock	3.9105	3.968	3.9095	3.9605	19629780.0
2007-11-19 12:00:00	AMZN	Stock	3.96	3.9875	3.9505	3.9585	19646500.0
2007-11-19 13:00:00	AMZN	Stock	3.9605	3.968	3.905	3.912	19433160.0
2007-11-19 14:00:00	AMZN	Stock	3.9105	3.985	3.9085	3.963	20615760.0
2007-11-19 15:00:00	AMZN	Stock	3.963	3.985	3.9335	3.9595	30030820.0
2007-11-19 16:00:00	AMZN	Stock	3.9605	3.97	3.93	3.9675	4623540.0
2007-11-19 17:00:00	AMZN	Stock	3.9675	3.9675	3.9505	3.9505	4839040.0
2007-11-19 19:00:00	AMZN	Stock	3.9525	3.96	3.9525	3.96	12420.0

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

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