PREVIEW / stock_1hour / 2006-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-28.parquet
  size:    593 KB
  rows:    28,432
  symbols: 2,286

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
2006-06-28 07:00:00	AAPL	Stock	2.0482	2.0571	2.0464	2.0464	96600.0
2006-06-28 08:00:00	AAPL	Stock	2.0589	2.0589	2.04	2.0464	3675616.0
2006-06-28 09:00:00	AAPL	Stock	2.0454	2.0468	1.9957	2.0011	175400428.0
2006-06-28 10:00:00	AAPL	Stock	2.0011	2.0161	1.9943	2.0044	164884664.0
2006-06-28 11:00:00	AAPL	Stock	2.0046	2.0064	1.9789	1.9882	139716668.0
2006-06-28 12:00:00	AAPL	Stock	1.9882	1.9964	1.9854	1.9889	66866884.0
2006-06-28 13:00:00	AAPL	Stock	1.9893	1.9907	1.9804	1.9904	68730424.0
2006-06-28 14:00:00	AAPL	Stock	1.9904	2.005	1.9879	1.9932	106798748.0
2006-06-28 15:00:00	AAPL	Stock	1.9932	2.0018	1.9904	2.0014	111588288.0
2006-06-28 16:00:00	AAPL	Stock	2.0014	2.0018	1.9929	1.9936	1959748.0
2006-06-28 17:00:00	AAPL	Stock	1.9946	1.9993	1.9932	1.9993	445200.0
2006-06-28 18:00:00	AAPL	Stock	1.9993	2.0014	1.9993	2.0014	367080.0
2006-06-28 08:00:00	MSFT	Stock	22.99	23.06	22.95	23.0	48427.0
2006-06-28 09:00:00	MSFT	Stock	23.0	23.2	22.91	23.12	9118908.0
2006-06-28 10:00:00	MSFT	Stock	23.12	23.14	23.02	23.07	10484694.0
2006-06-28 11:00:00	MSFT	Stock	23.07	23.08	23.02	23.072	5585475.0
2006-06-28 12:00:00	MSFT	Stock	23.08	23.09	23.03	23.07	6408868.0
2006-06-28 13:00:00	MSFT	Stock	23.06	23.08	23.06	23.07	3666292.0
2006-06-28 14:00:00	MSFT	Stock	23.07	23.2	23.06	23.16	11595312.0
2006-06-28 15:00:00	MSFT	Stock	23.16	23.25	23.1	23.19	14476379.0
2006-06-28 16:00:00	MSFT	Stock	23.2	23.21	23.14	23.19	569022.0
2006-06-28 17:00:00	MSFT	Stock	23.15	23.19	23.15	23.16	2200.0
2006-06-28 18:00:00	MSFT	Stock	23.16	23.16	23.16	23.16	19339.0
2006-06-28 08:00:00	NVDA	Stock	0.3248	0.3248	0.3228	0.3228	150000.0
2006-06-28 09:00:00	NVDA	Stock	0.3238	0.3273	0.3187	0.3222	42705360.0
2006-06-28 10:00:00	NVDA	Stock	0.3223	0.328	0.3223	0.3277	72195600.0
2006-06-28 11:00:00	NVDA	Stock	0.3277	0.3312	0.3262	0.3312	197443560.0
2006-06-28 12:00:00	NVDA	Stock	0.331	0.3367	0.331	0.335	105215160.0
2006-06-28 13:00:00	NVDA	Stock	0.335	0.3383	0.3345	0.3382	83618940.0
2006-06-28 14:00:00	NVDA	Stock	0.338	0.3427	0.3373	0.3425	129304020.0
2006-06-28 15:00:00	NVDA	Stock	0.3425	0.348	0.3405	0.3425	185673360.0
2006-06-28 16:00:00	NVDA	Stock	0.3422	0.3433	0.3417	0.3427	799080.0
2006-06-28 17:00:00	NVDA	Stock	0.3427	0.3427	0.3423	0.3423	54000.0
2006-06-28 18:00:00	NVDA	Stock	0.3427	0.3427	0.3423	0.3423	233520.0
2006-06-28 08:00:00	AMZN	Stock	1.8385	1.8385	1.8385	1.8385	4000.0
2006-06-28 09:00:00	AMZN	Stock	1.8205	1.844	1.8205	1.8365	8663620.0
2006-06-28 10:00:00	AMZN	Stock	1.837	1.85	1.836	1.85	12334080.0
2006-06-28 11:00:00	AMZN	Stock	1.85	1.8555	1.8325	1.842	13433000.0
2006-06-28 12:00:00	AMZN	Stock	1.843	1.8475	1.824	1.8325	8960360.0
2006-06-28 13:00:00	AMZN	Stock	1.8325	1.8385	1.831	1.8365	3837840.0
2006-06-28 14:00:00	AMZN	Stock	1.836	1.8545	1.836	1.8445	6541560.0
2006-06-28 15:00:00	AMZN	Stock	1.8445	1.846	1.833	1.838	17791660.0
2006-06-28 16:00:00	AMZN	Stock	1.8385	1.839	1.834	1.835	1093340.0
2006-06-28 17:00:00	AMZN	Stock	1.8355	1.8355	1.8345	1.8345	77560.0
2006-06-28 18:00:00	AMZN	Stock	1.835	1.835	1.835	1.835	29460.0
2006-06-28 09:00:00	CL	Stock	29.95	29.99	29.8	29.8	506600.0
2006-06-28 10:00:00	CL	Stock	29.805	29.95	29.54	29.545	699600.0
2006-06-28 11:00:00	CL	Stock	29.55	29.55	29.275	29.345	1263800.0
2006-06-28 12:00:00	CL	Stock	29.355	29.54	29.2315	29.475	1054800.0
2006-06-28 13:00:00	CL	Stock	29.475	29.605	29.435	29.605	260600.0

> showing 50 of 28,432 rows — these rows as CSV

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