PREVIEW / stock_1hour / 2005-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-17.parquet
  size:    547 KB
  rows:    25,494
  symbols: 1,934

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
2005-03-17 08:00:00	AAPL	Stock	1.4911	1.4911	1.4707	1.4811	3948420.0
2005-03-17 09:00:00	AAPL	Stock	1.4811	1.4993	1.4757	1.4868	99365196.0
2005-03-17 10:00:00	AAPL	Stock	1.4868	1.5061	1.4836	1.5029	136173324.0
2005-03-17 11:00:00	AAPL	Stock	1.5029	1.5275	1.4982	1.5232	157324944.0
2005-03-17 12:00:00	AAPL	Stock	1.5229	1.5314	1.515	1.5179	92150072.0
2005-03-17 13:00:00	AAPL	Stock	1.5179	1.525	1.5093	1.5104	74718672.0
2005-03-17 14:00:00	AAPL	Stock	1.5107	1.5275	1.5039	1.5261	84855372.0
2005-03-17 15:00:00	AAPL	Stock	1.5261	1.5268	1.5089	1.5107	126205352.0
2005-03-17 16:00:00	AAPL	Stock	1.51	1.5143	1.5086	1.5143	4394684.0
2005-03-17 17:00:00	AAPL	Stock	1.5139	1.5179	1.5089	1.5089	1376144.0
2005-03-17 18:00:00	AAPL	Stock	1.5143	1.5143	1.5143	1.5143	83020.0
2005-03-17 08:00:00	MSFT	Stock	24.65	24.66	24.61	24.62	11250.0
2005-03-17 09:00:00	MSFT	Stock	24.62	24.68	24.53	24.54	6858101.0
2005-03-17 10:00:00	MSFT	Stock	24.54	24.66	24.53	24.66	9273074.0
2005-03-17 11:00:00	MSFT	Stock	24.66	24.67	24.59	24.64	7164193.0
2005-03-17 12:00:00	MSFT	Stock	24.64	24.65	24.6	24.63	4311848.0
2005-03-17 13:00:00	MSFT	Stock	24.63	24.64	24.59	24.59	7154305.0
2005-03-17 14:00:00	MSFT	Stock	24.59	24.67	24.56	24.59	12071670.0
2005-03-17 15:00:00	MSFT	Stock	24.59	24.62	24.54	24.54	12100857.0
2005-03-17 16:00:00	MSFT	Stock	24.54	24.59	24.51	24.51	287816.0
2005-03-17 17:00:00	MSFT	Stock	24.52	24.56	24.52	24.54	57307.0
2005-03-17 18:00:00	MSFT	Stock	24.52	24.54	24.52	24.52	11962.0
2005-03-17 09:00:00	NVDA	Stock	0.2083	0.2092	0.2062	0.2072	57096240.0
2005-03-17 10:00:00	NVDA	Stock	0.2072	0.2083	0.2061	0.207	91730040.0
2005-03-17 11:00:00	NVDA	Stock	0.207	0.2079	0.207	0.2078	63805920.0
2005-03-17 12:00:00	NVDA	Stock	0.2077	0.2078	0.2051	0.2067	50919000.0
2005-03-17 13:00:00	NVDA	Stock	0.2067	0.2072	0.2057	0.2059	37271640.0
2005-03-17 14:00:00	NVDA	Stock	0.2059	0.2067	0.2051	0.206	53078760.0
2005-03-17 15:00:00	NVDA	Stock	0.2061	0.2066	0.2052	0.2056	83948520.0
2005-03-17 16:00:00	NVDA	Stock	0.2057	0.2057	0.205	0.205	1480680.0
2005-03-17 17:00:00	NVDA	Stock	0.2057	0.2057	0.2057	0.2057	192000.0
2005-03-17 08:00:00	AMZN	Stock	1.697	1.697	1.6925	1.6925	26000.0
2005-03-17 09:00:00	AMZN	Stock	1.69	1.7025	1.678	1.6935	14055420.0
2005-03-17 10:00:00	AMZN	Stock	1.6935	1.6965	1.6885	1.696	8240560.0
2005-03-17 11:00:00	AMZN	Stock	1.696	1.7095	1.6925	1.7085	13715960.0
2005-03-17 12:00:00	AMZN	Stock	1.708	1.7115	1.7055	1.7075	8287720.0
2005-03-17 13:00:00	AMZN	Stock	1.707	1.722	1.707	1.7115	11752740.0
2005-03-17 14:00:00	AMZN	Stock	1.711	1.7125	1.7075	1.7085	9954740.0
2005-03-17 15:00:00	AMZN	Stock	1.708	1.7086	1.699	1.6995	21879960.0
2005-03-17 16:00:00	AMZN	Stock	1.699	1.7055	1.6985	1.7032	7080300.0
2005-03-17 17:00:00	AMZN	Stock	1.6985	1.7025	1.6985	1.6985	378000.0
2005-03-17 09:00:00	CL	Stock	26.15	26.155	25.95	25.95	230200.0
2005-03-17 10:00:00	CL	Stock	25.95	26.15	25.88	26.15	381200.0
2005-03-17 11:00:00	CL	Stock	26.15	26.155	25.99	26.04	324400.0
2005-03-17 12:00:00	CL	Stock	26.045	26.045	25.955	25.985	245400.0
2005-03-17 13:00:00	CL	Stock	25.985	26.005	25.905	25.91	230400.0
2005-03-17 14:00:00	CL	Stock	25.91	25.98	25.82	25.95	359200.0
2005-03-17 15:00:00	CL	Stock	25.95	26.005	25.92	25.98	571000.0
2005-03-17 16:00:00	CL	Stock	25.98	25.98	25.98	25.98	6800.0
2005-03-17 17:00:00	CL	Stock	25.975	25.975	25.975	25.975	1400.0

> showing 50 of 25,494 rows — these rows as CSV

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