PREVIEW / stock_1hour / 2006-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-29.parquet
  size:    652 KB
  rows:    31,073
  symbols: 2,504

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-12-29 06:00:00	AAPL	Stock	2.8925	2.9714	2.8925	2.9714	262808.0
2006-12-29 07:00:00	AAPL	Stock	2.9714	3.0321	2.9661	3.0046	7763756.0
2006-12-29 08:00:00	AAPL	Stock	3.0061	3.0282	2.9968	3.0004	40202288.0
2006-12-29 09:00:00	AAPL	Stock	3.0014	3.0293	2.9771	3.0186	238997136.0
2006-12-29 10:00:00	AAPL	Stock	3.0189	3.05	3.0182	3.0432	255520440.0
2006-12-29 11:00:00	AAPL	Stock	3.0432	3.0432	3.0189	3.0339	153018488.0
2006-12-29 12:00:00	AAPL	Stock	3.0339	3.0411	3.0286	3.0393	71895432.0
2006-12-29 13:00:00	AAPL	Stock	3.0393	3.0404	3.0304	3.0339	52181556.0
2006-12-29 14:00:00	AAPL	Stock	3.0339	3.0393	3.0218	3.0311	70667604.0
2006-12-29 15:00:00	AAPL	Stock	3.0311	3.04	3.0229	3.0279	160031648.0
2006-12-29 16:00:00	AAPL	Stock	3.0286	3.0329	3.0271	3.0286	5156816.0
2006-12-29 17:00:00	AAPL	Stock	3.0286	3.0307	3.0257	3.0275	644980.0
2006-12-29 18:00:00	AAPL	Stock	3.0275	3.03	3.0268	3.0268	347116.0
2006-12-29 19:00:00	AAPL	Stock	3.0261	3.0286	3.0214	3.025	494760.0
2006-12-29 07:00:00	MSFT	Stock	29.78	29.78	29.73	29.75	14600.0
2006-12-29 08:00:00	MSFT	Stock	29.75	29.95	29.75	29.95	27440.0
2006-12-29 09:00:00	MSFT	Stock	29.95	30.1	29.84	30.08	3201154.0
2006-12-29 10:00:00	MSFT	Stock	30.08	30.15	29.99	30.04	3747400.0
2006-12-29 11:00:00	MSFT	Stock	30.04	30.04	29.98	30.0	2546511.0
2006-12-29 12:00:00	MSFT	Stock	30.002	30.01	29.9	29.92	3689176.0
2006-12-29 13:00:00	MSFT	Stock	29.92	29.99	29.9	29.95	2774170.0
2006-12-29 14:00:00	MSFT	Stock	29.95	29.97	29.89	29.9	2889314.0
2006-12-29 15:00:00	MSFT	Stock	29.9	29.97	29.83	29.85	17921445.0
2006-12-29 16:00:00	MSFT	Stock	29.86	29.89	29.8	29.81	411715.0
2006-12-29 17:00:00	MSFT	Stock	29.82	29.88	29.82	29.88	3875.0
2006-12-29 18:00:00	MSFT	Stock	29.86	29.86	29.83	29.83	10287.0
2006-12-29 19:00:00	MSFT	Stock	29.86	29.88	29.81	29.88	2900.0
2006-12-29 09:00:00	NVDA	Stock	0.6182	0.6285	0.6175	0.628	24239520.0
2006-12-29 10:00:00	NVDA	Stock	0.6283	0.6325	0.6268	0.6303	57314520.0
2006-12-29 11:00:00	NVDA	Stock	0.6303	0.6337	0.63	0.6312	54023820.0
2006-12-29 12:00:00	NVDA	Stock	0.6313	0.6318	0.6262	0.6282	49294500.0
2006-12-29 13:00:00	NVDA	Stock	0.6282	0.6285	0.6247	0.6247	37649160.0
2006-12-29 14:00:00	NVDA	Stock	0.6247	0.625	0.6198	0.6205	49623480.0
2006-12-29 15:00:00	NVDA	Stock	0.6203	0.6213	0.6162	0.617	94609980.0
2006-12-29 16:00:00	NVDA	Stock	0.6173	0.6177	0.6168	0.6177	916920.0
2006-12-29 17:00:00	NVDA	Stock	0.617	0.6177	0.6167	0.6177	260460.0
2006-12-29 18:00:00	NVDA	Stock	0.6168	0.6177	0.6167	0.6167	170160.0
2006-12-29 19:00:00	NVDA	Stock	0.6167	0.6167	0.6167	0.6167	18000.0
2006-12-29 08:00:00	AMZN	Stock	2.0245	2.0245	2.0245	2.0245	10000.0
2006-12-29 09:00:00	AMZN	Stock	2.0085	2.0125	1.998	2.001	6418540.0
2006-12-29 10:00:00	AMZN	Stock	2.001	2.0075	1.996	2.0009	12454200.0
2006-12-29 11:00:00	AMZN	Stock	2.0005	2.0035	1.997	1.998	6679060.0
2006-12-29 12:00:00	AMZN	Stock	1.9975	1.9985	1.994	1.9945	9342900.0
2006-12-29 13:00:00	AMZN	Stock	1.994	1.994	1.9895	1.9925	6946500.0
2006-12-29 14:00:00	AMZN	Stock	1.9925	1.9925	1.979	1.9835	15771800.0
2006-12-29 15:00:00	AMZN	Stock	1.9835	1.9835	1.9675	1.9735	22232220.0
2006-12-29 16:00:00	AMZN	Stock	1.9755	1.976	1.9725	1.973	362480.0
2006-12-29 17:00:00	AMZN	Stock	1.97	1.97	1.969	1.969	4000.0
2006-12-29 18:00:00	AMZN	Stock	1.973	1.973	1.973	1.973	16320.0
2006-12-29 09:00:00	CL	Stock	32.86	32.935	32.75	32.845	402600.0

> showing 50 of 31,073 rows — these rows as CSV

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