PREVIEW / stock_1hour / 2009-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-09.parquet
  size:    809 KB
  rows:    40,553
  symbols: 3,340

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-03-09 07:00:00	AAPL	Stock	2.995	3.0146	2.995	3.0	72800.0
2009-03-09 08:00:00	AAPL	Stock	3.0	3.015	3.0	3.0118	263676.0
2009-03-09 09:00:00	AAPL	Stock	3.0129	3.1071	3.0	3.0793	87646916.0
2009-03-09 10:00:00	AAPL	Stock	3.079	3.1286	3.0121	3.0175	134069852.0
2009-03-09 11:00:00	AAPL	Stock	3.0179	3.0457	3.0086	3.0254	89832512.0
2009-03-09 12:00:00	AAPL	Stock	3.025	3.0489	2.9914	2.9925	68164376.0
2009-03-09 13:00:00	AAPL	Stock	2.9922	2.9968	2.9654	2.9843	64729728.0
2009-03-09 14:00:00	AAPL	Stock	2.9843	3.0079	2.9579	2.9668	89022752.0
2009-03-09 15:00:00	AAPL	Stock	2.9664	2.9821	2.9489	2.9696	128352056.0
2009-03-09 16:00:00	AAPL	Stock	2.9693	3.02	2.9582	2.9675	14124852.0
2009-03-09 17:00:00	AAPL	Stock	2.9654	2.9707	2.9643	2.9671	7390628.0
2009-03-09 18:00:00	AAPL	Stock	2.9693	2.9693	2.9661	2.9661	613340.0
2009-03-09 19:00:00	AAPL	Stock	2.9643	2.9693	2.9643	2.9686	133336.0
2009-03-09 07:00:00	MSFT	Stock	15.27	15.28	15.25	15.25	4600.0
2009-03-09 08:00:00	MSFT	Stock	15.3	15.3	15.15	15.15	25200.0
2009-03-09 09:00:00	MSFT	Stock	15.15	15.74	15.15	15.46	8894998.0
2009-03-09 10:00:00	MSFT	Stock	15.462	15.7	15.24	15.29	11910428.0
2009-03-09 11:00:00	MSFT	Stock	15.28	15.44	15.26	15.35	7924758.0
2009-03-09 12:00:00	MSFT	Stock	15.34	15.44	15.28	15.33	4918188.0
2009-03-09 13:00:00	MSFT	Stock	15.33	15.335	15.1	15.19	6440571.0
2009-03-09 14:00:00	MSFT	Stock	15.2	15.34	15.15	15.22	6888612.0
2009-03-09 15:00:00	MSFT	Stock	15.22	15.384	15.11	15.15	15108931.0
2009-03-09 16:00:00	MSFT	Stock	15.15	15.7	15.11	15.15	2023828.0
2009-03-09 17:00:00	MSFT	Stock	15.15	15.15	15.13	15.14	89688.0
2009-03-09 18:00:00	MSFT	Stock	15.13	15.15	15.13	15.13	34371.0
2009-03-09 19:00:00	MSFT	Stock	15.13	15.14	15.1	15.14	23890.0
2009-03-09 09:00:00	NVDA	Stock	0.2082	0.224	0.2075	0.2172	132134160.0
2009-03-09 10:00:00	NVDA	Stock	0.2172	0.2208	0.2143	0.2152	133857680.0
2009-03-09 11:00:00	NVDA	Stock	0.2152	0.2172	0.2138	0.216	56104760.0
2009-03-09 12:00:00	NVDA	Stock	0.2158	0.217	0.2143	0.2143	53728600.0
2009-03-09 13:00:00	NVDA	Stock	0.2143	0.2145	0.21	0.21	65115120.0
2009-03-09 14:00:00	NVDA	Stock	0.2102	0.2115	0.2082	0.21	89719920.0
2009-03-09 15:00:00	NVDA	Stock	0.21	0.2112	0.207	0.2075	144875840.0
2009-03-09 16:00:00	NVDA	Stock	0.2092	0.2138	0.2075	0.2075	1347520.0
2009-03-09 17:00:00	NVDA	Stock	0.2075	0.2075	0.2075	0.2075	449360.0
2009-03-09 07:00:00	AMZN	Stock	3.1	3.15	3.1	3.15	406980.0
2009-03-09 08:00:00	AMZN	Stock	3.135	3.1415	3.1	3.12	896360.0
2009-03-09 09:00:00	AMZN	Stock	3.119	3.2	3.085	3.1575	49239920.0
2009-03-09 10:00:00	AMZN	Stock	3.1565	3.2015	3.122	3.127	52227000.0
2009-03-09 11:00:00	AMZN	Stock	3.127	3.15	3.062	3.0755	38599360.0
2009-03-09 12:00:00	AMZN	Stock	3.0785	3.1215	3.0525	3.0665	25852180.0
2009-03-09 13:00:00	AMZN	Stock	3.0665	3.0665	3.0205	3.0585	27477460.0
2009-03-09 14:00:00	AMZN	Stock	3.0585	3.074	3.009	3.0255	29044340.0
2009-03-09 15:00:00	AMZN	Stock	3.0265	3.042	3.0075	3.0245	40371720.0
2009-03-09 16:00:00	AMZN	Stock	3.0255	3.099	3.024	3.03	1392300.0
2009-03-09 17:00:00	AMZN	Stock	3.0325	3.037	3.0245	3.037	52180.0
2009-03-09 18:00:00	AMZN	Stock	3.0355	3.04	3.0355	3.038	65240.0
2009-03-09 19:00:00	AMZN	Stock	3.0315	3.041	3.0305	3.041	26800.0
2009-03-09 08:00:00	TLT	Stock	105.0	105.0	104.37	104.37	2200.0
2009-03-09 09:00:00	TLT	Stock	104.48	104.64	103.47	103.63	389774.0

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

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