PREVIEW / stock_1hour / 2007-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-15.parquet
  size:    796 KB
  rows:    39,662
  symbols: 3,193

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-15 04:00:00	AAPL	Stock	5.8946	5.8946	5.8946	5.8946	2800.0
2007-11-15 05:00:00	AAPL	Stock	5.8575	5.8575	5.8471	5.8489	19600.0
2007-11-15 06:00:00	AAPL	Stock	5.8746	5.875	5.8571	5.8571	42000.0
2007-11-15 07:00:00	AAPL	Stock	5.8571	5.93	5.8571	5.8932	485268.0
2007-11-15 08:00:00	AAPL	Stock	5.8932	6.0607	5.8929	5.935	19960808.0
2007-11-15 09:00:00	AAPL	Stock	5.9407	6.0468	5.9075	5.9436	194751536.0
2007-11-15 10:00:00	AAPL	Stock	5.9432	6.0357	5.9093	5.99	224888104.0
2007-11-15 11:00:00	AAPL	Stock	5.99	6.0568	5.9764	6.0125	160035904.0
2007-11-15 12:00:00	AAPL	Stock	6.0096	6.0268	5.8786	5.925	167091652.0
2007-11-15 13:00:00	AAPL	Stock	5.925	5.9839	5.9186	5.93	135890664.0
2007-11-15 14:00:00	AAPL	Stock	5.9311	5.9643	5.75	5.75	205905392.0
2007-11-15 15:00:00	AAPL	Stock	5.7525	5.8929	5.725	5.8659	352447704.0
2007-11-15 16:00:00	AAPL	Stock	5.8661	5.9946	5.8482	5.8625	17131968.0
2007-11-15 17:00:00	AAPL	Stock	5.8625	5.8679	5.85	5.8571	8769880.0
2007-11-15 18:00:00	AAPL	Stock	5.8571	5.8654	5.8539	5.8625	460712.0
2007-11-15 19:00:00	AAPL	Stock	5.8579	5.8646	5.8579	5.86	283164.0
2007-11-15 05:00:00	MSFT	Stock	33.77	33.77	33.77	33.77	400.0
2007-11-15 07:00:00	MSFT	Stock	33.75	33.75	33.75	33.75	600.0
2007-11-15 08:00:00	MSFT	Stock	33.9	33.93	33.77	33.93	107741.0
2007-11-15 09:00:00	MSFT	Stock	33.8	33.85	33.59	33.75	7662268.0
2007-11-15 10:00:00	MSFT	Stock	33.74	34.1	33.67	33.87	8060683.0
2007-11-15 11:00:00	MSFT	Stock	33.87	33.97	33.7	33.81	6675634.0
2007-11-15 12:00:00	MSFT	Stock	33.82	33.96	33.78	33.88	5040584.0
2007-11-15 13:00:00	MSFT	Stock	33.88	34.04	33.82	33.82	5123199.0
2007-11-15 14:00:00	MSFT	Stock	33.82	33.93	33.69	33.7	8155147.0
2007-11-15 15:00:00	MSFT	Stock	33.71	33.85	33.55	33.7	17078519.0
2007-11-15 16:00:00	MSFT	Stock	33.7	33.836	33.65	33.66	4426563.0
2007-11-15 17:00:00	MSFT	Stock	33.66	33.905	33.66	33.7	779425.0
2007-11-15 18:00:00	MSFT	Stock	33.75	33.75	33.71	33.75	901188.0
2007-11-15 19:00:00	MSFT	Stock	33.71	33.75	33.7	33.75	1700.0
2007-11-15 08:00:00	NVDA	Stock	0.7978	0.8125	0.7975	0.8043	1657760.0
2007-11-15 09:00:00	NVDA	Stock	0.8045	0.8072	0.775	0.7902	69837640.0
2007-11-15 10:00:00	NVDA	Stock	0.7905	0.7958	0.7838	0.7852	72823680.0
2007-11-15 11:00:00	NVDA	Stock	0.7852	0.8	0.783	0.7963	72238560.0
2007-11-15 12:00:00	NVDA	Stock	0.7963	0.8	0.7935	0.7968	56280560.0
2007-11-15 13:00:00	NVDA	Stock	0.7969	0.806	0.7925	0.8033	44210160.0
2007-11-15 14:00:00	NVDA	Stock	0.8033	0.8035	0.7878	0.7883	57440840.0
2007-11-15 15:00:00	NVDA	Stock	0.7883	0.7985	0.7862	0.7938	110063000.0
2007-11-15 16:00:00	NVDA	Stock	0.7952	0.7992	0.7925	0.7925	3397160.0
2007-11-15 17:00:00	NVDA	Stock	0.7868	0.7868	0.7868	0.7868	29800.0
2007-11-15 19:00:00	NVDA	Stock	0.793	0.7948	0.7925	0.7925	67240.0
2007-11-15 05:00:00	AMZN	Stock	3.8885	3.8885	3.8885	3.8885	2000.0
2007-11-15 08:00:00	AMZN	Stock	3.9	4.05	3.9	4.0	2327760.0
2007-11-15 09:00:00	AMZN	Stock	4.005	4.0075	3.905	3.924	25171120.0
2007-11-15 10:00:00	AMZN	Stock	3.923	3.97	3.913	3.936	22469840.0
2007-11-15 11:00:00	AMZN	Stock	3.936	3.9485	3.9	3.914	12910500.0
2007-11-15 12:00:00	AMZN	Stock	3.9145	3.9314	3.876	3.899	14820180.0
2007-11-15 13:00:00	AMZN	Stock	3.8992	3.9205	3.8785	3.895	13830760.0
2007-11-15 14:00:00	AMZN	Stock	3.896	3.9145	3.8625	3.8625	18273340.0
2007-11-15 15:00:00	AMZN	Stock	3.8635	3.908	3.835	3.8965	43070900.0

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

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