PREVIEW / stock_1hour / 2004-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-12.parquet
  size:    491 KB
  rows:    23,620
  symbols: 1,814

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
2004-08-12 08:00:00	AAPL	Stock	0.5486	0.5539	0.5486	0.5539	140000.0
2004-08-12 09:00:00	AAPL	Stock	0.5455	0.5491	0.5418	0.5452	22300936.0
2004-08-12 10:00:00	AAPL	Stock	0.5452	0.5452	0.5407	0.5436	28040488.0
2004-08-12 11:00:00	AAPL	Stock	0.5438	0.5509	0.5434	0.5464	39575368.0
2004-08-12 12:00:00	AAPL	Stock	0.5464	0.5468	0.5445	0.5466	22087744.0
2004-08-12 13:00:00	AAPL	Stock	0.5464	0.5466	0.5436	0.5439	30037560.0
2004-08-12 14:00:00	AAPL	Stock	0.5439	0.5475	0.5425	0.545	33099752.0
2004-08-12 15:00:00	AAPL	Stock	0.5452	0.5452	0.5411	0.5425	34738928.0
2004-08-12 16:00:00	AAPL	Stock	0.5429	0.5441	0.5402	0.5423	2672544.0
2004-08-12 17:00:00	AAPL	Stock	0.5491	0.5496	0.5491	0.5496	28000.0
2004-08-12 08:00:00	MSFT	Stock	27.33	27.405	27.26	27.35	43900.0
2004-08-12 09:00:00	MSFT	Stock	27.35	27.35	27.2	27.27	4084738.0
2004-08-12 10:00:00	MSFT	Stock	27.28	27.29	27.13	27.14	6978195.0
2004-08-12 11:00:00	MSFT	Stock	27.14	27.26	27.1	27.12	5429662.0
2004-08-12 12:00:00	MSFT	Stock	27.111	27.15	27.04	27.06	3519138.0
2004-08-12 13:00:00	MSFT	Stock	27.06	27.065	26.87	26.959	10297681.0
2004-08-12 14:00:00	MSFT	Stock	26.96	27.12	26.92	27.07	7503059.0
2004-08-12 15:00:00	MSFT	Stock	27.07	27.08	26.89	26.9	9278422.0
2004-08-12 16:00:00	MSFT	Stock	26.89	27.04	26.88	27.0	1258198.0
2004-08-12 17:00:00	MSFT	Stock	27.0	27.1	26.88	27.1	40956.0
2004-08-12 18:00:00	MSFT	Stock	27.04	27.05	26.99	27.03	38900.0
2004-08-12 08:00:00	NVDA	Stock	0.0854	0.0854	0.0854	0.0854	12000.0
2004-08-12 09:00:00	NVDA	Stock	0.0854	0.0865	0.0852	0.0857	73594200.0
2004-08-12 10:00:00	NVDA	Stock	0.0857	0.0857	0.0843	0.0843	101814720.0
2004-08-12 11:00:00	NVDA	Stock	0.0843	0.0852	0.0842	0.085	80165160.0
2004-08-12 12:00:00	NVDA	Stock	0.085	0.0853	0.0842	0.0846	86869560.0
2004-08-12 13:00:00	NVDA	Stock	0.0846	0.0849	0.0841	0.0849	74251800.0
2004-08-12 14:00:00	NVDA	Stock	0.0849	0.0852	0.0842	0.0846	75558480.0
2004-08-12 15:00:00	NVDA	Stock	0.0846	0.0851	0.0839	0.084	137951520.0
2004-08-12 16:00:00	NVDA	Stock	0.0842	0.0852	0.084	0.084	3894720.0
2004-08-12 17:00:00	NVDA	Stock	0.0844	0.0844	0.0842	0.0842	840000.0
2004-08-12 18:00:00	NVDA	Stock	0.0843	0.0847	0.0843	0.0847	326400.0
2004-08-12 08:00:00	AMZN	Stock	1.8278	1.8278	1.805	1.82	211620.0
2004-08-12 09:00:00	AMZN	Stock	1.819	1.865	1.805	1.863	31205920.0
2004-08-12 10:00:00	AMZN	Stock	1.8625	1.8675	1.8405	1.849	51484280.0
2004-08-12 11:00:00	AMZN	Stock	1.8485	1.85	1.8205	1.821	20761300.0
2004-08-12 12:00:00	AMZN	Stock	1.8205	1.83	1.816	1.826	12161200.0
2004-08-12 13:00:00	AMZN	Stock	1.8255	1.8275	1.8125	1.8205	14019580.0
2004-08-12 14:00:00	AMZN	Stock	1.8205	1.831	1.8125	1.831	19429240.0
2004-08-12 15:00:00	AMZN	Stock	1.8315	1.84	1.8155	1.817	27252520.0
2004-08-12 16:00:00	AMZN	Stock	1.8145	1.821	1.814	1.8145	1283720.0
2004-08-12 17:00:00	AMZN	Stock	1.8205	1.822	1.8145	1.822	234640.0
2004-08-12 18:00:00	AMZN	Stock	1.822	1.822	1.819	1.82	34000.0
2004-08-12 09:00:00	CL	Stock	26.02	26.085	25.92	25.985	216400.0
2004-08-12 10:00:00	CL	Stock	25.975	26.105	25.945	26.095	413000.0
2004-08-12 11:00:00	CL	Stock	26.085	26.17	26.04	26.11	289800.0
2004-08-12 12:00:00	CL	Stock	26.1	26.16	26.075	26.08	193000.0
2004-08-12 13:00:00	CL	Stock	26.07	26.075	25.925	26.0	248400.0
2004-08-12 14:00:00	CL	Stock	25.99	26.025	25.935	25.945	221400.0
2004-08-12 15:00:00	CL	Stock	25.945	26.055	25.915	25.99	775200.0

> showing 50 of 23,620 rows — these rows as CSV

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