PREVIEW / stock_1hour / 2006-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-13.parquet
  size:    587 KB
  rows:    27,847
  symbols: 2,234

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-04-13 05:00:00	AAPL	Stock	2.4036	2.4036	2.4	2.4	5600.0
2006-04-13 06:00:00	AAPL	Stock	2.3996	2.3996	2.3996	2.3996	2800.0
2006-04-13 07:00:00	AAPL	Stock	2.375	2.3875	2.3679	2.3807	50400.0
2006-04-13 08:00:00	AAPL	Stock	2.3846	2.3911	2.3754	2.3861	2051420.0
2006-04-13 09:00:00	AAPL	Stock	2.3854	2.3861	2.3504	2.3675	137003832.0
2006-04-13 10:00:00	AAPL	Stock	2.3675	2.4086	2.3621	2.3925	185424484.0
2006-04-13 11:00:00	AAPL	Stock	2.3921	2.3936	2.3711	2.3775	142782724.0
2006-04-13 12:00:00	AAPL	Stock	2.3775	2.385	2.3686	2.3718	47866420.0
2006-04-13 13:00:00	AAPL	Stock	2.3718	2.3768	2.3579	2.3721	70932232.0
2006-04-13 14:00:00	AAPL	Stock	2.3725	2.3764	2.3639	2.3667	48178480.0
2006-04-13 15:00:00	AAPL	Stock	2.3664	2.3811	2.3643	2.3739	84686112.0
2006-04-13 16:00:00	AAPL	Stock	2.3739	2.3775	2.3732	2.375	1510152.0
2006-04-13 17:00:00	AAPL	Stock	2.3764	2.3764	2.3746	2.3761	525532.0
2006-04-13 18:00:00	AAPL	Stock	2.375	2.3757	2.3746	2.3746	228760.0
2006-04-13 06:00:00	MSFT	Stock	27.05	27.05	27.03	27.03	1000.0
2006-04-13 07:00:00	MSFT	Stock	27.02	27.02	27.0	27.0	900.0
2006-04-13 08:00:00	MSFT	Stock	27.05	27.09	27.05	27.09	39410.0
2006-04-13 09:00:00	MSFT	Stock	27.09	27.2	27.0	27.081	4349986.0
2006-04-13 10:00:00	MSFT	Stock	27.09	27.19	27.06	27.17	5630288.0
2006-04-13 11:00:00	MSFT	Stock	27.17	27.2	27.1	27.11	3571791.0
2006-04-13 12:00:00	MSFT	Stock	27.11	27.15	27.08	27.11	2572484.0
2006-04-13 13:00:00	MSFT	Stock	27.12	27.13	27.07	27.08	2307471.0
2006-04-13 14:00:00	MSFT	Stock	27.08	27.11	27.05	27.08	2234578.0
2006-04-13 15:00:00	MSFT	Stock	27.08	27.145	27.05	27.06	5053009.0
2006-04-13 16:00:00	MSFT	Stock	27.06	27.09	27.05	27.07	41324.0
2006-04-13 18:00:00	MSFT	Stock	27.09	27.09	27.09	27.09	200.0
2006-04-13 07:00:00	NVDA	Stock	0.5	0.5	0.4967	0.4967	1362000.0
2006-04-13 08:00:00	NVDA	Stock	0.4998	0.5025	0.4978	0.4978	6809400.0
2006-04-13 09:00:00	NVDA	Stock	0.4975	0.4993	0.4918	0.4948	164983200.0
2006-04-13 10:00:00	NVDA	Stock	0.4948	0.4997	0.4927	0.4995	131371500.0
2006-04-13 11:00:00	NVDA	Stock	0.4995	0.5023	0.4947	0.4983	98733180.0
2006-04-13 12:00:00	NVDA	Stock	0.4983	0.4995	0.496	0.4972	38351340.0
2006-04-13 13:00:00	NVDA	Stock	0.4972	0.4983	0.4957	0.4978	53919120.0
2006-04-13 14:00:00	NVDA	Stock	0.4977	0.4978	0.4917	0.4918	80286000.0
2006-04-13 15:00:00	NVDA	Stock	0.4918	0.4962	0.4913	0.4932	136706220.0
2006-04-13 16:00:00	NVDA	Stock	0.4933	0.4945	0.4922	0.4937	3422820.0
2006-04-13 08:00:00	AMZN	Stock	1.8175	1.8175	1.8	1.8	20000.0
2006-04-13 09:00:00	AMZN	Stock	1.8	1.8005	1.7745	1.778	8392780.0
2006-04-13 10:00:00	AMZN	Stock	1.7775	1.8055	1.7775	1.805	13364920.0
2006-04-13 11:00:00	AMZN	Stock	1.8045	1.8115	1.7965	1.808	9803100.0
2006-04-13 12:00:00	AMZN	Stock	1.808	1.823	1.808	1.8165	5875080.0
2006-04-13 13:00:00	AMZN	Stock	1.816	1.8245	1.8075	1.8215	6420880.0
2006-04-13 14:00:00	AMZN	Stock	1.821	1.8285	1.821	1.825	8850720.0
2006-04-13 15:00:00	AMZN	Stock	1.825	1.836	1.8245	1.829	18845000.0
2006-04-13 16:00:00	AMZN	Stock	1.8285	1.831	1.822	1.822	554700.0
2006-04-13 17:00:00	AMZN	Stock	1.8205	1.8205	1.8205	1.8205	10000.0
2006-04-13 09:00:00	CL	Stock	28.2	28.245	28.105	28.245	550000.0
2006-04-13 10:00:00	CL	Stock	28.245	28.325	28.2	28.295	627600.0
2006-04-13 11:00:00	CL	Stock	28.295	28.325	28.225	28.3235	481600.0
2006-04-13 12:00:00	CL	Stock	28.324	28.34	28.165	28.24	296600.0

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

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