PREVIEW / stock_1hour / 2006-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-09.parquet
  size:    609 KB
  rows:    28,913
  symbols: 2,194

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-03-09 06:00:00	AAPL	Stock	2.3511	2.3511	2.3511	2.3511	2800.0
2006-03-09 07:00:00	AAPL	Stock	2.3786	2.3786	2.3786	2.3786	25676.0
2006-03-09 08:00:00	AAPL	Stock	2.3561	2.3632	2.3536	2.3596	1969240.0
2006-03-09 09:00:00	AAPL	Stock	2.3593	2.3739	2.3289	2.3711	126335104.0
2006-03-09 10:00:00	AAPL	Stock	2.3704	2.3707	2.3407	2.3407	136182396.0
2006-03-09 11:00:00	AAPL	Stock	2.3407	2.3486	2.3282	2.3346	70174244.0
2006-03-09 12:00:00	AAPL	Stock	2.3346	2.3393	2.3161	2.3236	100860200.0
2006-03-09 13:00:00	AAPL	Stock	2.3239	2.3239	2.2939	2.3029	122883628.0
2006-03-09 14:00:00	AAPL	Stock	2.3036	2.3161	2.2914	2.2981	86506896.0
2006-03-09 15:00:00	AAPL	Stock	2.2982	2.2996	2.2789	2.2829	145897248.0
2006-03-09 16:00:00	AAPL	Stock	2.2832	2.3196	2.2768	2.2814	2229780.0
2006-03-09 17:00:00	AAPL	Stock	2.2814	2.2832	2.28	2.2829	971992.0
2006-03-09 18:00:00	AAPL	Stock	2.2829	2.2832	2.2821	2.2821	819560.0
2006-03-09 07:00:00	MSFT	Stock	27.35	27.35	27.3	27.3	862.0
2006-03-09 08:00:00	MSFT	Stock	27.36	27.38	27.31	27.31	17969.0
2006-03-09 09:00:00	MSFT	Stock	27.28	27.36	27.15	27.33	5893411.0
2006-03-09 10:00:00	MSFT	Stock	27.34	27.42	27.29	27.32	7737830.0
2006-03-09 11:00:00	MSFT	Stock	27.32	27.35	27.27	27.29	3371425.0
2006-03-09 12:00:00	MSFT	Stock	27.29	27.3	27.16	27.2	4680425.0
2006-03-09 13:00:00	MSFT	Stock	27.21	27.21	27.07	27.092	5684445.0
2006-03-09 14:00:00	MSFT	Stock	27.1	27.34	27.08	27.092	4959828.0
2006-03-09 15:00:00	MSFT	Stock	27.09	27.1	27.0	27.01	9305303.0
2006-03-09 16:00:00	MSFT	Stock	27.02	27.072	26.95	27.0	856913.0
2006-03-09 17:00:00	MSFT	Stock	26.99	27.0	26.99	27.0	11360.0
2006-03-09 18:00:00	MSFT	Stock	26.99	26.99	26.95	26.97	2293.0
2006-03-09 08:00:00	NVDA	Stock	0.405	0.4071	0.4049	0.4065	428400.0
2006-03-09 09:00:00	NVDA	Stock	0.405	0.4114	0.4042	0.4097	88748520.0
2006-03-09 10:00:00	NVDA	Stock	0.4096	0.4104	0.4059	0.4061	69547800.0
2006-03-09 11:00:00	NVDA	Stock	0.4063	0.4098	0.4052	0.4096	55808760.0
2006-03-09 12:00:00	NVDA	Stock	0.4095	0.4096	0.4025	0.4049	67666680.0
2006-03-09 13:00:00	NVDA	Stock	0.4049	0.4074	0.4049	0.4058	59991240.0
2006-03-09 14:00:00	NVDA	Stock	0.4058	0.4082	0.4035	0.4037	67433040.0
2006-03-09 15:00:00	NVDA	Stock	0.4037	0.404	0.4017	0.4018	114855360.0
2006-03-09 16:00:00	NVDA	Stock	0.4019	0.4031	0.4016	0.4017	3793200.0
2006-03-09 17:00:00	NVDA	Stock	0.4017	0.4019	0.4017	0.4019	156120.0
2006-03-09 08:00:00	AMZN	Stock	1.8425	1.8425	1.8405	1.842	25480.0
2006-03-09 09:00:00	AMZN	Stock	1.847	1.848	1.8275	1.8445	7767860.0
2006-03-09 10:00:00	AMZN	Stock	1.844	1.845	1.824	1.8285	13775540.0
2006-03-09 11:00:00	AMZN	Stock	1.829	1.836	1.819	1.831	9767960.0
2006-03-09 12:00:00	AMZN	Stock	1.831	1.831	1.8165	1.8235	12963660.0
2006-03-09 13:00:00	AMZN	Stock	1.823	1.8235	1.8075	1.816	22898440.0
2006-03-09 14:00:00	AMZN	Stock	1.816	1.8175	1.8005	1.804	21158360.0
2006-03-09 15:00:00	AMZN	Stock	1.804	1.819	1.795	1.807	53349480.0
2006-03-09 16:00:00	AMZN	Stock	1.806	1.8065	1.8005	1.806	628940.0
2006-03-09 17:00:00	AMZN	Stock	1.8058	1.8058	1.8058	1.8058	16400.0
2006-03-09 09:00:00	CL	Stock	28.125	28.1795	28.01	28.125	635000.0
2006-03-09 10:00:00	CL	Stock	28.12	28.415	28.065	28.365	961400.0
2006-03-09 11:00:00	CL	Stock	28.36	28.51	28.335	28.505	1120600.0
2006-03-09 12:00:00	CL	Stock	28.5	28.6	28.5	28.575	986600.0
2006-03-09 13:00:00	CL	Stock	28.575	28.6	28.5	28.56	727600.0

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

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