PREVIEW / stock_1hour / 2008-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-23.parquet
  size:    827 KB
  rows:    40,617
  symbols: 3,346

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
2008-09-23 06:00:00	AAPL	Stock	4.6786	4.6786	4.6786	4.6786	5600.0
2008-09-23 07:00:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	2800.0
2008-09-23 08:00:00	AAPL	Stock	4.6821	4.7061	4.6625	4.7054	2206848.0
2008-09-23 09:00:00	AAPL	Stock	4.7071	4.7946	4.6711	4.7739	148200332.0
2008-09-23 10:00:00	AAPL	Stock	4.7733	4.85	4.7521	4.7639	198991968.0
2008-09-23 11:00:00	AAPL	Stock	4.7646	4.8304	4.7414	4.7543	117847268.0
2008-09-23 12:00:00	AAPL	Stock	4.7543	4.8393	4.6664	4.6879	120358280.0
2008-09-23 13:00:00	AAPL	Stock	4.6882	4.6896	4.5586	4.6214	200834424.0
2008-09-23 14:00:00	AAPL	Stock	4.6232	4.7071	4.5964	4.6696	206818276.0
2008-09-23 15:00:00	AAPL	Stock	4.6693	4.7143	4.5236	4.5296	260930796.0
2008-09-23 16:00:00	AAPL	Stock	4.5304	4.6953	4.5239	4.5446	19964056.0
2008-09-23 17:00:00	AAPL	Stock	4.5425	4.5936	4.5357	4.5936	1369956.0
2008-09-23 18:00:00	AAPL	Stock	4.5929	4.6268	4.59	4.6089	2190636.0
2008-09-23 19:00:00	AAPL	Stock	4.6071	4.6318	4.6036	4.6079	1301944.0
2008-09-23 07:00:00	MSFT	Stock	25.52	25.6	25.41	25.52	5850.0
2008-09-23 08:00:00	MSFT	Stock	25.51	25.7	25.5	25.6	86895.0
2008-09-23 09:00:00	MSFT	Stock	25.64	25.91	25.55	25.82	7213440.0
2008-09-23 10:00:00	MSFT	Stock	25.83	26.17	25.79	25.87	12319792.0
2008-09-23 11:00:00	MSFT	Stock	25.86	26.12	25.8	25.992	9064624.0
2008-09-23 12:00:00	MSFT	Stock	25.998	26.07	25.92	25.94	6797529.0
2008-09-23 13:00:00	MSFT	Stock	25.93	25.94	25.51	25.65	9551189.0
2008-09-23 14:00:00	MSFT	Stock	25.64	25.99	25.57	25.85	11608691.0
2008-09-23 15:00:00	MSFT	Stock	25.84	26.07	25.34	25.49	15137819.0
2008-09-23 16:00:00	MSFT	Stock	25.48	26.032	25.38	25.48	3630356.0
2008-09-23 17:00:00	MSFT	Stock	25.47	25.89	25.44	25.85	76132.0
2008-09-23 18:00:00	MSFT	Stock	25.85	25.9	25.7	25.78	69469.0
2008-09-23 19:00:00	MSFT	Stock	25.78	25.8	25.74	25.8	19806.0
2008-09-23 08:00:00	NVDA	Stock	0.2783	0.2785	0.2775	0.2775	76000.0
2008-09-23 09:00:00	NVDA	Stock	0.2775	0.2842	0.2735	0.2803	67551920.0
2008-09-23 10:00:00	NVDA	Stock	0.28	0.2872	0.2788	0.2845	112003600.0
2008-09-23 11:00:00	NVDA	Stock	0.2845	0.285	0.279	0.2803	77574880.0
2008-09-23 12:00:00	NVDA	Stock	0.2805	0.2815	0.2755	0.2768	65783240.0
2008-09-23 13:00:00	NVDA	Stock	0.2768	0.2768	0.2718	0.2732	128576640.0
2008-09-23 14:00:00	NVDA	Stock	0.273	0.2775	0.273	0.2758	102953400.0
2008-09-23 15:00:00	NVDA	Stock	0.2758	0.2765	0.2703	0.2712	190751360.0
2008-09-23 16:00:00	NVDA	Stock	0.2715	0.2775	0.2696	0.2712	14728160.0
2008-09-23 17:00:00	NVDA	Stock	0.271	0.2712	0.2705	0.271	158000.0
2008-09-23 18:00:00	NVDA	Stock	0.2758	0.2758	0.2743	0.2752	1564560.0
2008-09-23 19:00:00	NVDA	Stock	0.2755	0.2768	0.2755	0.2768	252000.0
2008-09-23 07:00:00	AMZN	Stock	3.8225	3.8225	3.8225	3.8225	4000.0
2008-09-23 08:00:00	AMZN	Stock	3.745	3.775	3.745	3.775	17180.0
2008-09-23 09:00:00	AMZN	Stock	3.7775	3.8145	3.6835	3.7055	25847600.0
2008-09-23 10:00:00	AMZN	Stock	3.7075	3.759	3.6855	3.7036	20248960.0
2008-09-23 11:00:00	AMZN	Stock	3.7025	3.704	3.6135	3.6175	17121800.0
2008-09-23 12:00:00	AMZN	Stock	3.618	3.6355	3.555	3.5795	21740600.0
2008-09-23 13:00:00	AMZN	Stock	3.578	3.6155	3.5385	3.6095	22689700.0
2008-09-23 14:00:00	AMZN	Stock	3.6115	3.6785	3.579	3.666	26300720.0
2008-09-23 15:00:00	AMZN	Stock	3.6675	3.694	3.5695	3.5885	32741720.0
2008-09-23 16:00:00	AMZN	Stock	3.5885	3.6533	3.5855	3.588	4342220.0
2008-09-23 17:00:00	AMZN	Stock	3.6	3.625	3.6	3.625	38000.0

> showing 50 of 40,617 rows — these rows as CSV

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