PREVIEW / stock_1hour / 2009-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-18.parquet
  size:    805 KB
  rows:    39,859
  symbols: 3,323

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
2009-02-18 06:00:00	AAPL	Stock	3.3918	3.3918	3.3918	3.3918	2800.0
2009-02-18 07:00:00	AAPL	Stock	3.3893	3.3893	3.3893	3.3893	56000.0
2009-02-18 08:00:00	AAPL	Stock	3.3839	3.4046	3.375	3.3982	550256.0
2009-02-18 09:00:00	AAPL	Stock	3.4029	3.4154	3.3786	3.3954	71973860.0
2009-02-18 10:00:00	AAPL	Stock	3.3954	3.3989	3.3114	3.3804	159278812.0
2009-02-18 11:00:00	AAPL	Stock	3.3804	3.4143	3.3739	3.4057	79736328.0
2009-02-18 12:00:00	AAPL	Stock	3.4054	3.4232	3.3946	3.4086	63355264.0
2009-02-18 13:00:00	AAPL	Stock	3.4082	3.4139	3.3607	3.3729	71862728.0
2009-02-18 14:00:00	AAPL	Stock	3.3725	3.3925	3.3579	3.3921	77834652.0
2009-02-18 15:00:00	AAPL	Stock	3.3904	3.3971	3.3675	3.3707	122321332.0
2009-02-18 16:00:00	AAPL	Stock	3.3693	3.3873	3.3214	3.3446	28529984.0
2009-02-18 17:00:00	AAPL	Stock	3.3429	3.3842	3.3429	3.3429	127400.0
2009-02-18 18:00:00	AAPL	Stock	3.3704	3.3782	3.3321	3.3418	2093924.0
2009-02-18 19:00:00	AAPL	Stock	3.3411	3.3411	3.3029	3.3221	704956.0
2009-02-18 06:00:00	MSFT	Stock	18.35	18.95	18.35	18.95	1000.0
2009-02-18 08:00:00	MSFT	Stock	18.18	18.35	18.18	18.34	13759.0
2009-02-18 09:00:00	MSFT	Stock	18.3	18.34	18.14	18.21	5307073.0
2009-02-18 10:00:00	MSFT	Stock	18.21	18.24	18.0	18.07	10974089.0
2009-02-18 11:00:00	MSFT	Stock	18.07	18.38	18.05	18.32	6269830.0
2009-02-18 12:00:00	MSFT	Stock	18.33	18.45	18.23	18.273	5453121.0
2009-02-18 13:00:00	MSFT	Stock	18.28	18.32	18.05	18.1	4600336.0
2009-02-18 14:00:00	MSFT	Stock	18.11	18.19	18.02	18.18	7161158.0
2009-02-18 15:00:00	MSFT	Stock	18.17	18.2	18.05	18.12	11952923.0
2009-02-18 16:00:00	MSFT	Stock	18.11	18.2	17.91	17.96	1603595.0
2009-02-18 17:00:00	MSFT	Stock	18.0	18.06	17.96	18.02	5075.0
2009-02-18 18:00:00	MSFT	Stock	18.02	18.04	17.96	17.96	11314.0
2009-02-18 19:00:00	MSFT	Stock	18.0	18.03	17.97	17.97	3400.0
2009-02-18 08:00:00	NVDA	Stock	0.1995	0.1995	0.1995	0.1995	76000.0
2009-02-18 09:00:00	NVDA	Stock	0.1978	0.206	0.1955	0.198	102956720.0
2009-02-18 10:00:00	NVDA	Stock	0.1978	0.2062	0.1955	0.2035	157463160.0
2009-02-18 11:00:00	NVDA	Stock	0.2035	0.2075	0.2033	0.2058	73642320.0
2009-02-18 12:00:00	NVDA	Stock	0.2055	0.207	0.2032	0.2041	52611440.0
2009-02-18 13:00:00	NVDA	Stock	0.204	0.2055	0.201	0.2019	57342640.0
2009-02-18 14:00:00	NVDA	Stock	0.202	0.2028	0.1992	0.2013	81771680.0
2009-02-18 15:00:00	NVDA	Stock	0.2013	0.2033	0.2	0.201	109800280.0
2009-02-18 16:00:00	NVDA	Stock	0.2007	0.2026	0.1988	0.1988	1477440.0
2009-02-18 17:00:00	NVDA	Stock	0.1975	0.1975	0.1975	0.1975	79000.0
2009-02-18 19:00:00	NVDA	Stock	0.197	0.1972	0.197	0.1972	40920.0
2009-02-18 08:00:00	AMZN	Stock	3.097	3.113	3.097	3.1125	506980.0
2009-02-18 09:00:00	AMZN	Stock	3.1125	3.127	3.0725	3.079	17831140.0
2009-02-18 10:00:00	AMZN	Stock	3.0785	3.097	3.026	3.079	29049840.0
2009-02-18 11:00:00	AMZN	Stock	3.0805	3.139	3.0679	3.108	21802140.0
2009-02-18 12:00:00	AMZN	Stock	3.108	3.1355	3.0915	3.1105	9108280.0
2009-02-18 13:00:00	AMZN	Stock	3.109	3.1125	3.075	3.084	12082240.0
2009-02-18 14:00:00	AMZN	Stock	3.084	3.11	3.07	3.11	15610940.0
2009-02-18 15:00:00	AMZN	Stock	3.11	3.125	3.092	3.1175	33739860.0
2009-02-18 16:00:00	AMZN	Stock	3.117	3.119	3.0939	3.105	5673380.0
2009-02-18 17:00:00	AMZN	Stock	3.099	3.1171	3.0905	3.105	131120.0
2009-02-18 18:00:00	AMZN	Stock	3.1025	3.103	3.0925	3.0925	26000.0
2009-02-18 08:00:00	TLT	Stock	105.7	106.55	105.7	106.2	11600.0

> showing 50 of 39,859 rows — these rows as CSV

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