PREVIEW / stock_1hour / 2007-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-15.parquet
  size:    731 KB
  rows:    34,949
  symbols: 2,757

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-15 09:00:00	AAPL	Stock	3.9132	3.92	3.8868	3.9171	88732140.0
2007-05-15 10:00:00	AAPL	Stock	3.9168	3.9357	3.9143	3.9189	158884068.0
2007-05-15 11:00:00	AAPL	Stock	3.9189	3.9243	3.8957	3.9161	104530776.0
2007-05-15 12:00:00	AAPL	Stock	3.9168	3.9243	3.8925	3.8929	70890064.0
2007-05-15 13:00:00	AAPL	Stock	3.8929	3.9004	3.8607	3.8693	104494516.0
2007-05-15 14:00:00	AAPL	Stock	3.8693	3.8729	3.8029	3.8211	219913176.0
2007-05-15 15:00:00	AAPL	Stock	3.8214	3.8568	3.8157	3.84	192878084.0
2007-05-15 16:00:00	AAPL	Stock	3.8396	3.8407	3.8396	3.84	5988108.0
2007-05-15 09:00:00	MSFT	Stock	30.9	30.97	30.84	30.94	4075214.0
2007-05-15 10:00:00	MSFT	Stock	30.94	31.0	30.91	30.971	12229503.0
2007-05-15 11:00:00	MSFT	Stock	30.97	31.06	30.96	30.98	14060088.0
2007-05-15 12:00:00	MSFT	Stock	30.98	31.06	30.98	31.0	6555744.0
2007-05-15 13:00:00	MSFT	Stock	31.0	31.09	30.98	31.02	7816168.0
2007-05-15 14:00:00	MSFT	Stock	31.03	31.08	30.94	31.02	10152989.0
2007-05-15 15:00:00	MSFT	Stock	31.02	31.03	30.88	30.923	11937771.0
2007-05-15 16:00:00	MSFT	Stock	30.92	30.93	30.9	30.9	1053710.0
2007-05-15 08:00:00	NVDA	Stock	0.5832	0.5847	0.5802	0.5835	492000.0
2007-05-15 09:00:00	NVDA	Stock	0.5835	0.585	0.5772	0.583	88163400.0
2007-05-15 10:00:00	NVDA	Stock	0.583	0.5848	0.5777	0.5785	95469300.0
2007-05-15 11:00:00	NVDA	Stock	0.5783	0.5833	0.5775	0.5828	67444740.0
2007-05-15 12:00:00	NVDA	Stock	0.583	0.5833	0.5802	0.5807	53819580.0
2007-05-15 13:00:00	NVDA	Stock	0.5808	0.5817	0.5782	0.5805	58438620.0
2007-05-15 14:00:00	NVDA	Stock	0.5803	0.581	0.5743	0.5763	87945600.0
2007-05-15 15:00:00	NVDA	Stock	0.5762	0.5768	0.5733	0.5745	106840020.0
2007-05-15 16:00:00	NVDA	Stock	0.5747	0.5755	0.5737	0.5755	10871640.0
2007-05-15 17:00:00	NVDA	Stock	0.5757	0.5792	0.5755	0.5792	138000.0
2007-05-15 18:00:00	NVDA	Stock	0.5755	0.5755	0.5755	0.5755	132000.0
2007-05-15 19:00:00	NVDA	Stock	0.5767	0.5767	0.5767	0.5767	60000.0
2007-05-15 07:00:00	AMZN	Stock	3.0785	3.0785	3.0785	3.0785	2000.0
2007-05-15 08:00:00	AMZN	Stock	3.0775	3.0785	3.064	3.07	652380.0
2007-05-15 09:00:00	AMZN	Stock	3.07	3.09	3.035	3.0555	20730720.0
2007-05-15 10:00:00	AMZN	Stock	3.0555	3.0975	3.0555	3.076	31716860.0
2007-05-15 11:00:00	AMZN	Stock	3.077	3.0895	3.0655	3.0794	15433960.0
2007-05-15 12:00:00	AMZN	Stock	3.0795	3.0985	3.078	3.0785	14233640.0
2007-05-15 13:00:00	AMZN	Stock	3.0785	3.088	3.059	3.07	15403820.0
2007-05-15 14:00:00	AMZN	Stock	3.07	3.0725	3.0405	3.0535	28596580.0
2007-05-15 15:00:00	AMZN	Stock	3.053	3.055	3.026	3.029	42126720.0
2007-05-15 16:00:00	AMZN	Stock	3.032	3.032	3.028	3.03	2504700.0
2007-05-15 17:00:00	AMZN	Stock	3.028	3.0335	3.0275	3.0335	70700.0
2007-05-15 18:00:00	AMZN	Stock	3.028	3.0345	3.028	3.0345	45000.0
2007-05-15 19:00:00	AMZN	Stock	3.0345	3.039	3.0345	3.0375	22000.0
2007-05-15 09:00:00	TLT	Stock	88.19	88.21	88.12	88.17	22400.0
2007-05-15 10:00:00	TLT	Stock	88.17	88.17	87.92	87.96	58500.0
2007-05-15 11:00:00	TLT	Stock	87.96	88.0	87.92	87.99	58100.0
2007-05-15 12:00:00	TLT	Stock	87.99	88.04	87.98	88.02	45600.0
2007-05-15 13:00:00	TLT	Stock	88.02	88.04	87.66	87.74	116400.0
2007-05-15 14:00:00	TLT	Stock	87.74	87.84	87.73	87.84	48700.0
2007-05-15 15:00:00	TLT	Stock	87.82	87.89	87.82	87.84	32000.0
2007-05-15 16:00:00	TLT	Stock	87.93	87.93	87.93	87.93	700.0
2007-05-15 09:00:00	CL	Stock	33.2	33.325	33.145	33.22	413000.0

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

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