PREVIEW / stock_1hour / 2005-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-14.parquet
  size:    572 KB
  rows:    27,034
  symbols: 2,155

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-12-14 04:00:00	AAPL	Stock	2.6643	2.6643	2.6357	2.6357	58800.0
2005-12-14 05:00:00	AAPL	Stock	2.6268	2.6268	2.6071	2.6071	51548.0
2005-12-14 06:00:00	AAPL	Stock	2.6161	2.6321	2.6161	2.6286	67200.0
2005-12-14 07:00:00	AAPL	Stock	2.6196	2.6279	2.6068	2.6186	1229228.0
2005-12-14 08:00:00	AAPL	Stock	2.6211	2.6286	2.5882	2.5968	32187204.0
2005-12-14 09:00:00	AAPL	Stock	2.5971	2.6179	2.5793	2.6025	223124664.0
2005-12-14 10:00:00	AAPL	Stock	2.6025	2.6036	2.5486	2.5525	293160644.0
2005-12-14 11:00:00	AAPL	Stock	2.5514	2.5686	2.5096	2.5318	307047748.0
2005-12-14 12:00:00	AAPL	Stock	2.5318	2.6071	2.5214	2.5461	128142224.0
2005-12-14 13:00:00	AAPL	Stock	2.5461	2.5625	2.5411	2.5536	118068328.0
2005-12-14 14:00:00	AAPL	Stock	2.5536	2.5557	2.5375	2.5496	102927300.0
2005-12-14 15:00:00	AAPL	Stock	2.55	2.58	2.5496	2.5725	228586260.0
2005-12-14 16:00:00	AAPL	Stock	2.5718	2.5765	2.5671	2.5718	2558276.0
2005-12-14 17:00:00	AAPL	Stock	2.5711	2.5764	2.5682	2.5714	1026956.0
2005-12-14 18:00:00	AAPL	Stock	2.5714	2.5714	2.5643	2.5661	532644.0
2005-12-14 05:00:00	MSFT	Stock	27.15	27.15	27.15	27.15	100.0
2005-12-14 08:00:00	MSFT	Stock	27.1	27.12	27.0	27.08	30312.0
2005-12-14 09:00:00	MSFT	Stock	27.08	27.08	26.86	26.9	7255267.0
2005-12-14 10:00:00	MSFT	Stock	26.92	26.97	26.85	26.94	11449141.0
2005-12-14 11:00:00	MSFT	Stock	26.94	27.03	26.9	26.97	8173242.0
2005-12-14 12:00:00	MSFT	Stock	26.98	27.08	26.9	27.07	6363689.0
2005-12-14 13:00:00	MSFT	Stock	27.08	27.24	26.95	27.18	7336565.0
2005-12-14 14:00:00	MSFT	Stock	27.19	27.22	27.09	27.18	8004424.0
2005-12-14 15:00:00	MSFT	Stock	27.178	27.19	27.04	27.1	12156504.0
2005-12-14 16:00:00	MSFT	Stock	27.11	27.168	27.0	27.09	809510.0
2005-12-14 17:00:00	MSFT	Stock	27.1	27.15	27.07	27.08	41446.0
2005-12-14 18:00:00	MSFT	Stock	27.08	27.08	27.08	27.08	1000.0
2005-12-14 08:00:00	NVDA	Stock	0.3084	0.3092	0.3083	0.3092	96000.0
2005-12-14 09:00:00	NVDA	Stock	0.3083	0.31	0.3075	0.3077	40368000.0
2005-12-14 10:00:00	NVDA	Stock	0.3075	0.3077	0.3048	0.3059	41952360.0
2005-12-14 11:00:00	NVDA	Stock	0.3058	0.3063	0.3047	0.3054	28288680.0
2005-12-14 12:00:00	NVDA	Stock	0.3054	0.3077	0.3054	0.3075	31263240.0
2005-12-14 13:00:00	NVDA	Stock	0.3075	0.3097	0.3062	0.3092	47990880.0
2005-12-14 14:00:00	NVDA	Stock	0.3092	0.3104	0.3081	0.3086	38237760.0
2005-12-14 15:00:00	NVDA	Stock	0.3086	0.3092	0.3077	0.3083	49577280.0
2005-12-14 16:00:00	NVDA	Stock	0.3083	0.3094	0.3072	0.3083	2799720.0
2005-12-14 17:00:00	NVDA	Stock	0.3083	0.3083	0.3083	0.3083	96000.0
2005-12-14 08:00:00	AMZN	Stock	2.4665	2.47	2.458	2.46	237980.0
2005-12-14 09:00:00	AMZN	Stock	2.46	2.48	2.456	2.4665	11420740.0
2005-12-14 10:00:00	AMZN	Stock	2.467	2.4725	2.4505	2.4525	17486480.0
2005-12-14 11:00:00	AMZN	Stock	2.4525	2.4625	2.4395	2.453	18049980.0
2005-12-14 12:00:00	AMZN	Stock	2.4525	2.4605	2.45	2.46	6459060.0
2005-12-14 13:00:00	AMZN	Stock	2.4605	2.48	2.458	2.4725	9797660.0
2005-12-14 14:00:00	AMZN	Stock	2.4725	2.4775	2.459	2.465	10147540.0
2005-12-14 15:00:00	AMZN	Stock	2.465	2.4775	2.4645	2.469	23528700.0
2005-12-14 16:00:00	AMZN	Stock	2.4705	2.4725	2.4568	2.4705	522460.0
2005-12-14 18:00:00	AMZN	Stock	2.4725	2.4725	2.4725	2.4725	8000.0
2005-12-14 09:00:00	CL	Stock	28.0	28.225	27.985	28.175	694600.0
2005-12-14 10:00:00	CL	Stock	28.17	28.1745	27.9	27.92	692600.0
2005-12-14 11:00:00	CL	Stock	27.917	28.06	27.9	28.03	308800.0

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

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