PREVIEW / stock_1hour / 2005-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-05.parquet
  size:    569 KB
  rows:    27,165
  symbols: 2,024

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
2005-07-05 07:00:00	AAPL	Stock	1.3054	1.3089	1.3054	1.3082	210000.0
2005-07-05 08:00:00	AAPL	Stock	1.3143	1.3275	1.3125	1.3196	2477916.0
2005-07-05 09:00:00	AAPL	Stock	1.3207	1.3346	1.3036	1.3332	64729140.0
2005-07-05 10:00:00	AAPL	Stock	1.3332	1.3543	1.3304	1.3536	120487360.0
2005-07-05 11:00:00	AAPL	Stock	1.3536	1.355	1.3425	1.3504	57953588.0
2005-07-05 12:00:00	AAPL	Stock	1.35	1.3557	1.3496	1.3525	36452528.0
2005-07-05 13:00:00	AAPL	Stock	1.3518	1.3571	1.3479	1.355	36543584.0
2005-07-05 14:00:00	AAPL	Stock	1.3554	1.3571	1.3514	1.355	33612516.0
2005-07-05 15:00:00	AAPL	Stock	1.3546	1.3625	1.3543	1.3561	94000564.0
2005-07-05 16:00:00	AAPL	Stock	1.3571	1.3575	1.3543	1.3554	1402772.0
2005-07-05 17:00:00	AAPL	Stock	1.3554	1.3621	1.346	1.3607	1924272.0
2005-07-05 18:00:00	AAPL	Stock	1.3607	1.3607	1.3607	1.3607	2800.0
2005-07-05 08:00:00	MSFT	Stock	24.65	24.65	24.61	24.62	21522.0
2005-07-05 09:00:00	MSFT	Stock	24.64	24.74	24.62	24.74	7784251.0
2005-07-05 10:00:00	MSFT	Stock	24.74	25.01	24.66	24.93	13059490.0
2005-07-05 11:00:00	MSFT	Stock	24.92	24.94	24.82	24.88	6558285.0
2005-07-05 12:00:00	MSFT	Stock	24.87	24.93	24.87	24.87	4922570.0
2005-07-05 13:00:00	MSFT	Stock	24.88	24.91	24.84	24.86	7989692.0
2005-07-05 14:00:00	MSFT	Stock	24.87	25.0	24.86	24.98	7670510.0
2005-07-05 15:00:00	MSFT	Stock	24.98	25.19	24.864	24.98	11969661.0
2005-07-05 16:00:00	MSFT	Stock	24.98	24.98	24.91	24.97	394101.0
2005-07-05 17:00:00	MSFT	Stock	24.98	24.98	24.869	24.97	304377.0
2005-07-05 18:00:00	MSFT	Stock	24.97	24.97	24.97	24.97	500.0
2005-07-05 08:00:00	NVDA	Stock	0.2237	0.2252	0.2237	0.2252	322800.0
2005-07-05 09:00:00	NVDA	Stock	0.2236	0.2258	0.2223	0.225	74632920.0
2005-07-05 10:00:00	NVDA	Stock	0.225	0.2273	0.2245	0.2265	70987440.0
2005-07-05 11:00:00	NVDA	Stock	0.2266	0.2267	0.225	0.2255	22032960.0
2005-07-05 12:00:00	NVDA	Stock	0.2256	0.2275	0.2256	0.2274	41058360.0
2005-07-05 13:00:00	NVDA	Stock	0.2275	0.2278	0.2268	0.2275	20701680.0
2005-07-05 14:00:00	NVDA	Stock	0.2275	0.228	0.2267	0.2272	20235360.0
2005-07-05 15:00:00	NVDA	Stock	0.2272	0.2281	0.2263	0.2281	76912560.0
2005-07-05 16:00:00	NVDA	Stock	0.2277	0.2296	0.2271	0.2272	2777880.0
2005-07-05 17:00:00	NVDA	Stock	0.2262	0.2272	0.2262	0.2272	18053160.0
2005-07-05 07:00:00	AMZN	Stock	1.6475	1.6475	1.6475	1.6475	16100.0
2005-07-05 08:00:00	AMZN	Stock	1.6585	1.679	1.6585	1.6725	544720.0
2005-07-05 09:00:00	AMZN	Stock	1.674	1.69	1.6705	1.6845	19724900.0
2005-07-05 10:00:00	AMZN	Stock	1.685	1.71	1.684	1.704	34278400.0
2005-07-05 11:00:00	AMZN	Stock	1.7036	1.7075	1.6975	1.7075	11724680.0
2005-07-05 12:00:00	AMZN	Stock	1.7075	1.713	1.7055	1.711	13539680.0
2005-07-05 13:00:00	AMZN	Stock	1.7105	1.72	1.7085	1.7165	12002080.0
2005-07-05 14:00:00	AMZN	Stock	1.717	1.724	1.7145	1.717	14949540.0
2005-07-05 15:00:00	AMZN	Stock	1.717	1.7196	1.703	1.704	37148580.0
2005-07-05 16:00:00	AMZN	Stock	1.704	1.7121	1.697	1.7055	813660.0
2005-07-05 17:00:00	AMZN	Stock	1.704	1.7055	1.7026	1.7055	88220.0
2005-07-05 18:00:00	AMZN	Stock	1.706	1.706	1.705	1.705	6000.0
2005-07-05 09:00:00	CL	Stock	24.95	24.985	24.865	24.93	326000.0
2005-07-05 10:00:00	CL	Stock	24.93	25.24	24.91	25.23	432400.0
2005-07-05 11:00:00	CL	Stock	25.23	25.315	25.2	25.23	470600.0
2005-07-05 12:00:00	CL	Stock	25.23	25.265	25.1805	25.2	208200.0
2005-07-05 13:00:00	CL	Stock	25.185	25.22	25.035	25.035	350800.0

> showing 50 of 27,165 rows — these rows as CSV

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