PREVIEW / stock_1hour / 2006-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-10.parquet
  size:    590 KB
  rows:    27,944
  symbols: 2,193

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-10 05:00:00	AAPL	Stock	2.2814	2.2814	2.2814	2.2814	2800.0
2006-03-10 07:00:00	AAPL	Stock	2.2714	2.2714	2.2714	2.2714	2800.0
2006-03-10 08:00:00	AAPL	Stock	2.2821	2.3018	2.2721	2.2914	4440184.0
2006-03-10 09:00:00	AAPL	Stock	2.2925	2.3007	2.2525	2.2564	158619132.0
2006-03-10 10:00:00	AAPL	Stock	2.2579	2.3032	2.2332	2.2961	246169728.0
2006-03-10 11:00:00	AAPL	Stock	2.2961	2.2979	2.2586	2.2621	122339280.0
2006-03-10 12:00:00	AAPL	Stock	2.2625	2.2754	2.25	2.2639	110415060.0
2006-03-10 13:00:00	AAPL	Stock	2.2636	2.2721	2.2554	2.2625	72432388.0
2006-03-10 14:00:00	AAPL	Stock	2.2625	2.2789	2.24	2.2425	127212652.0
2006-03-10 15:00:00	AAPL	Stock	2.2429	2.27	2.2304	2.2568	190663928.0
2006-03-10 16:00:00	AAPL	Stock	2.2575	2.2607	2.2564	2.2575	3061016.0
2006-03-10 17:00:00	AAPL	Stock	2.2575	2.26	2.2571	2.2571	286580.0
2006-03-10 18:00:00	AAPL	Stock	2.2575	2.2607	2.2571	2.2604	248108.0
2006-03-10 06:00:00	MSFT	Stock	27.03	27.03	27.03	27.03	1000.0
2006-03-10 07:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	1000.0
2006-03-10 08:00:00	MSFT	Stock	27.0	27.07	26.96	27.05	49972.0
2006-03-10 09:00:00	MSFT	Stock	27.05	27.14	26.92	26.98	4498785.0
2006-03-10 10:00:00	MSFT	Stock	26.99	27.11	26.88	27.09	6942429.0
2006-03-10 11:00:00	MSFT	Stock	27.09	27.14	27.02	27.09	4274499.0
2006-03-10 12:00:00	MSFT	Stock	27.09	27.2	27.08	27.142	6031574.0
2006-03-10 13:00:00	MSFT	Stock	27.142	27.17	27.08	27.151	3186622.0
2006-03-10 14:00:00	MSFT	Stock	27.15	27.22	27.13	27.15	4554114.0
2006-03-10 15:00:00	MSFT	Stock	27.14	27.21	27.12	27.15	9297187.0
2006-03-10 16:00:00	MSFT	Stock	27.16	27.2	27.15	27.15	264769.0
2006-03-10 17:00:00	MSFT	Stock	27.16	27.16	27.15	27.15	3000.0
2006-03-10 18:00:00	MSFT	Stock	27.16	27.16	27.15	27.15	11946.0
2006-03-10 08:00:00	NVDA	Stock	0.4032	0.4042	0.4032	0.4042	402000.0
2006-03-10 09:00:00	NVDA	Stock	0.4048	0.4048	0.3972	0.4004	53519640.0
2006-03-10 10:00:00	NVDA	Stock	0.4003	0.4047	0.3991	0.4027	63032160.0
2006-03-10 11:00:00	NVDA	Stock	0.4026	0.4059	0.4021	0.405	60420480.0
2006-03-10 12:00:00	NVDA	Stock	0.405	0.4066	0.4044	0.4047	41117280.0
2006-03-10 13:00:00	NVDA	Stock	0.4047	0.4047	0.4002	0.4004	48788760.0
2006-03-10 14:00:00	NVDA	Stock	0.4003	0.401	0.3948	0.3952	90084960.0
2006-03-10 15:00:00	NVDA	Stock	0.3951	0.3957	0.3913	0.3947	149598960.0
2006-03-10 16:00:00	NVDA	Stock	0.3948	0.3954	0.3942	0.3953	2415360.0
2006-03-10 17:00:00	NVDA	Stock	0.3953	0.3953	0.3953	0.3953	15000.0
2006-03-10 18:00:00	NVDA	Stock	0.395	0.3953	0.395	0.3953	132000.0
2006-03-10 08:00:00	AMZN	Stock	1.8125	1.8175	1.8125	1.8175	98200.0
2006-03-10 09:00:00	AMZN	Stock	1.8175	1.8175	1.787	1.8045	12912320.0
2006-03-10 10:00:00	AMZN	Stock	1.8045	1.825	1.794	1.814	28690520.0
2006-03-10 11:00:00	AMZN	Stock	1.8135	1.815	1.803	1.8085	10944280.0
2006-03-10 12:00:00	AMZN	Stock	1.8085	1.82	1.8085	1.812	9765240.0
2006-03-10 13:00:00	AMZN	Stock	1.8125	1.8155	1.804	1.81	6622180.0
2006-03-10 14:00:00	AMZN	Stock	1.81	1.8145	1.801	1.802	9500380.0
2006-03-10 15:00:00	AMZN	Stock	1.803	1.812	1.801	1.8105	19023880.0
2006-03-10 16:00:00	AMZN	Stock	1.8085	1.81	1.806	1.81	452920.0
2006-03-10 17:00:00	AMZN	Stock	1.8075	1.8075	1.8075	1.8075	6000.0
2006-03-10 18:00:00	AMZN	Stock	1.8075	1.8075	1.8075	1.8075	4000.0
2006-03-10 08:00:00	CL	Stock	28.64	28.64	28.64	28.64	88000.0
2006-03-10 09:00:00	CL	Stock	29.085	29.085	28.575	28.8	520800.0

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

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