PREVIEW / stock_1hour / 2008-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-06.parquet
  size:    812 KB
  rows:    41,178
  symbols: 3,307

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
2008-11-06 05:00:00	AAPL	Stock	3.5836	3.5836	3.5836	3.5836	54320.0
2008-11-06 07:00:00	AAPL	Stock	3.6129	3.6443	3.6046	3.6161	624232.0
2008-11-06 08:00:00	AAPL	Stock	3.6186	3.6421	3.5804	3.6321	3687824.0
2008-11-06 09:00:00	AAPL	Stock	3.6311	3.6707	3.5714	3.5718	190281280.0
2008-11-06 10:00:00	AAPL	Stock	3.5718	3.5921	3.5143	3.5679	248014088.0
2008-11-06 11:00:00	AAPL	Stock	3.5682	3.5889	3.5268	3.5646	151731160.0
2008-11-06 12:00:00	AAPL	Stock	3.5657	3.5714	3.5	3.5361	139182708.0
2008-11-06 13:00:00	AAPL	Stock	3.5368	3.5643	3.5	3.5611	135259124.0
2008-11-06 14:00:00	AAPL	Stock	3.5611	3.6193	3.5482	3.5761	179439372.0
2008-11-06 15:00:00	AAPL	Stock	3.5766	3.585	3.5111	3.5411	228213356.0
2008-11-06 16:00:00	AAPL	Stock	3.5425	3.6429	3.525	3.5357	27274128.0
2008-11-06 17:00:00	AAPL	Stock	3.5357	3.5618	3.535	3.5446	4182696.0
2008-11-06 18:00:00	AAPL	Stock	3.5446	3.5511	3.5286	3.5407	379092.0
2008-11-06 19:00:00	AAPL	Stock	3.5314	3.5411	3.5304	3.5361	195804.0
2008-11-06 07:00:00	MSFT	Stock	22.0	22.0	21.97	21.97	1400.0
2008-11-06 08:00:00	MSFT	Stock	22.08	22.08	21.9	22.0	37881.0
2008-11-06 09:00:00	MSFT	Stock	21.99	22.08	21.64	21.731	8041719.0
2008-11-06 10:00:00	MSFT	Stock	21.72	21.87	21.5	21.68	11330419.0
2008-11-06 11:00:00	MSFT	Stock	21.67	21.7	21.44	21.578	10281795.0
2008-11-06 12:00:00	MSFT	Stock	21.575	21.65	21.25	21.39	9106291.0
2008-11-06 13:00:00	MSFT	Stock	21.39	21.42	21.04	21.14	10738210.0
2008-11-06 14:00:00	MSFT	Stock	21.14	21.3	21.05	21.09	14101156.0
2008-11-06 15:00:00	MSFT	Stock	21.09	21.181	20.86	20.97	23543904.0
2008-11-06 16:00:00	MSFT	Stock	20.95	21.47	20.87	21.02	6763929.0
2008-11-06 17:00:00	MSFT	Stock	21.03	21.73	20.88	21.73	840677.0
2008-11-06 18:00:00	MSFT	Stock	21.02	21.14	21.0	21.05	44032.0
2008-11-06 19:00:00	MSFT	Stock	21.09	21.1	21.02	21.1	15051.0
2008-11-06 08:00:00	NVDA	Stock	0.2105	0.2105	0.2082	0.2085	247800.0
2008-11-06 09:00:00	NVDA	Stock	0.2085	0.2085	0.1985	0.205	92310080.0
2008-11-06 10:00:00	NVDA	Stock	0.2053	0.2053	0.1995	0.201	105229720.0
2008-11-06 11:00:00	NVDA	Stock	0.201	0.203	0.197	0.2	87284960.0
2008-11-06 12:00:00	NVDA	Stock	0.2	0.2013	0.1958	0.1965	69372440.0
2008-11-06 13:00:00	NVDA	Stock	0.1965	0.1978	0.194	0.1972	62813720.0
2008-11-06 14:00:00	NVDA	Stock	0.1972	0.2	0.195	0.197	82093320.0
2008-11-06 15:00:00	NVDA	Stock	0.197	0.198	0.19	0.1908	232062040.0
2008-11-06 16:00:00	NVDA	Stock	0.1905	0.2075	0.1875	0.205	18402040.0
2008-11-06 17:00:00	NVDA	Stock	0.2033	0.2198	0.1905	0.2168	17748440.0
2008-11-06 18:00:00	NVDA	Stock	0.217	0.2175	0.21	0.21	2745240.0
2008-11-06 19:00:00	NVDA	Stock	0.21	0.21	0.2068	0.21	277920.0
2008-11-06 05:00:00	AMZN	Stock	2.53	2.53	2.53	2.53	4000.0
2008-11-06 06:00:00	AMZN	Stock	2.4975	2.4975	2.4975	2.4975	20100.0
2008-11-06 07:00:00	AMZN	Stock	2.5	2.52	2.4995	2.5	282600.0
2008-11-06 08:00:00	AMZN	Stock	2.51	2.5175	2.4825	2.4995	475660.0
2008-11-06 09:00:00	AMZN	Stock	2.5	2.552	2.44	2.452	48322740.0
2008-11-06 10:00:00	AMZN	Stock	2.4515	2.504	2.4255	2.459	39998420.0
2008-11-06 11:00:00	AMZN	Stock	2.459	2.4875	2.436	2.467	28127860.0
2008-11-06 12:00:00	AMZN	Stock	2.464	2.4735	2.413	2.419	28459080.0
2008-11-06 13:00:00	AMZN	Stock	2.4185	2.4235	2.3735	2.393	31781520.0
2008-11-06 14:00:00	AMZN	Stock	2.3915	2.441	2.372	2.4054	35585260.0
2008-11-06 15:00:00	AMZN	Stock	2.4055	2.47	2.315	2.36	59027540.0

> showing 50 of 41,178 rows — these rows as CSV

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