PREVIEW / stock_1hour / 2007-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-11.parquet
  size:    822 KB
  rows:    40,668
  symbols: 3,230

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
2007-12-11 06:00:00	AAPL	Stock	6.9071	6.9071	6.9043	6.9043	5600.0
2007-12-11 07:00:00	AAPL	Stock	6.9286	6.9625	6.9286	6.9571	285264.0
2007-12-11 08:00:00	AAPL	Stock	6.9589	6.9589	6.9414	6.955	1578724.0
2007-12-11 09:00:00	AAPL	Stock	6.9564	6.9836	6.9446	6.9629	87519712.0
2007-12-11 10:00:00	AAPL	Stock	6.9621	6.9961	6.9532	6.9936	112344176.0
2007-12-11 11:00:00	AAPL	Stock	6.9936	7.0296	6.9871	7.0146	125187384.0
2007-12-11 12:00:00	AAPL	Stock	7.015	7.0171	6.9964	7.0121	45957464.0
2007-12-11 13:00:00	AAPL	Stock	7.0121	7.0179	6.9821	7.0021	73868424.0
2007-12-11 14:00:00	AAPL	Stock	7.0029	7.0068	6.7343	6.835	378344904.0
2007-12-11 15:00:00	AAPL	Stock	6.8361	6.8821	6.6925	6.7271	266316288.0
2007-12-11 16:00:00	AAPL	Stock	6.7364	6.9339	6.7096	6.7179	14045164.0
2007-12-11 17:00:00	AAPL	Stock	6.7143	6.9339	6.7104	6.7179	3203676.0
2007-12-11 18:00:00	AAPL	Stock	6.7154	6.7304	6.7143	6.7243	1330840.0
2007-12-11 19:00:00	AAPL	Stock	6.7286	6.7464	6.7286	6.7393	1086428.0
2007-12-11 07:00:00	MSFT	Stock	34.9	34.9	34.9	34.9	700.0
2007-12-11 08:00:00	MSFT	Stock	34.92	34.93	34.82	34.86	1400.0
2007-12-11 09:00:00	MSFT	Stock	34.87	34.89	34.6	34.65	3922874.0
2007-12-11 10:00:00	MSFT	Stock	34.65	34.75	34.61	34.66	4876746.0
2007-12-11 11:00:00	MSFT	Stock	34.66	34.93	34.65	34.91	5127472.0
2007-12-11 12:00:00	MSFT	Stock	34.91	34.99	34.86	34.94	3195544.0
2007-12-11 13:00:00	MSFT	Stock	34.95	34.98	34.88	34.98	3321442.0
2007-12-11 14:00:00	MSFT	Stock	34.972	34.99	34.09	34.3	13600725.0
2007-12-11 15:00:00	MSFT	Stock	34.3	34.32	33.93	34.15	15832846.0
2007-12-11 16:00:00	MSFT	Stock	34.16	34.76	34.04	34.76	4797145.0
2007-12-11 17:00:00	MSFT	Stock	34.1	34.85	34.1	34.12	449671.0
2007-12-11 18:00:00	MSFT	Stock	34.12	34.12	34.1	34.1	2500.0
2007-12-11 19:00:00	MSFT	Stock	34.1	34.1	34.02	34.05	7020.0
2007-12-11 08:00:00	NVDA	Stock	0.8662	0.8688	0.865	0.8672	92960.0
2007-12-11 09:00:00	NVDA	Stock	0.8668	0.8785	0.8638	0.8748	77223480.0
2007-12-11 10:00:00	NVDA	Stock	0.875	0.8812	0.8722	0.8758	57104880.0
2007-12-11 11:00:00	NVDA	Stock	0.8758	0.8775	0.8715	0.8755	34052280.0
2007-12-11 12:00:00	NVDA	Stock	0.8758	0.8765	0.872	0.876	28571640.0
2007-12-11 13:00:00	NVDA	Stock	0.8762	0.8875	0.8748	0.8873	68718440.0
2007-12-11 14:00:00	NVDA	Stock	0.8873	0.8905	0.868	0.8755	172145880.0
2007-12-11 15:00:00	NVDA	Stock	0.8755	0.8838	0.8552	0.8568	125952080.0
2007-12-11 16:00:00	NVDA	Stock	0.8585	0.8742	0.855	0.855	5982640.0
2007-12-11 17:00:00	NVDA	Stock	0.8565	0.8588	0.8562	0.8562	1300680.0
2007-12-11 18:00:00	NVDA	Stock	0.8562	0.8648	0.8552	0.8648	55360.0
2007-12-11 19:00:00	NVDA	Stock	0.8575	0.8575	0.8552	0.8552	51600.0
2007-12-11 08:00:00	AMZN	Stock	4.665	4.68	4.63	4.648	50000.0
2007-12-11 09:00:00	AMZN	Stock	4.649	4.781	4.649	4.761	26685580.0
2007-12-11 10:00:00	AMZN	Stock	4.7605	4.797	4.7075	4.721	23156240.0
2007-12-11 11:00:00	AMZN	Stock	4.72	4.759	4.7165	4.7585	11157820.0
2007-12-11 12:00:00	AMZN	Stock	4.759	4.76	4.7395	4.752	6428800.0
2007-12-11 13:00:00	AMZN	Stock	4.7535	4.772	4.7405	4.762	9572920.0
2007-12-11 14:00:00	AMZN	Stock	4.7625	4.7625	4.5375	4.6285	49790240.0
2007-12-11 15:00:00	AMZN	Stock	4.629	4.6315	4.5375	4.5375	46281060.0
2007-12-11 16:00:00	AMZN	Stock	4.5375	4.6663	4.5375	4.651	26477720.0
2007-12-11 17:00:00	AMZN	Stock	4.5485	4.651	4.5375	4.55	5777140.0
2007-12-11 18:00:00	AMZN	Stock	4.55	4.55	4.5425	4.5425	27580.0

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

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