PREVIEW / stock_1hour / 2006-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-14.parquet
  size:    621 KB
  rows:    29,830
  symbols: 2,288

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-14 06:00:00	AAPL	Stock	2.0893	2.0893	2.0893	2.0893	25200.0
2006-06-14 07:00:00	AAPL	Stock	2.0893	2.095	2.0714	2.0714	782600.0
2006-06-14 08:00:00	AAPL	Stock	2.0714	2.1	2.0493	2.0929	8230964.0
2006-06-14 09:00:00	AAPL	Stock	2.0925	2.1004	2.0632	2.0725	117382468.0
2006-06-14 10:00:00	AAPL	Stock	2.0729	2.0807	2.0514	2.0596	176034852.0
2006-06-14 11:00:00	AAPL	Stock	2.06	2.0636	2.0493	2.0546	80341184.0
2006-06-14 12:00:00	AAPL	Stock	2.0543	2.0789	2.0504	2.0556	41593804.0
2006-06-14 13:00:00	AAPL	Stock	2.0554	2.0556	2.0246	2.0414	131284076.0
2006-06-14 14:00:00	AAPL	Stock	2.0414	2.0529	2.0314	2.0318	130469192.0
2006-06-14 15:00:00	AAPL	Stock	2.0318	2.0618	2.0271	2.0571	176509900.0
2006-06-14 16:00:00	AAPL	Stock	2.0571	2.0589	2.0543	2.0571	5210324.0
2006-06-14 17:00:00	AAPL	Stock	2.0564	2.0604	2.0546	2.0589	717220.0
2006-06-14 18:00:00	AAPL	Stock	2.0586	2.0621	2.0564	2.0589	262920.0
2006-06-14 06:00:00	MSFT	Stock	21.62	21.62	21.62	21.62	1750.0
2006-06-14 07:00:00	MSFT	Stock	21.63	21.75	21.63	21.7	31000.0
2006-06-14 08:00:00	MSFT	Stock	21.69	21.69	21.53	21.61	413216.0
2006-06-14 09:00:00	MSFT	Stock	21.58	21.73	21.55	21.67	8015797.0
2006-06-14 10:00:00	MSFT	Stock	21.67	21.91	21.66	21.71	20194511.0
2006-06-14 11:00:00	MSFT	Stock	21.71	21.9	21.67	21.84	11619129.0
2006-06-14 12:00:00	MSFT	Stock	21.83	21.882	21.7	21.71	5981060.0
2006-06-14 13:00:00	MSFT	Stock	21.718	21.74	21.57	21.71	8545359.0
2006-06-14 14:00:00	MSFT	Stock	21.7	21.81	21.61	21.65	11615268.0
2006-06-14 15:00:00	MSFT	Stock	21.64	21.94	21.57	21.87	17428338.0
2006-06-14 16:00:00	MSFT	Stock	21.87	21.94	21.76	21.92	759843.0
2006-06-14 17:00:00	MSFT	Stock	21.92	21.92	21.92	21.92	23778.0
2006-06-14 18:00:00	MSFT	Stock	21.92	21.93	21.92	21.92	5320.0
2006-06-14 08:00:00	NVDA	Stock	0.3317	0.3317	0.3317	0.3317	27000.0
2006-06-14 09:00:00	NVDA	Stock	0.3325	0.3417	0.3295	0.3405	59345340.0
2006-06-14 10:00:00	NVDA	Stock	0.3403	0.3417	0.3377	0.3383	75718920.0
2006-06-14 11:00:00	NVDA	Stock	0.3383	0.3412	0.3358	0.34	53139780.0
2006-06-14 12:00:00	NVDA	Stock	0.34	0.341	0.3388	0.3403	39490560.0
2006-06-14 13:00:00	NVDA	Stock	0.3402	0.3405	0.3343	0.3392	50461560.0
2006-06-14 14:00:00	NVDA	Stock	0.3392	0.3402	0.3365	0.3393	75881640.0
2006-06-14 15:00:00	NVDA	Stock	0.3393	0.3413	0.3365	0.3412	102335400.0
2006-06-14 16:00:00	NVDA	Stock	0.3408	0.3422	0.3407	0.3408	11122800.0
2006-06-14 17:00:00	NVDA	Stock	0.342	0.3425	0.342	0.3422	207780.0
2006-06-14 08:00:00	AMZN	Stock	1.7	1.7	1.6775	1.6775	564000.0
2006-06-14 09:00:00	AMZN	Stock	1.68	1.6908	1.666	1.6835	10121300.0
2006-06-14 10:00:00	AMZN	Stock	1.6835	1.6995	1.673	1.673	17021820.0
2006-06-14 11:00:00	AMZN	Stock	1.6735	1.6805	1.661	1.668	13224580.0
2006-06-14 12:00:00	AMZN	Stock	1.668	1.6946	1.6655	1.673	7463780.0
2006-06-14 13:00:00	AMZN	Stock	1.673	1.673	1.6605	1.672	13284760.0
2006-06-14 14:00:00	AMZN	Stock	1.672	1.68	1.654	1.661	12962200.0
2006-06-14 15:00:00	AMZN	Stock	1.661	1.6845	1.6585	1.684	18509580.0
2006-06-14 16:00:00	AMZN	Stock	1.683	1.693	1.6805	1.684	1596740.0
2006-06-14 17:00:00	AMZN	Stock	1.6875	1.6875	1.6875	1.6875	2000.0
2006-06-14 09:00:00	CL	Stock	30.65	30.72	30.435	30.49	419800.0
2006-06-14 10:00:00	CL	Stock	30.46	30.52	30.04	30.05	885200.0
2006-06-14 11:00:00	CL	Stock	30.05	30.225	30.05	30.155	877600.0
2006-06-14 12:00:00	CL	Stock	30.17	30.5525	30.125	30.24	640400.0

> showing 50 of 29,830 rows — these rows as CSV

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