PREVIEW / stock_1hour / 2007-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-03.parquet
  size:    719 KB
  rows:    34,308
  symbols: 2,684

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-03 09:00:00	AAPL	Stock	3.5975	3.6214	3.5954	3.6054	98591472.0
2007-05-03 10:00:00	AAPL	Stock	3.6057	3.6232	3.5957	3.615	104987512.0
2007-05-03 11:00:00	AAPL	Stock	3.6153	3.6161	3.5779	3.6014	111888644.0
2007-05-03 12:00:00	AAPL	Stock	3.6014	3.6071	3.593	3.5995	30840908.0
2007-05-03 13:00:00	AAPL	Stock	3.5993	3.6071	3.5718	3.5904	84727328.0
2007-05-03 14:00:00	AAPL	Stock	3.5904	3.5918	3.5764	3.5829	58155524.0
2007-05-03 15:00:00	AAPL	Stock	3.5832	3.5879	3.5743	3.5857	65799020.0
2007-05-03 16:00:00	AAPL	Stock	3.5857	3.5857	3.5857	3.5857	6027224.0
2007-05-03 09:00:00	MSFT	Stock	30.6	30.77	30.53	30.77	6925719.0
2007-05-03 10:00:00	MSFT	Stock	30.77	30.991	30.75	30.97	19023156.0
2007-05-03 11:00:00	MSFT	Stock	30.97	31.0	30.91	30.97	11258785.0
2007-05-03 12:00:00	MSFT	Stock	30.97	30.99	30.9	30.96	8259997.0
2007-05-03 13:00:00	MSFT	Stock	30.95	30.98	30.93	30.97	6878649.0
2007-05-03 14:00:00	MSFT	Stock	30.97	30.98	30.94	30.98	7840233.0
2007-05-03 15:00:00	MSFT	Stock	30.97	30.99	30.89	30.98	17119294.0
2007-05-03 16:00:00	MSFT	Stock	30.97	30.97	30.97	30.97	1104358.0
2007-05-03 08:00:00	NVDA	Stock	0.5475	0.5567	0.5475	0.5567	1104000.0
2007-05-03 09:00:00	NVDA	Stock	0.5565	0.5583	0.5517	0.5583	67165320.0
2007-05-03 10:00:00	NVDA	Stock	0.5583	0.56	0.5545	0.5598	81421860.0
2007-05-03 11:00:00	NVDA	Stock	0.5597	0.561	0.5538	0.5563	85590060.0
2007-05-03 12:00:00	NVDA	Stock	0.5563	0.558	0.5552	0.5575	36134160.0
2007-05-03 13:00:00	NVDA	Stock	0.5575	0.5585	0.5555	0.5572	32721240.0
2007-05-03 14:00:00	NVDA	Stock	0.5573	0.5605	0.557	0.5605	48768180.0
2007-05-03 15:00:00	NVDA	Stock	0.5605	0.5615	0.5567	0.5578	104342760.0
2007-05-03 16:00:00	NVDA	Stock	0.5575	0.5577	0.5567	0.5567	628560.0
2007-05-03 17:00:00	NVDA	Stock	0.557	0.557	0.557	0.557	16500.0
2007-05-03 18:00:00	NVDA	Stock	0.5575	0.5575	0.5575	0.5575	72000.0
2007-05-03 19:00:00	NVDA	Stock	0.5575	0.5583	0.5567	0.5583	144000.0
2007-05-03 04:00:00	AMZN	Stock	3.0575	3.0575	3.0325	3.0325	33000.0
2007-05-03 07:00:00	AMZN	Stock	3.0545	3.055	3.049	3.0535	56500.0
2007-05-03 08:00:00	AMZN	Stock	3.0535	3.0575	3.051	3.0575	419440.0
2007-05-03 09:00:00	AMZN	Stock	3.0585	3.075	3.038	3.0585	30074100.0
2007-05-03 10:00:00	AMZN	Stock	3.06	3.124	3.0505	3.113	72017600.0
2007-05-03 11:00:00	AMZN	Stock	3.113	3.1215	3.0955	3.113	39726900.0
2007-05-03 12:00:00	AMZN	Stock	3.1135	3.127	3.1005	3.1005	37760380.0
2007-05-03 13:00:00	AMZN	Stock	3.1005	3.1065	3.093	3.098	22001720.0
2007-05-03 14:00:00	AMZN	Stock	3.0985	3.1075	3.0885	3.107	23228060.0
2007-05-03 15:00:00	AMZN	Stock	3.107	3.1125	3.0955	3.109	36975380.0
2007-05-03 16:00:00	AMZN	Stock	3.1095	3.1135	3.104	3.1095	4725620.0
2007-05-03 17:00:00	AMZN	Stock	3.1095	3.1145	3.1095	3.1145	225300.0
2007-05-03 18:00:00	AMZN	Stock	3.112	3.115	3.1115	3.115	477000.0
2007-05-03 19:00:00	AMZN	Stock	3.112	3.12	3.112	3.116	73900.0
2007-05-03 09:00:00	CL	Stock	34.015	34.06	33.865	33.875	546600.0
2007-05-03 10:00:00	CL	Stock	33.89	33.98	33.73	33.78	948200.0
2007-05-03 11:00:00	CL	Stock	33.775	33.805	33.65	33.66	868800.0
2007-05-03 12:00:00	CL	Stock	33.665	33.73	33.58	33.58	898600.0
2007-05-03 13:00:00	CL	Stock	33.585	33.705	33.565	33.705	586800.0
2007-05-03 14:00:00	CL	Stock	33.705	33.77	33.7	33.76	760000.0
2007-05-03 15:00:00	CL	Stock	33.76	33.795	33.685	33.725	937720.0
2007-05-03 16:00:00	CL	Stock	33.73	33.73	33.73	33.73	155600.0

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

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