PREVIEW / stock_1hour / 2007-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-25.parquet
  size:    762 KB
  rows:    36,983
  symbols: 3,042

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-06-25 09:00:00	AAPL	Stock	4.4354	4.4407	4.3929	4.4169	106048964.0
2007-06-25 10:00:00	AAPL	Stock	4.4168	4.4639	4.4057	4.4639	156407272.0
2007-06-25 11:00:00	AAPL	Stock	4.4639	4.4643	4.4386	4.4602	122772356.0
2007-06-25 12:00:00	AAPL	Stock	4.4604	4.4675	4.4475	4.4525	67655616.0
2007-06-25 13:00:00	AAPL	Stock	4.4525	4.4539	4.4161	4.4175	83106128.0
2007-06-25 14:00:00	AAPL	Stock	4.4173	4.4236	4.3375	4.3493	214299680.0
2007-06-25 15:00:00	AAPL	Stock	4.3493	4.3779	4.3236	4.3696	188732684.0
2007-06-25 16:00:00	AAPL	Stock	4.3654	4.3693	4.3654	4.3693	5154996.0
2007-06-25 09:00:00	MSFT	Stock	29.47	29.55	29.38	29.47	5483042.0
2007-06-25 10:00:00	MSFT	Stock	29.47	29.69	29.45	29.68	8335083.0
2007-06-25 11:00:00	MSFT	Stock	29.68	29.75	29.61	29.652	4935537.0
2007-06-25 12:00:00	MSFT	Stock	29.65	29.74	29.65	29.67	3197023.0
2007-06-25 13:00:00	MSFT	Stock	29.67	29.77	29.65	29.68	4662275.0
2007-06-25 14:00:00	MSFT	Stock	29.69	29.73	29.45	29.54	8655126.0
2007-06-25 15:00:00	MSFT	Stock	29.54	29.598	29.41	29.51	10430741.0
2007-06-25 16:00:00	MSFT	Stock	29.51	29.51	29.49	29.49	1229584.0
2007-06-25 07:00:00	NVDA	Stock	0.705	0.711	0.705	0.7088	36000.0
2007-06-25 08:00:00	NVDA	Stock	0.7083	0.7125	0.705	0.7067	2864220.0
2007-06-25 09:00:00	NVDA	Stock	0.706	0.7147	0.7002	0.7123	152815380.0
2007-06-25 10:00:00	NVDA	Stock	0.7125	0.7223	0.7117	0.7205	167275560.0
2007-06-25 11:00:00	NVDA	Stock	0.7207	0.724	0.7177	0.7188	88419000.0
2007-06-25 12:00:00	NVDA	Stock	0.7187	0.7218	0.7138	0.7153	70102920.0
2007-06-25 13:00:00	NVDA	Stock	0.7153	0.719	0.7112	0.7122	59418540.0
2007-06-25 14:00:00	NVDA	Stock	0.712	0.7165	0.7042	0.705	104474640.0
2007-06-25 15:00:00	NVDA	Stock	0.705	0.7107	0.7013	0.708	136518840.0
2007-06-25 16:00:00	NVDA	Stock	0.708	0.7097	0.7078	0.7097	5972400.0
2007-06-25 17:00:00	NVDA	Stock	0.7097	0.7105	0.7092	0.7105	165000.0
2007-06-25 18:00:00	NVDA	Stock	0.7083	0.7083	0.7083	0.7083	84000.0
2007-06-25 19:00:00	NVDA	Stock	0.7103	0.7103	0.7093	0.7103	138000.0
2007-06-25 08:00:00	AMZN	Stock	3.438	3.4475	3.438	3.4475	10000.0
2007-06-25 09:00:00	AMZN	Stock	3.4475	3.474	3.415	3.432	21655100.0
2007-06-25 10:00:00	AMZN	Stock	3.433	3.4565	3.424	3.446	22713440.0
2007-06-25 11:00:00	AMZN	Stock	3.446	3.46	3.44	3.459	12450440.0
2007-06-25 12:00:00	AMZN	Stock	3.4585	3.4815	3.4585	3.4685	13809240.0
2007-06-25 13:00:00	AMZN	Stock	3.4685	3.474	3.455	3.4555	8855160.0
2007-06-25 14:00:00	AMZN	Stock	3.4555	3.4663	3.423	3.4305	22337840.0
2007-06-25 15:00:00	AMZN	Stock	3.4305	3.4455	3.4195	3.4355	40499640.0
2007-06-25 16:00:00	AMZN	Stock	3.4355	3.4365	3.4275	3.432	7121800.0
2007-06-25 17:00:00	AMZN	Stock	3.432	3.432	3.429	3.432	61960.0
2007-06-25 18:00:00	AMZN	Stock	3.43	3.43	3.43	3.43	10000.0
2007-06-25 19:00:00	AMZN	Stock	3.43	3.43	3.429	3.429	44000.0
2007-06-25 09:00:00	TLT	Stock	84.15	84.35	84.12	84.27	252700.0
2007-06-25 10:00:00	TLT	Stock	84.28	84.34	84.02	84.02	285500.0
2007-06-25 11:00:00	TLT	Stock	84.02	84.1	83.99	84.03	95300.0
2007-06-25 12:00:00	TLT	Stock	84.03	84.05	83.96	84.01	91200.0
2007-06-25 13:00:00	TLT	Stock	84.02	84.08	83.99	84.08	56400.0
2007-06-25 14:00:00	TLT	Stock	84.09	84.32	84.09	84.3	209800.0
2007-06-25 15:00:00	TLT	Stock	84.31	84.32	84.15	84.16	258000.0
2007-06-25 16:00:00	TLT	Stock	84.22	84.22	84.22	84.22	1300.0
2007-06-25 09:00:00	CL	Stock	32.685	32.87	32.685	32.77	608800.0

> showing 50 of 36,983 rows — these rows as CSV

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