PREVIEW / stock_1hour / 2007-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-14.parquet
  size:    720 KB
  rows:    34,688
  symbols: 2,759

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-05-14 09:00:00	AAPL	Stock	3.915	3.9286	3.8429	3.9154	91201432.0
2007-05-14 10:00:00	AAPL	Stock	3.9154	3.9229	3.8971	3.9046	117908476.0
2007-05-14 11:00:00	AAPL	Stock	3.905	3.9057	3.8846	3.886	82862864.0
2007-05-14 12:00:00	AAPL	Stock	3.8857	3.8989	3.8857	3.8946	55189960.0
2007-05-14 13:00:00	AAPL	Stock	3.8943	3.9036	3.885	3.8929	73075128.0
2007-05-14 14:00:00	AAPL	Stock	3.8932	3.8957	3.8661	3.8932	86946272.0
2007-05-14 15:00:00	AAPL	Stock	3.8929	3.91	3.8914	3.9079	110090372.0
2007-05-14 16:00:00	AAPL	Stock	3.9075	3.9079	3.9057	3.9057	5308576.0
2007-05-14 09:00:00	MSFT	Stock	30.84	30.93	30.83	30.87	4009008.0
2007-05-14 10:00:00	MSFT	Stock	30.872	30.91	30.81	30.88	5716565.0
2007-05-14 11:00:00	MSFT	Stock	30.89	30.91	30.86	30.88	3777763.0
2007-05-14 12:00:00	MSFT	Stock	30.89	30.97	30.88	30.96	3445224.0
2007-05-14 13:00:00	MSFT	Stock	30.96	30.99	30.87	30.92	8146058.0
2007-05-14 14:00:00	MSFT	Stock	30.92	30.94	30.86	30.9	10803478.0
2007-05-14 15:00:00	MSFT	Stock	30.9	30.99	30.88	30.99	7163894.0
2007-05-14 16:00:00	MSFT	Stock	30.99	30.99	30.97	30.97	1091480.0
2007-05-14 07:00:00	NVDA	Stock	0.5803	0.5803	0.5803	0.5803	6000.0
2007-05-14 08:00:00	NVDA	Stock	0.586	0.5868	0.5817	0.5817	396000.0
2007-05-14 09:00:00	NVDA	Stock	0.5817	0.5888	0.5792	0.5837	107198640.0
2007-05-14 10:00:00	NVDA	Stock	0.5835	0.5842	0.5775	0.5818	130700280.0
2007-05-14 11:00:00	NVDA	Stock	0.5818	0.5822	0.5778	0.5783	87129180.0
2007-05-14 12:00:00	NVDA	Stock	0.5782	0.5802	0.5757	0.578	71236080.0
2007-05-14 13:00:00	NVDA	Stock	0.5782	0.5787	0.575	0.5757	76821180.0
2007-05-14 14:00:00	NVDA	Stock	0.5755	0.5785	0.5743	0.5762	104351460.0
2007-05-14 15:00:00	NVDA	Stock	0.5762	0.5808	0.5758	0.58	135285780.0
2007-05-14 16:00:00	NVDA	Stock	0.58	0.5817	0.579	0.579	6141360.0
2007-05-14 17:00:00	NVDA	Stock	0.5793	0.5805	0.5793	0.5798	158400.0
2007-05-14 18:00:00	NVDA	Stock	0.5792	0.5792	0.5792	0.5792	30600.0
2007-05-14 08:00:00	AMZN	Stock	3.081	3.0895	3.081	3.085	34000.0
2007-05-14 09:00:00	AMZN	Stock	3.085	3.09	3.0625	3.065	14004680.0
2007-05-14 10:00:00	AMZN	Stock	3.065	3.084	3.03	3.0536	34287640.0
2007-05-14 11:00:00	AMZN	Stock	3.0535	3.0575	3.0325	3.057	19019940.0
2007-05-14 12:00:00	AMZN	Stock	3.057	3.0715	3.0515	3.0673	11715760.0
2007-05-14 13:00:00	AMZN	Stock	3.068	3.078	3.051	3.0535	16369660.0
2007-05-14 14:00:00	AMZN	Stock	3.053	3.0615	3.0415	3.0525	20458240.0
2007-05-14 15:00:00	AMZN	Stock	3.053	3.087	3.052	3.0855	30909740.0
2007-05-14 16:00:00	AMZN	Stock	3.0865	3.094	3.085	3.0885	4777940.0
2007-05-14 17:00:00	AMZN	Stock	3.089	3.0915	3.085	3.0915	185040.0
2007-05-14 18:00:00	AMZN	Stock	3.0885	3.09	3.087	3.087	111380.0
2007-05-14 19:00:00	AMZN	Stock	3.087	3.087	3.0865	3.0865	34000.0
2007-05-14 09:00:00	TLT	Stock	88.23	88.23	88.14	88.15	27600.0
2007-05-14 10:00:00	TLT	Stock	88.16	88.28	88.16	88.19	61000.0
2007-05-14 11:00:00	TLT	Stock	88.2	88.2	88.08	88.08	31300.0
2007-05-14 12:00:00	TLT	Stock	88.08	88.11	88.05	88.06	18300.0
2007-05-14 13:00:00	TLT	Stock	88.06	88.07	88.02	88.02	17300.0
2007-05-14 14:00:00	TLT	Stock	88.02	88.07	88.02	88.04	42400.0
2007-05-14 15:00:00	TLT	Stock	88.03	88.05	87.97	87.98	115400.0
2007-05-14 16:00:00	TLT	Stock	87.96	87.96	87.96	87.96	1400.0
2007-05-14 08:00:00	CL	Stock	33.5	33.5	33.5	33.5	200.0
2007-05-14 09:00:00	CL	Stock	33.48	33.51	33.2	33.215	1120800.0

> showing 50 of 34,688 rows — these rows as CSV

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