PREVIEW / stock_1hour / 2008-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-15.parquet
  size:    851 KB
  rows:    41,877
  symbols: 3,337

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-09-15 04:00:00	AAPL	Stock	5.25	5.25	5.1429	5.1429	15400.0
2008-09-15 05:00:00	AAPL	Stock	5.1104	5.1107	5.1071	5.1107	57680.0
2008-09-15 06:00:00	AAPL	Stock	5.1071	5.1429	5.1071	5.125	105280.0
2008-09-15 07:00:00	AAPL	Stock	5.1075	5.1161	5.0714	5.0929	1543416.0
2008-09-15 08:00:00	AAPL	Stock	5.0921	5.1186	5.0046	5.1004	6400100.0
2008-09-15 09:00:00	AAPL	Stock	5.1029	5.2225	5.0589	5.185	138952912.0
2008-09-15 10:00:00	AAPL	Stock	5.1846	5.2746	5.1729	5.2464	137307072.0
2008-09-15 11:00:00	AAPL	Stock	5.2461	5.2589	5.1714	5.1754	81216660.0
2008-09-15 12:00:00	AAPL	Stock	5.1757	5.2525	5.1743	5.2071	62587896.0
2008-09-15 13:00:00	AAPL	Stock	5.2071	5.2396	5.0636	5.1054	133482468.0
2008-09-15 14:00:00	AAPL	Stock	5.1043	5.1357	5.0607	5.11	98581420.0
2008-09-15 15:00:00	AAPL	Stock	5.11	5.1532	5.0182	5.0214	204797348.0
2008-09-15 16:00:00	AAPL	Stock	5.0254	5.1449	5.0129	5.025	30582636.0
2008-09-15 17:00:00	AAPL	Stock	5.0129	5.0268	4.9904	4.9929	2159696.0
2008-09-15 18:00:00	AAPL	Stock	4.9929	5.0064	4.9929	4.9964	333396.0
2008-09-15 19:00:00	AAPL	Stock	4.9964	4.9986	4.9668	4.9779	707812.0
2008-09-15 06:00:00	MSFT	Stock	26.85	26.85	26.85	26.85	100.0
2008-09-15 07:00:00	MSFT	Stock	28.79	29.74	26.51	26.67	4129.0
2008-09-15 08:00:00	MSFT	Stock	26.56	27.3	26.55	26.8	48484.0
2008-09-15 09:00:00	MSFT	Stock	26.8	27.49	26.75	27.26	8822097.0
2008-09-15 10:00:00	MSFT	Stock	27.267	27.45	27.1	27.33	12395745.0
2008-09-15 11:00:00	MSFT	Stock	27.32	27.37	27.2	27.24	7887105.0
2008-09-15 12:00:00	MSFT	Stock	27.23	27.4	27.19	27.33	8092362.0
2008-09-15 13:00:00	MSFT	Stock	27.34	27.41	27.1	27.22	8858873.0
2008-09-15 14:00:00	MSFT	Stock	27.22	27.34	27.11	27.12	8370057.0
2008-09-15 15:00:00	MSFT	Stock	27.12	27.26	26.73	26.75	20893340.0
2008-09-15 16:00:00	MSFT	Stock	26.89	27.186	26.77	27.101	5433065.0
2008-09-15 17:00:00	MSFT	Stock	26.82	26.86	26.7	26.7	492547.0
2008-09-15 18:00:00	MSFT	Stock	26.75	26.75	26.65	26.65	1794.0
2008-09-15 19:00:00	MSFT	Stock	26.65	26.68	26.58	26.65	12518.0
2008-09-15 04:00:00	NVDA	Stock	0.2475	0.2475	0.2475	0.2475	4000.0
2008-09-15 07:00:00	NVDA	Stock	0.2378	0.2378	0.2375	0.2375	28000.0
2008-09-15 08:00:00	NVDA	Stock	0.2462	0.249	0.2388	0.2402	589560.0
2008-09-15 09:00:00	NVDA	Stock	0.2402	0.2495	0.24	0.2435	83967640.0
2008-09-15 10:00:00	NVDA	Stock	0.2435	0.2475	0.2435	0.2458	95472640.0
2008-09-15 11:00:00	NVDA	Stock	0.2458	0.246	0.242	0.2425	84786440.0
2008-09-15 12:00:00	NVDA	Stock	0.2425	0.2458	0.2418	0.2422	83762920.0
2008-09-15 13:00:00	NVDA	Stock	0.2425	0.243	0.2342	0.2365	107736520.0
2008-09-15 14:00:00	NVDA	Stock	0.2365	0.2385	0.233	0.2332	143932480.0
2008-09-15 15:00:00	NVDA	Stock	0.2332	0.236	0.2295	0.2322	236477440.0
2008-09-15 16:00:00	NVDA	Stock	0.2328	0.2391	0.2312	0.2312	1095560.0
2008-09-15 17:00:00	NVDA	Stock	0.2325	0.2325	0.2312	0.2325	1286680.0
2008-09-15 18:00:00	NVDA	Stock	0.2325	0.2325	0.231	0.2322	60000.0
2008-09-15 19:00:00	NVDA	Stock	0.2318	0.2318	0.231	0.2318	52000.0
2008-09-15 07:00:00	AMZN	Stock	3.775	3.7905	3.775	3.7905	28900.0
2008-09-15 08:00:00	AMZN	Stock	3.806	3.831	3.7575	3.8125	494140.0
2008-09-15 09:00:00	AMZN	Stock	3.8275	3.921	3.815	3.886	20178640.0
2008-09-15 10:00:00	AMZN	Stock	3.883	3.994	3.8795	3.9825	26039860.0
2008-09-15 11:00:00	AMZN	Stock	3.981	3.986	3.931	3.948	17837140.0
2008-09-15 12:00:00	AMZN	Stock	3.948	3.9705	3.9015	3.946	26795420.0

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

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